Support forum
Add Reply
Add Topic1:19 pm
May 28, 2013
Offline
QuoteThe 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)
10:51 am
May 28, 2013
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
9:47 am
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
4:37 pm
and how do I change this and call the driver on my diafaan?
10:10 am
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
4:11 am
Is it going to be easy if the both drivers have the same version? Just follow the default process, right?
8:21 pm
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
7:48 pm
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
Most Users Ever Online: 529
Currently Online:
3 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 680
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1155
Posts: 3945
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1510