Bug #41923 Unable to install "MySQL ODBC 3.51 Driver" on win2003
Submitted: 7 Jan 2009 12:54 Modified: 7 Jan 2009 18:28
Reporter: agamoto m Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51 OS:Windows (x64)
Assigned to: CPU Architecture:Any
Tags: MySQL ODBC 3.51 Driver, ODBC, Win2003

[7 Jan 2009 12:54] agamoto m
Description:
Hi Guys,

I've just download a mysql odbc 3.51 driver from http://dev.mysql.com/downloads/connector/odbc/3.51.html

I've installed in my local machine (MS Windows XP Pro, 2002, Service Pack 3) and everything worked fine. I was able to configure a new odbc using datasource in administrative tools and test the connection. Everything was great. I inclusively use the new odbc on the web based application i'm building with vs2008.

Then, i wanted to do the same on my server so others users could access the application, but i was unable to install the driver. I had run the instalall.bat a couple of times and nothing. No message, nothing. 

So i opened the bat to see what does and i did the same manually.
Then i tried to do the following commands to register the driver

ODBCCONF.EXE /a {REGSVR C:\WINDOWS\system32\myodbc3.dll}
ODBCCONF.EXE /a {INSTALLDRIVER "MySQL ODBC 3.51 Driver|Driver=myodbc3.dll|Setup=myodbc3.dll"}

the first one give me the following erro:
REGSRV unable to load "C:\WINDOWS\system32\myodbc3.dll": 193: (weird caracters) with error code -2147467259

the second one didn't give any error. 

then i went to the administrative tools odbc to see if the driver was created and effectively was. But when i tried to create a new odbc using the driver i've received a system error 193 saying that it was not possible to load the driver. i understand why. the instalation failed.

My server uses MS Windows Server 2003 R2, Standard Edition, Service pack 2

what i'm doing wrong?

Could you please advise? i'm in a deadline for a presentation tomorrow. any help would be appreciated.

tks in advance

José

How to repeat:
run the install.bat on windows 2003 server
[7 Jan 2009 15:33] Jess Balint
Thanks for your bug report. Have you copied myodbc3.dll and myodbc3S.dll to C:\Windows\System32? Is there a reason you do not use the installer package?
[7 Jan 2009 15:42] agamoto m
Hi Jess,

Tks for your anwser. 

Yes, i've copied the files.

I didn't use because i haven't found one.

I download mysql-connector-odbc-noinstall-3.51.27-winx64 because it was the only one available.

Is there another that i should be using instead?

Tks
[7 Jan 2009 16:00] Jess Balint
I would recommend using MySQL Connector/ODBC 5.1 which does have an installer for 64-bit Windows. Please see the downloads page: http://dev.mysql.com/downloads/connector/odbc/5.1.html#winx64

The result of running Install.bat is only to add some entries in the registry. However, since you are using 64-bit Windows, it becomes a little more difficult to have the correct alignment of programs when running Install.bat. To verify the installation, do the following:

* Check that a new REG_SZ entry has been created (MySQL ODBC 3.51 Driver=Installed) in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers
* Check that the new has been created at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver
* Make sure the Driver and Setup paths are correct in this new key

If instead you discover that the new key has been created at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver, this means the driver has been installed in the 32-bit registry branch.

Regarding the error message, it doesn't seem to be recognized: 193 is not a valid Windows network message number.
[7 Jan 2009 17:22] agamoto m
I follow your sugestion and download odbc 5.1 but whenever i try to run it at my server i receive the following error "This installation package is not supported by this processor type" (mine is in portuguese, i had to translate).

What does this means? My server isn't a x64 application?

tks
[7 Jan 2009 17:59] agamoto m
Ok, i figured what my problem was (besides my stupid analysis)

I thought that my SO was x64 and i downloaded that driver, but know i tried with a x86 and worked :o. i really thought that ws 2003 was x64.

I'm really really sorry with the time you lost with this

Thank you Jess
[7 Jan 2009 18:02] agamoto m
The problem was solved using MySQL Connector/ODBC 5.1 Windows MSI Installer (x86)
[7 Jan 2009 18:28] Jess Balint
Ok, glad it's working.