Prob Trying to connect to SQL 2000

[Niall]

I'm running the demo and am having a problem when trying to set up SQL Server in Preferences / DB servers.

When I complete the Server Config details with name of server etc, I can't seem to go any further. Click OK and the status text on the far left of the screen flashes once "creating server and trying to connect" but then nothing happens. The only way to move on is to cancel.

I'm on W2k. I've downloaded the jdbc driver from Microsoft Site. I've placed the 3 .jar files in the Drivers folder of Servoy.

Is there anything else I should do?

Cheers

Niall

[Jan Aleman]

Which version of Servoy are you running? What data are you filling in the connection dialog? Below is an image that shows a working connection.

[Niall]

I'm using the demo Version R2 1.1-build 257


Config details:

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=<ODIN>;SelectMethod=cursor

localhost has been replaced with the IP address of the server

com.microsoft.jdbc.sqlserver.SQLServerDriver

Niall

[Jan Aleman]

Try to replace <ODIN> with ODIN (without the < and >)

[Niall]

Still the same I'm afraid

Is there a way of checking that I've installed the .jar files correctly ?

[admin]

I don't think it is a jar issue, if Servoy can't locate the driver it will print an error message for that. Can you delete ALL ms sql related connections and try it again then? You can also try 1.2RC2 which has improved error handling on connections. In the near future we will also make easier to use configuration screens.

[Niall]

All other connections are Firebird.

Where can I get 1.2 ?

[Jan Aleman]

More information and download links for 1.2RC2 can be found here:
http://forum.servoy.com/viewtopic.php?t=406

[Niall]

Thanks Jan. I've upgraded but am still having the same problem with no additional help message.

In case it's relevant, I have managed to setup an odbc connection to the same server. This seems fine until I go to add a form. I can see the tables but when I select one I get:

"java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"

Like I say, it may not be relevant.

[admin]

Is TCP/Ip enabled in the Server Network utility for SQL Server?
Is SQL Server authentication enabled? I don't think JDBC supports MS Windows authentication

[Niall]

Yes to both. I'm happily connecting to the server using Enterprise Manager and the sa username

[Niall]

I'm not convinced I've got the jdbc driver setup correctly.

The help file says to save the "compressed" driver in the drivers directory. I have three .jar files in there but not compressed?

Also, should I be doing something with classpath? If so what?

Should something else be pointing to the drivers or is that all done from within Servoy?

[Niall]

A few more pointers that may help.

I have the same problem when trying to connect to a different sql 2000 server and also with a v7 (although the jdbc driver I have is 2000 so that was just a punt)

I get the error mentioned above when trying to connect to existing tables using ODBC driver. However, if I ask to create a new table it works.

Is it possible that the existing tables are incompatible in some way?

Is JDBC better than ODBC in a Windows environment?

[Niall]

OK I take that back about being able to create tables using ODBC.

It allows me to go to the screen to add columns but when I add one I get:

Error creating table, java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index

[Niall]

Solved! Although not sure why.

I reinstalled the latest SQL JDBC drivers. (The version downloaded last week was 2.2.0022 and the one this week is 2.2.0029)

I then reinstalled Servoy and reconfigured the connection.

All seems fine.

thanks for your help Jan.

Niall