Unable to create repository on SQL 2000 using MS JDBC driver

Classic Servoy
1

I am having difficulty using the MS JDBC driver and SQL 2000 server. This is a new install of Windows 2000, SQL Server 2000 SP3a, and MS JDBC driver SP1.

My settings are…
URL: jdbc:microsoft:sqlserver://mydbserver:1433;DatabaseName=Servoy_Repository;
Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

I try to create the repository and get this message…

“Error encountered while trying to determine if you server ‘repository_server’ supports binary columns: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can’t start a cloned connection while in manual transaction mode.”

What settings am I missing?

Thank you.

2

you have to add:

SelectMethod=cursor to the end of your URL. By default the ms driver uses the wrong selectmethod :shock:

Your complete URL will look like this:

URL: jdbc:microsoft:sqlserver://mydbserver:1433;DatabaseName=Servoy_Repository;SelectMethod=cursor

btw: if you use the auto setup server in the db servers pulldown than it will use this selectmethod by default.

3

That did the trick. Thank you very much. :D