Re: MS SQL Server.....again

The error states that either your ip,port are incorrect in the ODBC settings or that your login/password is incorrect.

In the ODBC administrator, you can test the connection to verify that the ip/port and login/password are set correctly. ODBC Administrator -> Data Source -> Test Connection.

HTH,

Jason L. Froebe

Team Sybase member

No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1

Comment on Re: MS SQL Server.....again

Replies are listed 'Best First'.
Re^2: MS SQL Server.....again by Losing (Acolyte) on Nov 09, 2006 at 21:26 UTC
Thank you very much, I tested the connection, and this is the response: `[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not + exist or access denied.` [download]	[reply] [d/l]
Re^3: MS SQL Server.....again by jfroebe (Parson) on Nov 09, 2006 at 21:32 UTC
Understood. You will want to check with your local MS SQL Server DBA. He/she can set you up with the correct info as to ip/port and a login/password. It may be that the sql server is set up integrated (Windows Authentication) authentication. If that is so, then there is more work to be done by the DBA. Jason L. Froebe Team Sybase member No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1	[reply]