• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 531
  • Last Modified:

ODBC Connection

Dim inNewConnetion As OdbcConnection = New OdbcConnection(String.Format("Driver={{Microsoft Access Driver (*.mdb, *.accdb)}}; Dbq={0}; Uid=admin; Pwd=;", inAccessDBName))

inNewConnection.Open()

When I try to open the connection I get the following error.  How do I fix this?

Unable to load odbcji32.dll

OS: Windows 8.1
Apps installed: MS Access 2013
0
Ray Turner
Asked:
Ray Turner
  • 3
1 Solution
 
AndyAinscowCommented:
At a guess (the 32 in the error message) you have compiled your app as any cpu (or explicitly 64 bit cpu) which means it can't call a 32 bit dll.
The solution is to change the properties of your app so it compiles only as 32 bit.
0
 
AndyAinscowCommented:
properties, build tab, platform target
0
 
Ray TurnerSenior ConsultantAuthor Commented:
After making the suggested change I get the following error:

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

What's needed to fix this?
0
 
AndyAinscowCommented:
That is a totally different question (sounds like the ODBC connection you want to use is not configured) , you ought to close this and ask a new question for that.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now