SQLServer 2000 Driver for JDBC - ERROR

Classic Servoy
1

Hi friends

I’m getting this annoying error whene I use MSSQL Server 2000

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can’t start manual transaction mode because there are cloned connections. [Microsoft][SQLServer 2000 Driver for JDBC]Can’t start manual transaction mode because there are cloned connections.

I’m using MSSQL Server for one of my solutions.

When I’m displaying the records in the list it’s not showing any error but if I edit any records, then I get the following error.

Please note that the SelectMethod=Cursor is set the connection by default but I’m still getting the error

Do I need to change the driver or something. If so where can I get the latest driver?

Thanks

2

We recommend switching to the JTDS driver. It is faster and more stable than Microsofts own driver (!). You will also find it in the Servoy 3.0 installer.
driver: net.sourceforge.jtds.jdbc.Driver
url: jdbc:jtds:sqlserver://SERVERIP/DATABASENAME

jtds.jar (274 KB)

3

Great!.. It worked

Thanks a lot Jan :D