Access2010 redistribuible + runtime e ODBC issue

B

bonale

Hi, I have a little Access Application that use ODBC to connect with SQL Server via ODBC. I try to install on a pc without Access and the installationworks properly. I have a problem when I try to open a form: I have an error "ODBC: Connection to 'DataSourceName' doesn't work"... 'DataSourceName' in ODBC Panel COntrol exist and works properly...

TIA,
Al3x
 
D

Douglas J Steele

Have you created the DSN on the target machine? (Access doesn't do that for
you...) Going DSN-less is easier to distribute. If you're interested, I show
one approach at http://www.accessmvp.com/DJSteele/DSNLessLinks.html

wrote in message

Hi, I have a little Access Application that use ODBC to connect with SQL
Server via ODBC. I try to install on a pc without Access and the
installation works properly. I have a problem when I try to open a form: I
have an error "ODBC: Connection to 'DataSourceName' doesn't work"...
'DataSourceName' in ODBC Panel COntrol exist and works properly...

TIA,
Al3x
 
Top