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
MySQL connection string
sp_NewPost Add Reply sp_NewTopic Add Topic
May 8, 2017
1:27 pm
Henk Helmantel
Admin
Forum Posts: 650
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Bul,

This error code means that ODBC is not able to locate the driver with the name '{MySQL ODBC 5.3.8 Driver}'. The first thing you can try is to drop the '.8' from the name:
Driver={MySQL ODBC 5.3 Driver};Server=localhost;charset=UTF8MB4;Database=smsserver;user=rompk;Password=grdrom082;Option=3;

If that does not work, you can also add a Data Source Name (DSN) to the Windows ODBC Manager and use that in the connection string. To add a DSN, open the 64-bits ODBC Manager for the 64-bit version of Diafaan SMS Server or the 32-bit ODBC manager for the 32-bit version of Diafaan SMS Server. Then click on the 'System-DSN' tab, add the new DSN for your driver and give it a namer, for instance 'Diafaan'.

The connection string that you use in Diafaan SMS Server will then simply be:
DSN=Diafaan

Regards, Henk

May 8, 2017
11:46 am
Bul
Guest
Guests

Hi Henk,

Im facing some issues with regard to the process of adding a SQL Connector.
Im using MySQL 5.3.8 64-bit version.
Can you please take a look at the configuration settings that don't seem to be allright
as im having this error :"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

My ODBC connection string is as follow:

Driver={MySQL ODBC 5.3.8 Driver};Server=localhost;charset=UTF8MB4;Database=smsserver;user=rompk;Password=grdrom082;Option=3;

Do i need to specify the path to the Driver or just keep as default {MySQL ODBC 5.3.8 Driver}.
What is the path to the 64-bit version of the driver on Windows 7 64-bit should i need to specify that.

Would be great to have a filed-in connection string exemple, with "real" values (paths and names).

NB: i have also installed the 32-bit version of ODBC connector; that is, on top of the 64-bit.

In advance, thank you for your help.

Best Regards,

Bul-Bul-J

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 410

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 598

Posts: 2054

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 650