File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes InstantDB is Drivin me NUTS!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "InstantDB is Drivin me NUTS!!!" Watch "InstantDB is Drivin me NUTS!!!" New topic

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

Joined: Jan 07, 1999
Posts: 6920
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", "", or "sample.idb", and make sure that the path to the file is included if necessary, ie:

Read about me at ~ 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
I agree. Here's the link:
subject: InstantDB is Drivin me NUTS!!!
It's not a secret anymore!