Trying to migrate a large project from MSAccess to LOBase & MariaDB.
I have created with MariaDB a small test DB which contains a single table and two records. When I try to connect to it using LOBase Connect to External DB/MySQL/External connect/Direct Connect give it DB name, User Name and PW and it appears to connect.
BUT looking at the Tables area in Base, I can see all the DBs in the folder listed as if they were tables, with the tables within them as sub-items. This includes MariaDB’s DB controlDBs! I just want to see the tables for the DB I’m connecting to.
Secondly, if I open the table in my testDB, I can see the contents, but cannot add data.
I’ve searched Google for LOBase/MariaDB and OOBase/MySQL and all permutations and only come up with obsolete tutorials that don’t work. Can someone point me to some help on this subject. I’m kind of going crazy and the client wants something to see soon!!!
I’m running on Ubuntu 13.04/Raring Ringtail.