Change repository to sql server 2005

Classic Servoy
1

Servoy Developer
Version 3.5-build 513
Java version 1.6.0_02-b06 (Windows XP)
Sql Server 2005

Can anyone help on changing the repository server to sql server 2005.

I created the databases in Sql Server 2005 databases.

I have copied the sqljdbc.jar to the servoy drivers folder.

Server URL:
jdbc:sqlserver://Hamilton:1433;DatabaseName=repository_server;SelectMethod=cursor

(Hamilton is the server name)

Driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver

I tried this and get the following error message:

com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot find the object “servoy_groups” because it does not exist or you do not have permissions.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot find the object “servoy_groups” because it does not exist or you do not have permissions.

2

There are issues with the Microsoft driver. I suggest you use the open source jtds that comes with Servoy. That won’t give you any problems.

3

But it also sounds you are using an outdated MS driver anyway…

[Microsoft][SQLServer 2000 Driver for JDBC]

4

I changed the driver to the jtds and it works!

You guys are great!

Thanks