ODBC connection in new version mysql - Posted (7440 Views)
sikandar
Junior Member
sikandar
Posts: 135
135
hi all,
I have a challenge that on windows 2003 there was no challenge but now I am trying same setup on 2008 but getting error as now even mysql version is changed from 3.2 to 5 so kindly let me know what will be new connection method or string as getting following error,

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/forums/inc_header.asp, line 121

Thanks in advance.
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Podge
Support Moderator
Podge
Posts: 3776
3776
Have you installed the ODBC connector for MySql? http://dev.mysql.com/downloads/connector/odbc

Are you on 64bit windows?
Podge. The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts.
Posted
Davio
Development Team Member
Davio
Posts: 12217
12217
Originally posted by Podge
Have you installed the ODBC connector for MySql? http://dev.mysql.com/downloads/connector/odbc

Are you on 64bit windows?

I did install the latest drivers (5.1.11) and I am on 64bit windows 7. Got the same error as initial poster on the setup.asp page.
I had downloaded and installed the 64bit version of the odbc driver, but the mysql documentation had said the installer also installs both 32 bit and 64 bit versions.
Connection string being used:
strConnString = "driver={MySQL ODBC 5.1 Driver};option=16387;server=localhost;user=***;password=***;Database=snitz;"

Will keep searching for a solution, but if anyone have any ideas...
Support Snitz Forums
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
Can you connect to the database through other means? Say, using SQLYog?
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
Davio
Development Team Member
Davio
Posts: 12217
12217
In fact, I created the database using SQLYog, and setup a database user just for the forum using SQLYog. So that is an affirmative.
I use MySQL Workbench to manage (start/stop) the server.
Support Snitz Forums
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
If you try to create an ODBC data source, are the drivers listed there?
Also, if you ping localhost, do you get a reply? Have you tried using the IP instead - am just trying to rule out any networking issues from this. I think I had to add an entry for localhost in my hosts file when I started using IIS on my Windows 7 x64.
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
Davio
Development Team Member
Davio
Posts: 12217
12217
Yeah, the driver is listed. Made sure to check before and after I installed them. Under the driver tab:
Name: MySQL ODBC 5.1 Driver
Version: 5.01.11.00
Company: Oracle Corporation
File: MYODBC5.DLL
Date: 4/28/2012

Took a try at creating a user DSN connection, using MySQL ODBC drivers. Tested the connection on the DSN creation window and it tested ok. Saved it. Edited config.asp. And tried setup.asp again and same error.
Have you tried using the IP instead
I tried 127.0.0.1 as the server ip address and still got the same error. Tried it with the DSN as well, same error.
I'll check my host file in a few mins and get back to you.
Support Snitz Forums
Last edited by Davio on 03 June 2012, 15:26
Posted
Davio
Development Team Member
Davio
Posts: 12217
12217
Ok, I think I am getting somewhere here.
Referred to this MS article on the error:
http://support.microsoft.com/kb/306345

It seems it is a permissions problem, that the IIS anonymous account doesn't have permissions to access the registry that contains the information about the specific ODBC driver.
I granted the registry key (which is a subkey under HKLM\SOFTWARE\ODBC\ODBCINST.INI), READ permission for the IUSR account, and ran setup.asp again. Now I have this error:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
From my search it seems I am using a 64bit driver with my 32bit application pool.
Looks like I will need to uninstall the 64 bit mysql driver and install the 32 bit.
Will see how that works out.
Support Snitz Forums
Last edited by Davio on 03 June 2012, 16:19
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
Do not connect through DSN. There is no need to do that. Just use the DNSless Snitz connection string.
I am pretty sure I didn't need to do anything regarding the registry, but I did start with the 3.51 driver.
Snitz 3.4 Readme | Like the support? Support Snitz too
Posted
Davio
Development Team Member
Davio
Posts: 12217
12217
Uninstalled the 64bit version and installed the 32bit version of MySQL Connector/ODBC drivers. The driver did NOT show up in the ODBC Data Source Administrator list of drivers, like the previous 64bit driver did. Not sure why. Maybe it only lists 64bit drivers?
But it works now using the DSN-less connection string. strConnString = "driver={MySQL ODBC 5.1 Driver};option=16387;server=127.0.0.1;user=***;password=***;Database=snitz;"

Setup went fine. Tables created without errors.
I'll try creating a DSN connection using the myodbc-installer.exe command line utility next time. (In the same folder as where the myodbc drivers are)
Support Snitz Forums
Posted
ruirib
Snitz Forums Admin
ruirib
Posts: 26364
26364
You don't need the 32 bit drivers. I am using the 64 bit and it works fine.
Snitz 3.4 Readme | Like the support? Support Snitz too
You Must enter a message