MySQL Bugs: #41796: SQLConfigDataSource failed: Cannot find driver

Bug #41796	SQLConfigDataSource failed: Cannot find driver
Submitted:	30 Dec 2008 15:00	Modified:	8 Apr 2013 5:32
Reporter:	Anton Serbulov	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.1.5,5.1.8	OS:	Windows
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	SQLConfigDataSource failed: Cannot find driver

Description:
1. Install mysql-connector-odbc-5.1.5-win32.msi on Windows w2k3/w2k8 (x86/x86)
2. Add System DNS via SQLConfigDataSource
3. Result: 
---
Cannot find driver
Cannot find driver
Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed
---

How to repeat:
#include "stdafx.h"
#include "windows.h"
#include "odbcinst.h"
#include <iostream>

int _tmain(int argc, _TCHAR* argv[])
{
	#define countof(array)	(sizeof(array) / sizeof(array[0]))
	if (!SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN, 
		_T("MySQL ODBC 5.1 Driver"), 
		_T("DSN=qwe\0") 
		_T("Server=localhost\0") 
		_T("Database=mydb1\0") 
		_T("UID=mydbu1\0")
		_T("PWD=qweqwe\0")))
	{
		std::wstring m_errStr;

		for(WORD i = 1; i <= 8; ++i){
           DWORD errorCode;
           TCHAR errorMsg[SQL_MAX_MESSAGE_LENGTH];
           RETCODE ret = SQLInstallerError(i, &errorCode, errorMsg, (WORD)countof(errorMsg), NULL);
           if(ret == SQL_SUCCESS || ret == SQL_SUCCESS_WITH_INFO){
               if(!m_errStr.empty())
                 m_errStr += _T('\n');
               m_errStr += errorMsg;
           }
		}
		std::wcout << m_errStr.c_str() << std::endl;
	}
	return 0;
}

Suggested fix:
--- C:/mysql-connector-odbc-5.1.5r1144/util/installer.c	Sat Aug 09 00:07:56 2008
+++ C:/mysql-connector-odbc-5.1.5r1144/util/installer.c	Tue Dec 30 19:35:41 2008
@@ -999,7 +999,7 @@
 
   /* Get the actual driver info (not just name) */
   driver= driver_new();
-  memcpy(driver->name, ds->driver,
+  memcpy(driver->lib, ds->driver,
          (sqlwcharlen(ds->driver) + 1) * sizeof(SQLWCHAR));
   if (driver_lookup(driver))
   {

Sorry...

1. Install mysql-connector-odbc-5.1.5-win32.msi on Windows w2k3/w2k8 (x86/x64)

Anton, Thanks for your bug report. Is the application you've compiled a 32 or 64 bit application?

32-bit application

Bug#41867 was marked as duplicate of this report.

Hello,

I have the same problems, creating it with Setup Factory and VB6
With 3.51 it is working.
Allow me to define what I think the problem may be.
The DLL isn't in system32 directory anymore, but in the Program Files\MySql... what is not a defaultpath in windows.

Mike

We have the same error with MYSQL ODBC 5.1

Hi Anton and thanks for your report.

We have tested and discussed it but I won't go into details now. This appears to be the genuine problem, at least on my W2K8 server x64 box.

So, verified as described.

Problem was, driver lib was passed to ds_add(), which is normally set back to the name in ShowOdbcParamsDialog().

=== modified file 'setupgui/ConfigDSN.c'
--- setupgui/ConfigDSN.c        2008-03-18 02:12:19 +0000
+++ setupgui/ConfigDSN.c        2009-01-29 21:29:08 +0000
@@ -116,7 +116,22 @@
       rc= FALSE;
       break;
     }
-    ds_set_strattr(&ds->driver, driver->lib);
+    if (hWnd)
+    {
+        /*
+          hWnd means we will at least try to prompt, at which point
+          the driver lib will be replaced by the name
+        */
+        ds_set_strattr(&ds->driver, driver->lib);
+    }
+    else
+    {
+        /*
+          no nWnd is a likely a call from an app, no prompting so
+          we put the driver name already
+        */
+        ds_set_strattr(&ds->driver, driver->name);
+    }
   case ODBC_CONFIG_DSN:
 #ifdef _WIN32
     /*

Duplicate of bug#33825

Bug#43350 was marked as duplicate of this report.

Jess, I don't see the patch in main dev tree. Where is it pushed to and in which revision?

Hi,
I am just new to MySQL and I am facing the same problem. how can I get the patch for this. Please guide.thanks.

There is any news about this Bug?
I'm trying to create from VB 6.0 a DSN, see this http://support.microsoft.com/kb/171146 

It works perfectly if replace:

strDriver = "SQL Server" into this strDriver = "MySQL ODBC 3.51 Driver"

But it doesn't works when i try the 5.1 ODBC Driver:
strDriver = "MySQL ODBC 5.1 Driver"

Any one can Help?

Regards,

Pushed as rev 832, will be released in 5.1.6.

Related post http://forums.mysql.com/read.php?37,271033,271033#msg-271033

I am using Version 5.1.6r828_20090319_0836-win32 and I get the Driver not found error on ONE machine, whereas not on the other machine. Only obvious difference between the two is English XP on the working machine, German XP on the not-working one.
Code used was custom, but can be replicated with the Microsoft sample code with the link posted previously (kb171146)

Switching back to 3.51 makes the code work on all machines. I'm available for any inquiries concerning the differences of the two machines.

Hi Dennis,

Can you please check the following REG_SZ values in the registry of both English and German versions of WinXP:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<DSN_NAME>\DRIVER
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver\DRIVER
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver\SETUP

Thanks.

Interesting differences there:
First Working reg on English XP:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<DSN_NAME>\DRIVER
C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver\DRIVER
C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver\SETUP
C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5S.dll

-----------------------------------------------
now the not working reg on German XP:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<DSN_NAME>\DRIVER
--does not apply-- as Access reports Driver not found I cannot create the DSN - 
a manual creation via ODBC interface leads to correct "C:\windows\system32\myodbc5.dll" otherwise it is C:\windows\system32\myodbc3.dll for the 3.51 driver
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver\DRIVER
C:\windows\system32\myodbc5.dll
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 5.1 Driver\SETUP
C:\windows\system32\myodbc5S.dll
-----------------------------------------------

I notice only one point:
On the one machine the MySQL ODBC Connector was installed to Program Files on the other Machine to system32. Funnily teh driver cannot be found when installed in system32. I could try reinstalling all the drivers, but still want to report my findings.

Dennis,
Can you try again using at least rev 832? I just checked the snapshots which are at 835. You can download a copy here:

http://downloads.mysql.com/snapshots.php

Bug seems to be solved with version 5.1.6

I've run into similar problem. SQLConfigDataSource(NULL, ODBC_CONFIG_DSN, ...) simply deletes existing DSN.
Re-opening the bug.

when u trying to install mysql odbc drivers check the os 32 bit or 64 bit os 

after that u install depends on os u install 32 bit r 64 bit drivers u install  this is the cause 
urs 
mysql dba

Bug#58796 was marked as a duplicate of this report.

Lawrin?

Version 5.1.8 does not delete the DSN, but all fields are empty

The bug fix is posted for bug 66548.
Marking this report as Duplicate of 66548.