jdbc to MS sql2008/instance/database

[neilnewman]

I am trying to create a "Database Connection" within Ebase to a SQLserver 2008 database running within an instance using the following URL:
jdbc:jtds:sqlserver://sql2008:1433;instanceName=IDOX;DatabaseName=UniformLiveReports;integratedSecurity=true;
however it does not work, do the Ebase database connections support the type of syntax used above, or am I doing something completely wrong?

[Jon]

Two things:

1. The general format of the connection string is jdbc:jtds:sqlserver://<server_name>/<database_name>;instance=<instance_name>;property1=xxx;, so in your case:

jdbc:jtds:sqlserver://sql2008:1433/UniformLiveReports;instance=IDOX;

I don't think the DatabaseName property is supported by the JTDS driver.

2. Also the integratedSecurity property is not supported by JTDS. If you want to use Windows authentication, you should use the domain property instead and specify a specific Windows user and password - here are more details http://jtds.sourceforge.net/faq.html - see the domain property.

The alternative is to use Sql Server authentication instead of Windows authentication, then you explicitly define a user/password within SQL server and specify these on the connection.

Regards
Jon

[neilnewman]

Hi Jon,
Many thanks for the swift reply, if I cannot get the "jtds" driver to work, I will try to deploy the Microsoft JDBC driver into Ebase and hope that this does the job.

Kind regards
Neil

[Jon]

Yes, you should be able to use the Microsoft driver. It's many years since we tested this; there used to be many problems, but they are probably fixed by now.

[neilnewman]

Hi Jon,
Finally got it working with:
jdbc:jtds:sqlserver://sql2008;instance=IDOX;DatabaseName=UniformLiveReports

Thanks for all your pointers
Neil