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