Hi Avi,
Thanks for your suggestion. I tried it and obviously had a lot work information to work with.
I have now finally discovered that there is a serious TCP/IP problem on my notebook. SQL Server 2000 is running with the correct drivers installed and changing the TCP/IP port in the network utility doesn't help either. On doing a port scan i found that only the application server as well as the windows default ones that get used gets displayed. SQL Server as well as a few other applications that open ports don't get listed under TCP/IP. Reinstalling it and resetting the TCP/IP stack did not fix the problem either.
Datasource
==========
<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="jdbc/Sonora"
location="jdbc/Sonora"
xa-location="jdbc/xa/SonoraXADS"
pooled-location="jdbc/Sonora"
ejb-location="jdbc/Sonora"
connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
username="sa"
password="sa"
url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor"
inactivity-timeout="30"
max-connections="200"
min-connections="3"
wait-timeout="10"
max-connect-attempts="10"
/>
Trace Debug Console
===================
Created new physical connection: com.evermind.sql.DriverManagerXAConnection@f864fe
null: Connection com.evermind.sql.DriverManagerXAConnection@f864fe allocated (Pool size: 0)
06/04/14 07:36:34 new DebugConnection(2)
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:35 Error connecting to database:
06/04/14 07:36:35 Retrying 2 times more...
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:37 Error connecting to database:
06/04/14 07:36:37 Retrying 1 times more...
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:39 Error connecting to database:
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:41 Error connecting to database:
06/04/14 07:36:41 Marked rollback from enlistresource
06/04/14 07:36:41 closing DebugConnection(1)
06/04/14 07:36:42 Oracle Application Server Containers for J2EE 10g (9.0.4.0.0) initialized
Thanks and Regards
Sean