64 bit Control Panel

[Ztruker]

ODBCCP32.CPL must have been installed by an application as it it not anywhere on my Windows 7 Pro system. There are no ODB*.CPL files anywhere on my system actually.

 

[gregrocker]

Have you tried post #2.................After all the help you are getting we are almost back to #2

Just tried this, not only did it not work but Windows, in its infinite wisdom, decided to overwrite the boot record. Now I have lost access to the other OS that I had installed on my system.

Regards
Bidski

Use EasyBCD 2.0 to Add your second OS back to dual boot.

 

[WindowsStar]

I have an idea:

What happens if you copy the ODBCCP32.CPL to the \windows\system32 dir so you have one in the SysWOW64 and the System32. Do you have 2 icons in the control panel?? One for 32bit and the other for 64bit?

 

[Jeffster]

The problem is as follows

Control Panel shows "ODBC (32-bit)". The ODBC control panel file (ODBCCP32.CPL) is located in the SysWOW64 directory, but it is running the 64 bit version of ODBC (as shown by the lack of a *32 in task manager and by the ODBC About page showing files in the System32 directory).

ODBC is also not showing a lot of drivers that are shown by running SysWOW64\odbcad32.exe. I believe this is because they are 32-bit drivers and so the 64 bit version of ODBC doesnt recognise them.

Does that spell it out more clearly?

Regards
Bidski

So Bidski, if the problem is simply that you aren't seeing both 64-bit and 32-bit odbc drivers, create a new icon for those 32-bit odbc drivers. That's what I did.

Go to C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools

Right click on Data Sources (ODBC) (or whatever the current icon you have is) then copy, then right click and create a shortcut in the same directory.

Rename the new icon (or change the name of the original one since it says it's for 32-bit data sources but isn't)

Right-click on the new icon and go to properties, then click on the 'Shortcut' tab if it isn't already active.

Change the target from %windir%\system32\odbcad32.exe to %windir%\sysWOW64\odbcad32.exe (and change the "Start in:" directory as well)

Click OK, and you should have two data sources, one that points to all your 64-bit drivers, one that points to your 32-bit drivers.


Hope that helps!