a problem about connect to access with ODBC

  • Thread starter Thread starter YEE
  • Start date Start date
Y

YEE

System.Data.Odbc.OdbcConnection conn = new
System.Data.Odbc.OdbcConnection(@"Driver={Microsoft Access
Driver(*.mdb)};Dbq=C:\abc.mdb;Uid=Admin;Pwd=");


when invoke conn.Open(); the program throw an OdbcException

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
 
Hello Yee,

Access isn't my area of expertise. However, check to see if the @
should appear in the DSN-less connection string. The string looks good
otherwise, based on sample strings I've seen. Double check the
location of the database and rule out any visibility issues on the
folder that contains it. Perform comparative testing with an actual
System DSN. Also, insure that this problem isn't caused by the app/
provider being 64bit and the data source being 32bit or vice versa.
HTH

Netrista Khatam
Technical Services Manager
OpenLink Product Support
OpenLink Software
 
Back
Top