Question Locked

ODBC CONECTION FAILED

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to connect to an MSSQl Server on windows 2003 from a linux box specificly suse linux enterprise desktop via ODBC in crossover office. And this is what I get

CONNECTION FAILED
SQLSTATE: 01000
SQL SERVER ERROR: 11001
[MICROSOFT][ODBC SQL SERVER DRIVER][TCP/IP SOCKET]
CONNECTIONOPEN (CONNECT()).
CONNECTION FAILED
SQLSTATE: 08001
SQLSERVER ERROR: 6
[MICROSOFT][ODBC SQLSERVER DRIVER][TCP/IP SOCKET] SPECIFIED
SQL SERVER NOT FOUND

Please can anyone out there give me a solution. I have installed as many .dll as I think I should but ......

3 replies

by jszivos

Sounds like a connection or password problem. Can you ping the SQL server from the Linux box? Make sure you have the SQL server listening for connections. Here is an article on Microshaft's website about your exact problem:

http://support.microsoft.com/kb/818047

Microsoft actually has a decent database of support so I highly recommend reading it.

by toms45

poke around in the dark here, or you could post your connection string so we'd stand a chance of answering your question. As it stands, I could guess that you've got a typo, a down server, a locked port, dandruff, halitosis, or...you get the idea. Why are you installing DLLs? Is that some kind of Unix magic fix? At least I hope you will post your code. Maybe I can help...

This discussion is closed to new replies.