ms sql syntax

Classic Servoy
1

tried to use a mssql db for the 1st time:
the default url syntax proposed by servoy 5.1 is:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor
and should be:
jdbc:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor
the driver path is:
com.microsoft.jdbc.sqlserver.SQLServerDriver
and should be:
com.microsoft.sqlserver.jdbc.SQLServerDriver

also note that the driver to be used for sql2005 and sql2008 is sqljdbc4.jar only.

2

lesouef,

This link seems to describe the values we show as default, they don’t work with you sqlserver version?

http://support.microsoft.com/default.as … -us;313100

Rob

3

this is for sql2000, I am using 2005 or 2008.

4

lesouef:
tried to use a mssql db for the 1st time:
the default url syntax proposed by servoy 5.1 is:
jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor
and should be:
jdbc:sqlserver://localhost:1433;DatabaseName=<database_name>;SelectMethod=cursor
the driver path is:
com.microsoft.jdbc.sqlserver.SQLServerDriver
and should be:
com.microsoft.sqlserver.jdbc.SQLServerDriver

also note that the driver to be used for sql2005 and sql2008 is sqljdbc4.jar only.

+1

It is exactly what we use with MS SQL 2008

5

Will update the defaults,

Thanks,

Rob

6

may be you should distinguish versions as I assume sql2000 is still widely used.
I have none here so can’t check the right syntax for it.

7

lesouef:
may be you should distinguish versions as I assume sql2000 is still widely used.
I have none here so can’t check the right syntax for it.

You don’t need to, the new driver with the new syntax works for all MS SQL versions: 2000, 2005 and 2008 :mrgreen:

8

add-on for domain accounts usage to jdbc mount MS SQL dbs:
instead of specifying a user/passwd, leave it empty and add to the URL:
;integratedSecurity=true
url becomes: jdbc:sqlserver://ip:1433;DatabaseName=xxxxxxxxxx;SelectMethod=cursor;integratedSecurity=true
if this does not work, there is an extra sqljdbc_auth.dll to be installed in the system32 folder (in the windows path in fact), but for some reason I did not need that. this dll is in the microsoft package in “…\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\auth\x86\sqljdbc_auth.dll”
also, I have not tested this on a server where servoy is a service: it probably requires to start the servoy service with a specific account. in theory it should work, but not done this yet. If someone does that before me, please complete the information here.

9

correction: the sqljdbc_auth.dll is required.
the confusion comes from the fact that vista allows to move a dll around on the fly as long as you don’t delete it.
so only the service mode is to be tested with this.