?
Solved

ODBC Connection

Posted on 2014-09-29
4
Medium Priority
?
527 Views
Last Modified: 2014-09-29
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
Comment
Question by:Ray Turner
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 40349744
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
 
LVL 44

Accepted Solution

by:
AndyAinscow earned 2000 total points
ID: 40349751
properties, build tab, platform target
0
 

Author Comment

by:Ray Turner
ID: 40350034
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
 
LVL 44

Expert Comment

by:AndyAinscow
ID: 40350148
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question