Connection with SQL Server

[Anirban Das]

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]

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.
Thanks!
bear
JDBC Forum Bartender

[Joe Ess]

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

[Anurag Gupta]

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.