Kind regards,
Jaroslav
Thank you for that, it worked.
All the best,
Adam
]]>Putting
Driver = /usr/lib/libmaodbc.so
into /etc/odbcinst.ini does the trick for me.
Let me know.
Kind regards,
Jaroslav
It seems the directory /usr/lib/odbc (or any odbc directory) does not exist on my WAGO. I have tried installing the latest version of the library again, but am finding the same thing. Is there something obvious I am missing as to why the directory isn't being created?
Regards,
Adam
]]>3. Install latest version of llibrary, e.g.
wget http://download.rexcontrols.cz/reposito … .2_arm.ipk
ipkg install mdbodbc_3.0.2_arm.ipk
Regards,
Milan Stetina
Happy New Year to you and everyone at Rex. i had to work on other projects for a while, so have only just had a chance to implement a MySQl connection.
I followed your instructions, but unfortunately I am getting the following errors, and no data is being input into my database; it appears to not be able to find 'libmaobdc.so'. do you have any suggestions?
2018-01-13;16:13:32.889;Error;Server: Connection from [::ffff:192.168.1.157]:51120 finished with error: Timeout (-102);
2018-01-13;16:13:56.359;Error;Server: Connection from [::ffff:192.168.1.157]:51123 finished with error: Timeout (-102);
2018-01-13;16:14:05.929;Error;DBDRV: connect to 'DRIVER=MySQL;SERVER=192.168.1.157;PORT=3306;DATABASE=sitecontrol;UID=BMS;PWD=****************;;' failed!!!! ([01000] [unixODBC][Driver Manager]Can't open lib 'libmaobdc.so' : file not found);
Thanks,
Adam
]]>MySQL connection on WAGO is fixed. Please, follow the instructions below:
1. wget http://download.rexcontrols.cz/reposito … .2_arm.ipk
2. ipkg install mdbodbc_3.0.2_arm.ipk
3. nano /etc/odbcinst.ini
4. Add following lines to the file:
[MySQL]
Driver = libmaodbc.so
Description = MariaDB Connector/ODBC v.3.0
Hope it helps.
Cheers, Tomas
]]>Best regards,
Jaroslav
Thank you again for sorting out the drivers. I have installed them and the MSSQL side of things is now working perfectly.
One note for the people like me reading this in the future who are not fully fluent in Linux, line 2 of the instructions above should read:
2. ipkg install freetds_1.00.67_arm.ipk - FIXED
Thank you again, and as ever your support is excellent and very much appreciated.
Adam
]]>Thank you very much for that. I will give it a go and let you know how I get on.
The project also involves connections to a mySQL database as well, if you are able to help me with the libraries for that as well I would be very appreciative.
Cheers,
Adam
]]>there are missing libraries for connection to particular databases. In order to use our ODBC driver for MSSQL you need to install FreeTDS library and also configure unixODBC connector as follows:
1. wget http://download.rexcontrols.cz/reposito … 67_arm.ipk
2. ipkg install freetds_1.00.67_arm.ipk
3. nano /etc/odbcinst.ini
4. Add following lines to the file (should be blank at the beginning):
[MSSQL]
Description=Microsoft SQL (FreeTDS) Driver
Driver=libtdsodbc.so
Now you should be able to connect to your database using REX. Let me know If you find any difficulties.
Do you also plan to connect to any other database?
Regards, Tomas
]]>Adam
]]>Kind regards,
Jaroslav
Have you had any luck with with ODBC driver for MSSQL/MYSQL yet? Is there any more information I can send over to help?
Cheers,
Adam
]]>In answer to your questions:
- The was not an instance of RExDraw or RexView connected to the device as far as I know
- There may well have been a HMI webpage open
- The device was communicating with 3 other devices via Modbus over TCPIP
I am happy to send you a copy of the project, I just request it is not shared outside of Rex Controls. I have sent it the support@rexcontrols.com address for your attention.
Have you had any progress with the ODBC driver for MSSQL?
Thank you very much for your help on this.
Regards,
Adam
]]>