jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Connection with SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection with SQL Server " Watch "Connection with SQL Server " New topic

Connection with SQL Server

Anirban Das
Ranch Hand

Joined: Nov 22, 2003
Posts: 63
I have installed Microsoft Sql Server 7.0 database.I want to know whether any Type 4 (Pure Java Driver ) comes with it. It will be nice if you kindly tell me what will be the JDBC URL for the Type 4 driver.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63208

Welcome to the Ranch Bamby!
You'll find this forum a great place to seek help on JDBC, and there aren't many rules you'll have to worry about, but one is that proper names are required. Please take a look at the JavaRanch Naming Policy and change your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
JDBC Forum Bartender

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Joe Ess

Joined: Oct 29, 2001
Posts: 9137

Originally posted by Bamby:
I have installed Microsoft Sql Server 7.0 database.I want to know whether any Type 4 (Pure Java Driver ) comes with it.

Microsoft making life easier on users rather than making life difficult for competitors (Sun and Microsoft have quite a history, if you don't know)? That will be the day. The Java SDK comes with a JDBC-ODBC bridge (class name sun.jdbc.odbc.JdbcOdbcDriver), but it is for "prototyping", not for use in production environments (per the documentation)
You can search among the various available JDBC drivers here:
JDBC Drivers

[How To Ask Questions On JavaRanch]
Anurag Gupta
Ranch Hand

Joined: Dec 13, 2001
Posts: 40
For SQL Server, One good JDBC Driver is available from Merant - now Known as Data-Direct --> http://www.datadirect-technologies.com
You could use either:
1) Merant SequeLink Server 5.X for jdbc - Type 3 Driver.
2) Connect for JDBC - Type 4 Driver.
That should solve your issues... atleast till the evaluation period of the driver expires.

Anurag Gupta
I agree. Here's the link: http://aspose.com/file-tools
subject: Connection with SQL Server
It's not a secret anymore!