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

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][ConnectionOpen (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
.

Relevant Pages

  • Re: VFP Updates?
    ... Try talking ODBC or OleDb and they say HU. ... make up my apps so that what ever they want to run has to be from a command ... kind of connection and assign it the right to do exactly what you want. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • Re: OpenDataSource & stored procedure
    ... recognises the ODBC escape syntax. ... You shouldn't need the connection parameter since Word gets it from the ... return multiple result sets - enough to confuse software such as MS Query ... >>> The call works in MSQuery but won't return the data to Word. ...
    (microsoft.public.word.mailmerge.fields)
Loading