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
Quote:
