Skip to Content
Mar 31, 2016 at 03:12 PM

Advantage JDBC and Libre Office Base Issue


I'm not sure this is the right place to ask this but I figure I will start here...

In Architect v11.10 I created a new dictionary called 'data_test' and then created a simple table called 'users.' Now I'm trying to set up a JDBC connection to my Dictionary/table using the latest version of Advantage JDBC on a Windows 7 64-bit PC. I added the 'Class Path' to Java 1.8 and am trying to access my table on the ADS server using Libre Office Base version I have a screen capture of my settings in Libre Office Base attached. I can open my data-test.odb file and see my table listed but I get error 5174 and 7041 error when trying to open the Table via my Libre Office Base JDBC connection. It looks like the the path to the data_test.add dictionary file is being cut off and is displaying // ads-srv/data/data_test when it should be //ads-srv/data/data_test.add (see screen capture). I'm wondering if this might be a bug? Does anyone have any experience with Libre Office Base and ADS JDBC?

I looked up the errors and 5174 is DB Link failed to open and the second error 7041 is Table or Index is auto created and is expected behavior...




table err.JPG (29.5 kB)
java jdbc.JPG (79.9 kB)