maxout
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Gallery
Posts posted by maxout
-
-
Thanks drjdpowell
-
Hi Team,
I am looking for a toolkit/driver which would allow me to connect to a Server based MySQL and be able to interface with the database. Do you know any free toolkits that would allow me to do that?
I have installed XAMPP in my Win10 machine and setup a MySQL server. Next, installed the Windows ODBC connector and tested and passed the connection. Now i would like to connect LabVIEW application to the database that is hosted.
It would be great if someone can help me figure out how can i connect and perform various read/write/modify tasks.
Thanks
Max.
-
Hi drjdpowell,
Thank you for the reply and hint.
Another question is it possible to generate .db file with specific columns and tables using the wrapper you provided?
Thank you,
Max
-
Hi Lava Citizens,
I am trying to implement SQLite - update function so i can easily modify values in a selected row.
http://www.sqlitetutorial.net/sqlite-update/
I have tried this statement - UPDATE ESD_User SET Name = 'James Bond', Status = 'Employee', Location = 'Canada' WHERE EmployeeID = 5; using the DB Browser for SQLite. The command does update the values as expected.
I am trying to do same with the labview + sqlite driver. I have attached the update user code.
I am getting an error from EXEC SQL
"SQLite.lvlib:Connection.lvclass:Execute SQL (Single String).vi:760001:Step on "UPDATE ESD_User SET Name = 'James Bond', Status = 'Employee', Location = 'Canada' WHERE EmployeeID = 5;"
SQLITE_BUSY: database is locked."
Can you please explain the cause of this error?Thank you,
max
Hosted DB & LabVIEW
in Database and File IO
Posted
Hi,
I am looking for a toolkit which would allow to connect and modify the hosted db from LV application.
What are the options? (excluding the Database Connectivity Toolkit).
max