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

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
0
ruavol2
Asked:
ruavol2
  • 6
  • 5
4 Solutions
 
cconstable_workCommented:
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
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
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
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
cconstable_workCommented:
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
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
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
 
cconstable_workCommented:
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
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
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
 
cconstable_workCommented:
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
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
Yes it worked. I really do appreciate what you did for me. it was awesome to get this working finally. Really great.
0
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
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
 
cconstable_workCommented:
I got the points, thank you.

Glad to hear it's all working.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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