Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

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

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
ASKER CERTIFIED SOLUTION
Avatar of cconstable_work
cconstable_work

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

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!
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes it worked. I really do appreciate what you did for me. it was awesome to get this working finally. Really great.
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.?
Avatar of cconstable_work
cconstable_work

I got the points, thank you.

Glad to hear it's all working.