Having given up on making a connection to MS ACCESS, I decided to check out Instant DB upon seeing a few references in the list here. I installed it successfully, added all the references to my classpath and was able to import the 2 packages well. I am also able to load the instantdb driver, but the problem is when i say my url. example : String URL = "jdbc:idb:sample"; String username = ""; String password = ""; con = DriverManager.getConnection (URL,username,password);
I recieve the error message Problems connecting to sample. What in world should I do to get one JDBC program working!!!
I've used InstantDB many times successfully, so stick with it. Looking at your JDBC URL, I'm surprised at the "sample" at the end. Bear in mind that InstantDB requires a valid, accessible, filename in this position. Have you actually got a file called just "sample" in the working directory of your java program? I usually use (for example) "sample.prp", "sample.properties", or "sample.idb", and make sure that the path to the file is included if necessary, ie: "jdbc:idb:../conf/sample.idb"
Yea Frank, Sample is in my directory. But is still giving me weird errors. However, I finally got my ACCESS connection to work and am quite satisfied with it. But, tell me something.. I read somewhere in this forum that ACCESS does not support certain JDBC features. How true is this? And do I HAVE to connect to ACCESS via a jdbc-odbc bridge.. cant i directly find a jdbc driver for ms-access??