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

DSN-Less MSAccess connection issues

 
Willy Ray
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey All, using the methods listed in this thread:

http://www.coderanch.com/t/405966/java/java/Trying-access-Microsoft-Access-java

I'm trying to create a dsn-less connection to an Access Database.



I get down to "B", then I throw

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Any ideas?

/w
[ June 25, 2008: Message edited by: Willy Ray ]
 
Willy Ray
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oh, and when I do it like this (per the JavaRanch FAQ):



I get "java.sql.SQLException: General error"

/w
 
Willy Ray
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anybody?

/w
 
Wei Dai
Ranch Hand
Posts: 86
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maybe you type wrongly.
>String name = "C:\\CompAnnotator\\data\notes.mdb";
Should be
String name = "C:\\CompAnnotator\\data\\notes.mdb";
You can try
A full dns-less url:
"jdbcdbcRIVER=Microsoft Access Driver (*.mdb); "
+"DBQ="+name+"; "
+"ImplicitCommitSync=Yes; "
+"UserCommitSync=Yes; "
+"Threads=3; "
+"SafeTransactions=0; "
+"PageTimeout=5; "
+"MaxScanRows=8; "
+"MaxBufferSize=2048; "
+"DriverId=281; "
+"DefaultDir=C:/Program Files/Common Files/ODBC/Data Sources"
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic