How do I connect to Microsoft SQL Server 2000?

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 2000?

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

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 [email protected]
Jan Aleman
Servoy
Jan Aleman
Site Admin
 
Posts: 2072
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

404.mspx

Postby jorgegoi » Tue Feb 07, 2006 2:46 am

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).

:(
jorgegoi
 
Posts: 1
Joined: Tue Feb 07, 2006 2:41 am

Postby Jan Aleman » Tue Feb 07, 2006 5:25 pm

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/
Jan Aleman
Servoy
Jan Aleman
Site Admin
 
Posts: 2072
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

JTDS Driver

Postby ellenmeserow » Mon Feb 13, 2006 5:32 am

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...
ellenmeserow
 
Posts: 354
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Postby ROCLASI » Mon Feb 13, 2006 10:20 am

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.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Postby ROCLASI » Mon Feb 13, 2006 10:24 am

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.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5230
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Connect SQL 2000-2005 MSSQL Server

Postby [email protected] » Mon Feb 13, 2006 10:49 am

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 ??
Harry 199
[email protected]
 
Posts: 9
Joined: Thu Apr 22, 2004 12:02 pm
Location: Linz, Austria

Ready to Try New Driver

Postby ellenmeserow » Wed Aug 02, 2006 8:26 pm

I need a connection string for this new driver then we'll test it out... Anyone?
ellenmeserow
 
Posts: 354
Joined: Sat Aug 07, 2004 10:18 pm
Location: Seattle, WA USA

Postby admin » Wed Aug 02, 2006 8:34 pm

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.
admin
Site Admin
 
Posts: 72
Joined: Wed Apr 23, 2003 4:29 pm


Return to FAQ

Who is online

Users browsing this forum: No registered users and 2 guests

cron