unable to access specific database in MS SQL Server 2000

Classic Servoy
1

I’m just evaluating Servoy with some MS SQL server 2000 databases.

For some DB it’s running fine but with others I got two kinds of problems:

  1. login fails although I set up properly with this connection string: “jdbc:microsoft:sqlserver://xxxx.dupuis.be:1433;DatabaseName=prospection_test;SelectMethod=cursor”. I got the message: “cannot setup server” with detail:“java. sql.sqlexception Microsoft …Cannot open database requested in login ‘prospection_test’. Login fails”

What seems very odd is this message is that ‘prospection_test’ is not the login but the database name.
Sure the login and password are correct as I use those accessing this DB with other tools.

  1. For other databases, Servoy refuses to work with table with no primary key though there is a primary key.
2

Are you sure you haven’t made a typo anywhere? The error message is correct it indicates it can’t open a certain database with the credentials you supplied.

With which database are you having primary key problems?

3

It seems that primary keys with auto-increment feature are not recognized by Servoy.

4

Server auto enter and/or increment is not supported in the current version of Servoy. It will be supported in Servoy 1.5 which is expected to be available in december of this year.

5

jaleman:
It will be supported in Servoy 1.5 which is expected to be available in december of this year.

I’m waiting with baited breath. The ability to work along with other technologies using the DB, such as PHP, will make the app even that much better!