Announcement

REXYGEN forum has been moved. This one is closed.
Head over to the new REXYGEN Community Forum at https://forum.rexygen.com.

Looking forward to meeting you there!
 

#1 2016-10-16 22:10:55

soxso2011
Member
From: India
Registered: 2015-11-25
Posts: 37

Unable to Write in WAMP MySQL

I am unable to connect my database with the logic.Attached  Image is self explanatory.


https://www.rexygen.com/oldforum/img/m … /query.png

Offline

#2 2016-10-17 06:06:27

jaroslav_sobota
Administrator
Registered: 2015-10-27
Posts: 535

Re: Unable to Write in WAMP MySQL

Hi soxso2011,
additional information is always helpful and appreciated. Where is RexCore running? On the same Windows machine or somewhere else, e.g. Raspberry Pi? Can you connect to the MySQL server from command line?

Jaroslav

Offline

#3 2016-10-17 14:07:59

soxso2011
Member
From: India
Registered: 2015-11-25
Posts: 37

Re: Unable to Write in WAMP MySQL

Yes, MySQL is running on same computer, Also its accessible from command line. What is the  error which is appearing in log  indicating?

Offline

#4 2016-10-17 14:50:12

jaroslav_sobota
Administrator
Registered: 2015-10-27
Posts: 535

Re: Unable to Write in WAMP MySQL

Hi soxso2011,
the error means that there is no valid ODBC driver called "MySQL" (DRIVER=MySQL in your .rio file). On a typical Windows machine, the driver is "MySQL ODBC 5.3 Unicode Driver". You must have 32-bit ODBC Connector installed, get it here: https://dev.mysql.com/downloads/connector/odbc/

You need 32-bit version because REX is a 32-bit application.

To check the driver name, run C:\Windows\SysWOW64\odbcad32.exe, select the Drivers tab and look for MySQL. My Windows are in Czech so the screenshot probably does not help much, but I hope it's better than nothing:
mini_odbc-driver-win.png

Let me know if you need additional information.

Jaroslav

Offline

#5 2016-10-18 13:32:05

soxso2011
Member
From: India
Registered: 2015-11-25
Posts: 37

Re: Unable to Write in WAMP MySQL

I checked it all , attached images.This time I am using the program shared by you.Same error still persists!
https://www.rexygen.com/oldforum/img/m … 1/code.png
https://www.rexygen.com/oldforum/img/m … 1/odbc.png
https://www.rexygen.com/oldforum/img/m … rogram.png

Last edited by soxso2011 (2016-10-18 13:33:07)

Offline

#6 2016-10-18 23:29:54

jaroslav_sobota
Administrator
Registered: 2015-10-27
Posts: 535

Re: Unable to Write in WAMP MySQL

Hi soxso2011,
thanks for the screenshots. On Windows you need to use the following in your .rio file:

Connection "DRIVER=MySQL ODBC 5.3 Unicode Driver;SERVER=127.0.0.1;...

Your setting DRIVER=MySQL is valid only for Linux systems.

My original reply was not stating this clearly. Hope this helps.

Jaroslav

Offline

Board footer

Powered by FluxBB