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 |
|
tbone542
Starting Member
1 Post |
 Posted - 2006-05-07 : 12:07:37
|
| Newbie here.Please excuse my confusion.I am trying to set up a odbc connection to a remote sql server. It is sql server 2000.I use the odbc data source administrator wizard to try to connect and it gives me the error below and it won't connect.Connection Failed:SQlState: '01000'SQL server Error: 10050[Microsoft][ODBC SQL server dirver][TCP/IP Sockets]Connection Open (Connect()).Connection failed:SQL State : '08001'SQL Server Error: 11[Microsoft][ODBC SQL server dirver][TCP/IP Sockets]General network error. Check your network documentation.I can connect fine with enterprise manager. I choose one of the servers I already have set up.Am I missing something?I am trying to set up an odbc that can be used by an application.Any ideas?Thanks,T |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-05-07 : 16:00:26
|
| remote connection ?did you, set up your client network utility?did you register your server? |
 |
|
|
|
|
|
odbc and sql server