I can connect to SQL Server 7 via ADO 2.5 without any problems.... if it
possible with the same connection strings, basically without changing any
code, to connect to SQL Server 6.5

any idea's or thing to watch for would be appreciated,
thanks

Alex Wilson

It depends on connection string. If you are connecting
usinf DSN, then I think there is no difference in
connection string. If you are connection using DSN-less
connection string with SQLOLEDB provider, then I think you
will need to change provider. I am not sure (I may be
wrong) if you can use SQLOLEDB to connect to SQL 6.5. i
think you need to use ODBC.
Here is site with different connection strings.

http://www.able-consulting.com/ADO_Conn.htm

Val