| Author |
InstantDB is Drivin me NUTS!!!
|
Paul McKenna
Ugly Redneck
Ranch Hand
Joined: Jul 08, 2000
Posts: 1006
|
|
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!!!
|
Commentary From the Sidelines of history
|
 |
Frank Carver
Sheriff
Joined: Jan 07, 1999
Posts: 6919
|
|
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"
|
Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
|
 |
Paul McKenna
Ugly Redneck
Ranch Hand
Joined: Jul 08, 2000
Posts: 1006
|
|
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?? Thanks in advance
|
 |
 |
|
|
subject: InstantDB is Drivin me NUTS!!!
|
|
|