Solved

How do I correct this ODBC driver error in Access on my Windows 2008 Server 64 bit machine

Posted on 2010-09-12
11
5,609 Views
Last Modified: 2013-12-01
I have been trying to setup an Access ODBC driver under the System DNS under datasource ODBC in Administratove tools on my Win 2008 Server 64 bit. As you can see from the images below the errors. I have not been able to. I have seen the Microsoft article but I am not sure how to do this.
 See kb artilcle:   http://support.microsoft.com/kb/260558/

Under the " resolution section " I am trying to identify whether I should be creating a folder like this one in the "kb"
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)
Then do I create two keys inside that folder like this:

Driver = C:\WINNT\System\Odbcjt32.dll
Setup = C:\WINNT\System\Odbcjt32.dll

I also do not understand if I am supposed to completely remove the  odbcjt.dll file out of the c:Windows\System32\ folder. The "kb" says that will cause an error? Will that screw things up or can I just copy/drag it over to the  c:Windows\System  folder and it should be okay? I am just a bit concerned even though I have backed the registry up.
Notice the folder in the registry does not have anything in the ODBCINST.INI registry folder see:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI  

I cannot tell exactly what I need to do here. If it said create a folder then ..... create a key with "xyz" in it I could figure it out. Maybe they make it that way so the novice like me stays out and away from this stuff. If anyone can help clarify this please let me know thank you.

Registry-ODBCDriversNotFound.png
AccessDriverError.png
AccessDriverError2.png
0
Comment
Question by:ruavol2
  • 6
  • 5
11 Comments
 
LVL 3

Accepted Solution

by:
cconstable_work earned 500 total points
ID: 33659435
Hi,

Checkout http://support.microsoft.com/kb/942976 for using the right control panel tool.

Also http://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/

Also I believe you can only run one version either the 32bit or the 64bit not both at the same time, so if you have other applications that need different versions then you are out of luck.

I have attached a screenshot of my 2008 32bit server so you can see the registry setup. Basically the files listed there need to be the correct paths to the files. I believe the file you have in the SysWOW64 folder is the one needed for 64bit so you would need to modify the registry values to point there instead of System32.

Hope this helps.
2008-32bit.png
0
 

Author Comment

by:ruavol2
ID: 33659530
I think I actually need the Microsoft Access Driver (*.mdb,*.accdb) So I guess I need to figure out what that is ACEODBC.DLL "I think" and you are saying that for the driver folder
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Microsoft  Access Driver (*.mdb,*.accdb)  that I would need to put all the same "keys" I think they are referred to having probably all the same modifications except where the setup and driver keys ( "under name, type, data " areas) are I need to point to the root of the sysWOW64 folder.
Do I really need all that other stuff "name" called Default, APILevel, ConnectFunctions, ODBCDriverVer....etc or is that just extra fluff.

I had read at one time way back that these files might need to be registered. If I register them does that apply all the appropriate stuff seen in your screenshot above.

Also do I need to put the under the sub folder I have which is :
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers .....then under

\Microsoft  Access Driver (*.mdb,*.accdb)

 or as you have it just under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\

By the way thanks. This makes it a lot clearer than it was before there.........cconstable!
0
 

Author Comment

by:ruavol2
ID: 33659559
How do I know what I need to create from the menu below based on copying your example?
or do I need again just the driver and setup pointing to the proper file path?

Registry-Menu.png
0
 
LVL 3

Assisted Solution

by:cconstable_work
cconstable_work earned 500 total points
ID: 33659697
Hi Ruavol2,

Unfortunately I do no have a 64bit version of 2008 to play on. I do have the 64bit version of Windows 7 and it has a different location for the configuration which is at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI perhaps it is the same on 2008?

If everything you need is setup there then just add the following string (REG_SZ) to your ODBC Driver folder in the registry:
Microsoft Access Driver (*.mdb) = "Installed"

Once that is done use the C:\WINDOWS\SysWOW64\odbcad32.exe version of the tool to add the driver on the System DSN.

Hope this works for you.
0
 

Author Comment

by:ruavol2
ID: 33659735
This is what I have after adhering to your answer. I hope I did this right?
I put his into the modify area of the registry key: %WINDIR%\SysWOW64\ACEODBC.DLL
Should I have put C:\Windows\SysWOW64\ACEODBC.DLL   instead?

Also note the subfolder for me is the ODBC Drivers
Yours is under the  "\ODBCINST.INI\  folder mine has an extra layer

I do not see your Microsoft Access Driver (*.mdb, *.accdb) can you show that as an example or no? Let me know if and how I might need to register this file. Thanks again.


Registry-NowAfterAddingDriverSet.png
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 3

Assisted Solution

by:cconstable_work
cconstable_work earned 500 total points
ID: 33659880
Hi Ruavol2,

First thing to try is look at the locations I mentioned above, it may already be setup the way you need just in a different location in the registry. please see the attached image for my windows 7 64bit setup.

Note the locations of each folder in the registry. Please check in 2008 and tell me if they are there.
If so you should only have to run the correct version of ODBC which is at C:\WINDOWS\SysWOW64\odbcad32.exe and try doing what you were doing before.
win7-64bit.png
0
 

Author Comment

by:ruavol2
ID: 33675370
The following are screen shots of what is in the registry. However I am not sure if the settings are pointing to the right locations on the Win2008Server. Please reveiw as I still cannot create a Microsoft  Access Driver (*.mdb,*.accdb) on that machine to connect to a Crystal Report Developer application and run a report. Please let me know if you see my error........and above all thank you for this fantastic support.

From what I can see it would appear that I would need to point the Driver and Setup file path locations to this folder:
%WINDIR%\SysWOW64\ACEODBC.DLL..........also does it matter if I have the % in there or do I need the C:\  

ODBCDriversInstalled32bit.png
ODBCAccessSettings32bit.png
ODBCDriversInstalled64bit.png
ODBCAccessSettings64bit.png
0
 
LVL 3

Assisted Solution

by:cconstable_work
cconstable_work earned 500 total points
ID: 33678085
From your screenshots it looks like it is all setup correctly so you do not need to touch the registry.
Did you run C:\WINDOWS\SysWOW64\odbcad32.exe and try creating the System DSN from there?
0
 

Author Comment

by:ruavol2
ID: 33678648
Yes it worked. I really do appreciate what you did for me. it was awesome to get this working finally. Really great.
0
 

Author Comment

by:ruavol2
ID: 33683175
I do not know why but this question would not let me reward points to you. I do not know what to do. How can I correct that.?
0
 
LVL 3

Expert Comment

by:cconstable_work
ID: 33683806
I got the points, thank you.

Glad to hear it's all working.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now