Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mixxalot
Starting Member
1 Post |
Posted - 2008-04-21 : 17:55:16
|
Hi all-I setup a new ODBC connection to MS SQL Server 2000 on Windows XP and keep getting the following errors when I try toeither register a new SQL Server 2000 group within Enterprise Manager or test the new ODBC connection:Current configuration- MS SQL Server 2000-Windows XP-ODBC 3.85.1117Errors:I. Within SQL Server 2000 Enterprise ManagerError: SQL Server connection openII. When I test the ODBC connection:Microsoft SQL Server ODBC Driver Version 03.85.1117Running connectivity tests...Attempting connection[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.TESTS FAILED!Now here is what has me totally confused:I can use the command line ISQL to access the database on the server and IP is all correct and port is available.Any tips how to get this ODBC working?ThanksBen Prusinski |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-21 : 22:04:55
|
Tried connect with ip address and port number instead of instance name? |
|
|
|
|
|