Unable to create repository on SQL 2000 using MS JDBC driver

[SShell]

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.

[Jan Aleman]

you have to add:

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

Your complete URL will look like this:

Code: Select all

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.

[SShell]

That did the trick. Thank you very much.