Anyone using SQL 2005?

Classic Servoy
1

When trying to use a sql2005 express db I get the following error.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (“”): Data type 0x38 is unknown. [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (“”): Data type 0x38 is unknown.

I tried to use sql2005 both as the repository and as a datasource.

The tables and relations can be viewed but data can not be extraced

2

Yes, very ugly that one! I wasn’t able to connect to SQL Server 2005 either. Use this driver instead:

As URL you have to put this into the connection string:

jdbc:jtds:sqlserver://your_server:1433/database

Hope this helps.

P.S.: Servoy will deliver this driver with the next release.

3

java.sql.SQLException: Cannot open database “database=servicemanagement” requested by the login. The login failed.

I tried this on both a sql2005 and a 2000 server both same error?

4

changed url to:

jdbc:jtds:sqlserver://localhost:1433/;TDS=8.0

5

Use

jdbc:jtds:sqlserver://your_server:1433/servicemanagement

instead of

jdbc:jtds:sqlserver://your_server:1433/database=servicemanagement
6

We have a new MS SQL 2005 server with a Navision 4.00 SP1 database. I have installed the driver from sourcefoge.net as mentioned above. Now I can see the tables in Servoy. I also can create a form but when I want to load it I get the following error:

java.sql.SQLException: Incorrect syntax near ‘-’.

7

Servoy 2.2.4 does not escape tables with ‘-’ currently, it escapes sql names only for spaces… we can make you a new build to overcome this.

8

I ran a real life test comparing the jtds driver version 1.2 versus the most recent jdbc driver from microsoft. The platform was Windows 2003 Server, Windows XP clients. Java 1.4.9. SQL Server 2000 and I did not test 2005. The jtds driver was noticiably slower and I noted much heavier utilization of server resources with the jtds driver. I’m going to continue to use the driver provided by microsoft.

John McCann
Servoy 2.2.4

9

John:

I, too, am running an almost exact setup as your MS SQL 2000 / WIN2003 server.

I am using the i-Net Sprinta driver and wanted to upgrade to the latest verison.

Have you had any experience with it or the Opta or Merlina drivers?

Also, how do I tell which verison of JDBC I am running?

Thanks!

JM