How can I use a '.' in a JDBC data source path ?

asked 2016-04-15 23:06:24 +0100

pbmtech gravatar image

I am trying to use Libre Base v5.1.1.3 on my Windows 7 64-bit PC to connect to an Advantage Data Server table using Advantage JDBC (ADS is running on a SLES 11 SP4 VM). Using Advantage Arc v.11.10.0.24 on my Windows PC, I created a new Data Dictionary called 'data_test.add' and created a simple table. I installed ADS JDBC on my PC, added the class path in Java 1.8 and set up the connection via the connection wizard in Base. I tested the 'Test Class' and 'Test Connections' and those all work. My Data Source URL is 'JDBC:extendedsystems:advantage://ads-srv:6262;Catalog=//ads-srv/data/data_test.add' The issue is the '.add' file extension in the URL is appenting 'add' to my Table names so I can't open any tables. I've tried using quotation marks etc... around the . but have had no luck. Is this a bug or is there some way to allow a '.' in the Data Source URL?? I submitted a Bugzilla bug on this but have not had anyone look at it. (Bug 99032).

Thanks, Joe

edit retag flag offensive close merge delete