MS SQL Server ODBC - ODBC over internet works in ODBC Manager, but not in application

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ODBC over internet works in ODBC Manager, but not in application

MrO via SQLMonster.com

2005-04-19, 11:23 am

I have been using an application for some time now. It uses an ODBC
connection to connect to a computer in the local network. It works fine.

Now I need to use this application on a remote location, so I configured an
ODBC on my laptop. When I press 'TEST', the test is succesful. But when I
start the program I get the folowing error:

[DBNETLIB][Connectio
nOpen (Connect()).]SQL Server does not exist or access
denied.

I've installed the enterprise manager and it can connect to the remote
server perfectly.

How can this be resolved?

Tnx

--
Message posted via http://www.sqlmonster.com

Sponsored Links