Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

InstantDB is Drivin me NUTS!!!

 
Paul McKenna
Ugly Redneck
Ranch Hand
Posts: 1006
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!!!
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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"
 
Paul McKenna
Ugly Redneck
Ranch Hand
Posts: 1006
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic