DSN Creation for SQL 6.5greenspun.com : LUSENET : SQL Server Database Administration : One Thread |
Dear Kohnen,Currently in my machine sql server 7.0 client has been installed. I'm trying to create a DSN for sql server 6.5 which resides in another domain. I'm using TCP/IP protocol. The system displays following error message.
[microsoft][odbc sql server driver][tcp/ip sockets]connectionopen. connection failed. check your network documentation.
Kindly give me the reply.
Regards, T.Karthikeyan
-- Anonymous, July 12, 2001
Karthik,I think the Microsoft Knowledge Base article, "PRB: ODBC Connection Failed: SQLState: '08001' DBMSSOCN" at http://support.microsoft.com/support/kb/articles/Q195/5/66.ASP will probably explain the problem.
Good Luck,
Eric
-- Anonymous, July 13, 2001