DSN Connection problem

[SimonT]

Hi Guys,

I have a problem with an application I have completed. It appears that the
DSN connection info is not being applied when I try and open the
application.

If I look at my tables the link is there, and hovering over I can see the
connection string to the server ok and it looks fine, however as soon as I
try to open a table, I get an error box saying:

ODBC -- connection to xxxxxx failed

I have done this before with other applications, and it works fine from the
machine I have developed the application, it is simply the deployed version
does not connect (I have checked the internet connect is live)

Any suggestions or where I can look would be appreciate

Regards
Si

[Sylvain Lafontaine]

First, you must make sure that the DSN has been created on the target
machine; second, you must create a System DSN, not an User DSN.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

Post by SimonT
Hi Guys,
I have a problem with an application I have completed. It appears that the
DSN connection info is not being applied when I try and open the
application.
If I look at my tables the link is there, and hovering over I can see the
connection string to the server ok and it looks fine, however as soon as I
ODBC -- connection to xxxxxx failed
I have done this before with other applications, and it works fine from
the machine I have developed the application, it is simply the deployed
version does not connect (I have checked the internet connect is live)
Any suggestions or where I can look would be appreciate
Regards
Si

[SimonT]

Doh!! of course it has to be system DSN...sorry I had created a user DSN !!

sorry and thanks

Si

Post by Sylvain Lafontaine
First, you must make sure that the DSN has been created on the target
machine; second, you must create a System DSN, not an User DSN.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

Post by SimonT
Hi Guys,
I have a problem with an application I have completed. It appears that
the DSN connection info is not being applied when I try and open the
application.
If I look at my tables the link is there, and hovering over I can see the
connection string to the server ok and it looks fine, however as soon as
ODBC -- connection to xxxxxx failed
I have done this before with other applications, and it works fine from
the machine I have developed the application, it is simply the deployed
version does not connect (I have checked the internet connect is live)
Any suggestions or where I can look would be appreciate
Regards
Si