On SQL Server 2005 Express Edition (I don’t know how’s on full version, never had a license for it) the default connection model is through named pipes and TCP/IP is disabled.
If you want to connect to it from Oracle SQL Developer using jTDS driver it will throw a generic connection failure, as he is trying just TCP/IP. The error looks like this:

In ordrer to enable TCP/IP you have to do a few steps:
Read the rest of this entry »
Tags:
howto,
jtds,
sql developer,
sql server,
tcp/ip
10 Comments »
Best way to have a easy to access XE database and APEX on top of it is to put them on a Ubuntu Server virtual machine that I start just when I need.
Installation of 10g Express Edition should not take more than 10 minutes and the steps are below:
1. Prepare the swap space
If you have less than 1GB memory run the following commands to create swap space:
$ sudo dd if=/dev/zero of=/swpfs1 bs=1M count=1000
$ sudo mkswap /swpfs1
$ sudo swapon /swpfs1
Read the rest of this entry »
Tags:
10g,
download,
Jaunty Jackalope,
Linux,
oracle,
XE
20 Comments »