How do I connect to Microsoft SQL Server 2000?

Classic Servoy
1
  1. Download and install the free JDBC driver
    a. Download the files from: http://www.microsoft.com/sql/downloads/jdbcregister.asp
    b. Locate the following files in the download: msbase.jar, msutil.jar and mssqlserver.jar, place those files in the Drivers directory inside the main Servoy directory.
  2. Under the Edit menu, choose Preferences, go to the DB Servers tab. In the “Auto Setup Server” pulldown choose “MS SQL”, this will prefill most of the required values for you. Fill in a server name and fill in the username and password. Now make the following adjustments to the Database Server URL:
    -replace localhost with the name or ip of the sql server (if necessary)
    -replace 1433 with the portnumber the sql server listens on (if necessary)
    -replace <database_name> with the name of the database you want to connect to
  3. Click OK. If you see no error you are able to establish a connection with the database. If you get an error click on details, if you’re unable to resolve the error please post what errors you get on the forum or contact support@servoy.com
2

Hello:
I am trying to connect to a SQL server 2000; and I am getting stuck in trying to download the free JDBC driver from the microsoft site. The URL provided, http://www.microsoft.com/sql/downloads/jdbcregister.asp , returns the following error:

Page Not Found
The page you were looking for has moved or no longer exists or you might have entered an incorrect Web site address (URL).

:(

3

I would recommend not using that driver but the JTDS driver. It has become a beter alternative than Microsoft offering. You can download it at:

http://jtds.sourceforge.net/

4

Question: I am using the JTDS 1.1 driver and having a massive bug with SQL Server whenever we use any number 10million or higher. So I’m trying to download 1.2 from the site you provide above, and I get the zip file – but can’t find the driver within the hundreds of files that unpack. Looking for jtds-1.2.jar based on the name of the file I have for 1.1 – not there. Help? Thanks in advance…

5

Don’t unzip the zip file. Your browser named the file wrong (it changed the extension).
It should be a .jar so rename the file and you are set.

6

Erm, I can’t delete or edit my post…odd.

Anyway I was wrong about the renaming issue (although that seem to happen a lot on Windows systems).
I downloaded the file and the jtds-1.2.jar file is right there in the root of the package.

Hope this helps.

7

There is a new driver in town.
Check this out.

http://www.microsoft.com/downloads/deta … laylang=en

Type 4 JDBC works with (JDK) version 1.4 and higher.

Could anybody (Servoy) test this new felllow ??

8

I need a connection string for this new driver then we’ll test it out… Anyone?

9

Microsoft suggests the following: After the package unpacks, see the “Using the JDBC Driver” topic under Overview of the JDBC Driver in the Help documentation. The Help documentation is installed as Default.htm in the Sqljdbc_1.0\Enu\Docs folder in your installation directory.