wicked23
I know things...
- Messages
- 398
- Location
- Pennsylvania
I'm running windows XP pro and I'm getting an error everytime I try to connect a new ststem data source, in the odbc data source administrator box. I've googled the error and none of the recommended fixes worked.
here is the error:
Microsoft SQL server login
connection failed:
sql state:'01000'
sql server error:10061
[microsoft][odbc sql server driver][tcp/ip sockets]connectionopen(connect()).
connection failed:
sqlstate:'08001'
sql server error:17
[microsoft][odbc sql server driver][tcp/ip sockets]sql server does not exist or access denied.
Now i know this issue is only on one machine. It has nothing to do with permissions etc. It worked then after i tried to connect 2 the tables using access 07 it screwed something up.
I tried deleting the connection and reestablising another in hopes it would get corrected, this also gives me an error.
I noticed when I add the new sql server driver, when I go to connect to the server, my server is in the drop down box twice. I think the problem lies here.
In every other pc it is in only once. I can connect to other servers but not the one I need . This has stumped alot of people.
Is there any way to resetthat list of servers to get rid of the glitch?
here is the error:
Microsoft SQL server login
connection failed:
sql state:'01000'
sql server error:10061
[microsoft][odbc sql server driver][tcp/ip sockets]connectionopen(connect()).
connection failed:
sqlstate:'08001'
sql server error:17
[microsoft][odbc sql server driver][tcp/ip sockets]sql server does not exist or access denied.
Now i know this issue is only on one machine. It has nothing to do with permissions etc. It worked then after i tried to connect 2 the tables using access 07 it screwed something up.
I tried deleting the connection and reestablising another in hopes it would get corrected, this also gives me an error.
I noticed when I add the new sql server driver, when I go to connect to the server, my server is in the drop down box twice. I think the problem lies here.
In every other pc it is in only once. I can connect to other servers but not the one I need . This has stumped alot of people.
Is there any way to resetthat list of servers to get rid of the glitch?