Andrei DANEASA

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 »

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:

Read the rest of this entry »