Kbase 18893: Use correct driver manager to resolve Error: Microsoft ODBC Driver Manager Driver does not support t
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows 32 Intel
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
"Microsoft ODBC Driver Manager Driver does not support this function"
Merant ODBC driver
CAUSE:
ODBC driver manager being used is not the correct version.
ODBC applications that make ODBC level 3 API calls need the Microsoft 3.51 ODBC Driver Manager. This level 3 Driver Manager will accept ODBC level 2 API calls.
FIX:
The MERANT 3.5 ODBC driver requires the Microsoft 3.51 Driver Manager.
Search your entire machine, and any mapped drives across the network that you may have, for odbc32.dll
If you find more than one such file, delete all but the version 3.51 driver manager and its group of files - but first read on... Usually, the odbc32.dll is found in WINNT40\system32. Along with odbc32.dll, there should be several other ODBC files. This entire 'family' of files must be removed or renamed (if you are hesitant to remove them entirely - NOTE: ODBC driver managers are backward compatible.)
The 'family' of ODBC files can be seen in the ODBC Administrator by viewing the 'About' tab. There will be 7 files listed there, all beginning with odbc*.dll, and all in the same directory. (However, sometimes these files are copied and moved around; so, don't be surprised if your search results in other locations.)
If renaming them is your preference, just replace the .dll with .dl followed by an underscore. If you are going to remove them, you must first determine which ones to preserve.
Example:
Let's say you Find two odbc32.dll files: one in C:\I386\NETSRV\ODBC and the other in c:\WINNT40\system32. Right-click on each -> Properties, viewing the Version tab, to see if either one is version 3.51. That is the one you want to keep.
In this situation, the WINNT40 was the 3.51 version, and the other was 2.50. Thus, all the associated odbc*.dll files would need to be removed from the location of the 2.50 version just found.
How to determine which is the ODBC Driver Manager in use:
If you have MS Office installed, you can use msinfo32.exe to see a list of all the .dll's and which are running. The files for msinfo32 are more commonly found in:
\Program files\Common files\Microsoft\Shared.
Go to System Info, then system DLL's to see a list.