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)

"SimonT" <Si_tyler@mymail_hotmail.co.uk> wrote in message
news:OjCX2y%231KH...@TK2MSFTNGP05.phx.gbl...

[SimonT]

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

sorry and thanks

Si

"Sylvain Lafontaine" <sylvainlaf...@yahoo.ca> wrote in message
news:OKvlj9M2...@TK2MSFTNGP04.phx.gbl...