How do I connect to Microsoft SQL Server 7?

Frequently asked questions. Look here before posting questions. If you don't find an answer here you can post your question to the most appropriate forum.

How do I connect to Microsoft SQL Server 7?

Postby Jan Aleman » Wed Aug 04, 2004 10:55 am

To connect to Microsoft SQL Server 7 you will need to use a third party JDBC driver, Microsoft only offers a free JDBC driver for Microsoft SQL Server 2000. There are some excellent JDBC drivers available for Microsoft SQL Server 7, we have good experience with the inet sprinta driver. You can download that driver here:

http://www.inetsoftware.de/English/prod ... efault.htm

1. In the ZIP file you download you will find the file Sprinta2000.jar, copy that file to the Drivers folder inside the main Servoy folder.
2. Under the Edit menu, choose Preferences, go to the DB Servers tab. Click on New. Choose "com.inet.tds.TdsDriver" in the Driver pulldown. Name the server ms_sql (for example) and fill in the username and password. In the Database Server URL fill in the following:
jdbc:inetdae7:hostname:portnumber?database=MyDb
replace hostname with the name or ip of the sql server
replace portnumber with the portnumber the sql server listens on (default 1433)
replace MyDb 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'r unable to resolve the error please place a post on the forum or send an email to [email protected]
Jan Aleman
Servoy
Jan Aleman
Site Admin
 
Posts: 2074
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Return to FAQ

Who is online

Users browsing this forum: No registered users and 3 guests

cron