Database URL

Classic Servoy
1

I need to connect to a sql server 2005 database

This is the URL I am using:
jdbc:jtds:sqlserver://orbsql\gpd_pilot:1261;DatabaseName=OIF;SelectMethod=cursor

with this driver:
net.sourceforge.jtds.jdbc.Driver

Any ideas on how to get this to work? I would never name a sql server like that, but I have to use it.

Thanks.

2

Any error message?

3

I can only assume that the name is the problem since you mention it.
Maybe the backslash is interpreted as an escape character. In that case you need to escape the backslash with a backslash.

jdbc:jtds:sqlserver://orbsql\\gpd_pilot:1261;DatabaseName=OIF;SelectMethod=cursor

Hope this helps.

4

This is the error I got when I added the backslash to the url:

org.apache.commons.dbcp.DbcpException: java.sql.SQLException: Unknown server host name ‘orbsql\gpd_pilot’.
java.sql.SQLException: Unknown server host name ‘orbsql\gpd_pilot’.
java.net.UnknownHostException: orbsql\gpd_pilot

5

And what error message did you get when you used 1 backslash ?
By the way, why not just use it’s IP addres ?

Hope this helps.

6

Using the ip address in the url will allow me to attach to the database.

Thanks for your help.

7

Try the following:

jdbc:jtds:sqlserver://orbsql:1261;DatabaseName=OIF;SelectMethod=cursor;instance=gpd_pilot
8

jdbc:jtds:sqlserver://orbsql:1261;DatabaseName=OIF;SelectMethod=cursor;instance=gpd_pilot

That works also…

Thanks a lot.