| Author |
 Topic  |
|
sikandar
Junior Member
Pakistan
135 Posts |
 Posted - 17 January 2012 : 02:17:47
|
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. |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 06:43:00
|
quote:
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
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 12:47:43
|
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
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 June 2012 : 13:13:26
|
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 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 15:26:01
|
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.
quote:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Connection string used:
strConnString = "snitz_dsn"
quote:
Also, if you ping localhost, do you get a reply?
Yes, ping localhost works fine.
C:\Users\David>ping localhost
Pinging Scooby-Doo [::1] with 32 bytes of data:
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Ping statistics for ::1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
quote:
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
|
Edited by - Davio on 03 June 2012 15:26:28 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 16:17:27
|
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:
quote:
[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
|
Edited by - Davio on 03 June 2012 16:19:34 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 June 2012 : 16:43:27
|
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 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 16:48:39
|
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
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 17:02:38
|
Well rui, if you have other suggestions you want me to try with the 64bit version of the driver, I'll try it.
I'll uninstall the 32bit and reinstall the 64bit. |
Support Snitz Forums
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 17:15:29
|
Reinstalled the 64bit. Dropped the "snitz" database and created an empty 1.
Gave the subkey "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver" READ permission for the IUSR account and ran setup again.
Same error: "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Will download and try the 3.51 driver. But isn't the latest version based on the 3.51? At least, it's what I read in the docs.
|
Support Snitz Forums
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2012 : 17:44:32
|
I installed the 64 bit version of the 3.51 driver (Custom Install gave the option to install both 32bit and 64bit. Made sure that 32bit was unselected), using the following connection string:
strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=localhost;user=***;password=***;DATABASE=snitz;" '## MySQL w/ MyODBC v3.51
Got the same error again.
Gave READ permission to the subkey "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver" for the IUSR account and ran setup again. Same error again.
Uninstalled the 64bit 3.51 driver, installed the 32bit version of it, and ran setup.asp and it works.
Seems to be the 32bit version works in both cases. Probably because it is a 32bit app we are using? |
Support Snitz Forums
|
Edited by - Davio on 03 June 2012 17:46:10 |
|
|
|
Topic |
|
ODBC connection in new version mysql
