File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 63854

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] [About Bear] [Books by Bear]
Joe Ess

Joined: Oct 29, 2001
Posts: 9189

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 -->
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:
subject: Connection with SQL Server
It's not a secret anymore!