You are not logged in.
- Topics: Active | Unanswered
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!
Pages: 1
Topic closed
#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.
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
Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!
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:
Let me know if you need additional information.
Jaroslav
Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!
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
Monarco HAT for Raspberry Pi - Lightweight I/O for monitoring, archiving and control.
Raspberry Pi in industrial automation!
Offline
Pages: 1
Topic closed