Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Installed - MySQL ODBC 5.2w Driver - not work
sp_NewPost Add Reply sp_NewTopic Add Topic
May 31, 2013
1:19 pm
Henk Helmantel
Admin
Forum Posts: 1487
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

The following step by step instructions may help with the installation and set-up of the MySQL ODBC device driver and connection string on 64-bit versions of Windows:

  • Download and install the 32-bit version of the MySQL ODBC device driver
  • Start the 32-bits Windows ODBC manager program located on: "%systemdrive%\Windows\SysWoW64\Odbcad32.exe" with Administrator credentials
  • Select "System-DSN" and add a new ODBC driver
  • Select "MySQL ODBC 5.2 Driver" (or another version of the MySQL driver)
  • Fill in all the parameters and test the connection to the MySQL database
  • In the Diafaan SMS Server, use the connection string "DSN=MyDSN" (replace MyDSN with the DSN name that you entered in the ODBC manager)
May 31, 2013
10:51 am
Henk Helmantel
Admin
Forum Posts: 1487
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Kihong,

Have you tried the suggestions in one of my previous responses? If the 32-bit version of the ODBC driver is installed OK, it should be possible to add a new System DSN in the 32-bit version of the ODBC manager and use that as the connection string in Diafaan SMS Server.

Regards, Henk

May 31, 2013
10:36 am
Kihong
Guest
Guests

Same Problem to me...

October 22, 2012
9:47 am
Henk Helmantel
Guest
Guests

You can use the normal connection string for the MySQL ODBC driver. Diafaan SMS Server will automatically use the 32-bit driver.

Of course it is also possible to create a new System DSN in the 32-bit ODBC manager located at "%systemdrive%\Windows\SysWoW64\Odbcad32.exe" and use that in your connection string in Diafaan SMS Server.

Regards, Henk

October 21, 2012
4:37 pm
David
Guest
Guests

and how do I change this and call the driver on my diafaan?

October 9, 2012
10:10 am
Henk Helmantel
Guest
Guests

It does not matter if the 32-bits and 64-bits driver have the same version.

When you check if the driver is installed using the Windows ODBC manager program you should be aware that the 32-bits driver is not available in the 64-bit ODBC manager. There are in fact two versions of the ODBC manager program, one for 32-bit drivers and one for 64-bit drivers. The locations are:
32-bit drivers: %systemdrive%\Windows\SysWoW64\Odbcad32.exe
64-bit drivers: %systemdrive%\Windows\System32\Odbcad32.exe

Regards, Henk

October 9, 2012
4:11 am
David
Guest
Guests

Is it going to be easy if the both drivers have the same version? Just follow the default process, right?

October 5, 2012
8:21 pm
Henk Helmantel
Guest
Guests

Hi David,

This error is an indication that ODBC cannot find the MySQL ODBC driver. I see that you tried two connection strings, one for driver name {MySQL ODBC 5.1 Driver} and another for driver name {MySQL ODBC 5.2w Driver}. If you installed a MySQL ODBC driver for another version of MySQL, you might need another connection string. Perhaps you can find the required connection string in the documentation of the driver.

Another possibility is that you installed the 64-bits version of the MySQL ODBC driver. Diafaan SMS Server is a 32-bits program and requires the 32-bits version of the driver. The two versions of the driver can be installed simultaneously, there is no need to uninstall the 64-bits driver.

Regards, Henk

October 5, 2012
7:48 pm
David
Guest
Guests

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=smsserver; User=root;Password=;Option=3;

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

Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=smsserver; User=root;Password=;Option=3;
LOG: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Help-me

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 671

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1140

Posts: 3897

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1487