Connection to MS SQL Server 7.0? 
Author Message
 Connection to MS SQL Server 7.0?

Hi,
Do I need to install a jdbc driver in my computer if I want to connect to MS
SQL Server 7.0. If so, where can get this driver? I find a JDBC driver for
SQL Server 2000, not for MS SQL Server 7.0. Thanks.
And connection to the server, is the following correct?

// Load the driver class
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Connection databaseConnection =
DriverManager.getConnection("jdbc:microsoft:sqlserver://server:1433;Database
Name=msdb","username","password");

I think those are suitable to MS SQL Server 2000, but whether they are
suitable for MS SQL Server 7.0?

Can anybody help me? Thanks.

Yihan



Tue, 01 Nov 2005 04:03:04 GMT
 Connection to MS SQL Server 7.0?

Quote:

> Hi,
> Do I need to install a jdbc driver in my computer if I want to connect to MS
> SQL Server 7.0. If so, where can get this driver? I find a JDBC driver for
> SQL Server 2000, not for MS SQL Server 7.0. Thanks.
> And connection to the server, is the following correct?

> // Load the driver class
>    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

> Connection databaseConnection =
> DriverManager.getConnection("jdbc:microsoft:sqlserver://server:1433;Database
> Name=msdb","username","password");

> I think those are suitable to MS SQL Server 2000, but whether they are
> suitable for MS SQL Server 7.0?

> Can anybody help me? Thanks.

If the mS driver succeeds in connecting to the SQL7 dbms then it will
be fine, but MS wants to 'encourage' customers to upgrade to SQL2000,
and has put code in it's current driver to artifically fail to connect if it finds
that the DBMS is SQL7... It actually conencts and does a query to find
the DBMS version, and quits (for no other reason than marketing) if
it's SQL7.

Joe Weinstein at BEA

- Show quoted text -

Quote:

> Yihan



Tue, 01 Nov 2005 05:03:37 GMT
 Connection to MS SQL Server 7.0?

Quote:

> Hi,
> Do I need to install a jdbc driver in my computer if I want to connect to MS
> SQL Server 7.0. If so, where can get this driver? I find a JDBC driver for
> SQL Server 2000, not for MS SQL Server 7.0. Thanks.
> And connection to the server, is the following correct?

> // Load the driver class
>    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

> Connection databaseConnection =
> DriverManager.getConnection("jdbc:microsoft:sqlserver://server:1433;Database
> Name=msdb","username","password");

> I think those are suitable to MS SQL Server 2000, but whether they are
> suitable for MS SQL Server 7.0?

You can use older version of JDBC driver from Microsoft which works just
fine. There is also opensource driver http://jtds.sourceforge.net.

- Sampsa

--
     -------------------------------------------
    // Sampsa Sohlman                        //
   //  My email can be found on my homepage //
  //   http://sampsa.sohlman.com           //
-------------------------------------------



Tue, 01 Nov 2005 17:54:48 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Problem with Connection Pervasive SQL 2000 an MS SQL Server 7.0

2. Problem with Connection Pervasive SQL 2000 an MS SQL Server 7.0

3. MS Access97/SQL Server 7.0 Connection

4. No. Of Concurrent ODBC Connections open in MS-SQL Server 7.0

5. Sybase SQL Server 11.0.3 to MS SQL Server 7.0 Migration Experiences

6. connection to SQL SERVER 7.0 via OLE-DB using COGNOS IMPROMPTU 7.0 tool

7. MS SQL Server through MS Access 7.0

8. How to migrate from MS-ACCESS to MS-SQL server 6.5/7.0

9. Can I install full MS SQL Server 7.0 not just client utilities on MS Windows 98

10. Migration from MS Access 7.0 to MS SQL Server 6.5 - NEED HELP

11. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro

12. SQL Server 7.0 on NT Server to SQL Server 7.0 on win2k Pro


 
Powered by phpBB® Forum Software