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

JDBC without DSN

 
Manish Hatwalne
Ranch Hand
Posts: 2596
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it possible to use JDBC w/o a DSN? Is it possible to use JDBC with the MS Access file directly?
TIA,
- Manish
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Manish
For an access file I dont think so. In order to do it DSNless then you'd need to have a different type of driver than an ODBC. I don't think there is one for Access. I know M$ just came out with one for SQL Server but I'm not positive about Access. You could go to google and try to do a search for a type 4 JDBC dirver with access as a keyword in the search statement.
 
Rene Larsen
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try this link (you can get a 30 days trial):
http://www.atinav.com/download/products/aveconnectJDBC1.htm
/Rene
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Manish Hatwalne:
Is it possible to use JDBC w/o a DSN? Is it possible to use JDBC with the MS Access file directly?
TIA,
- Manish
There are workarounds. The one I use for MSAccess and the jdbcdbc bridge is this ( no configuration or DSN setup required ) :

*NOTE - this method is VERY finicky. All the spaces in the connection string MUST stay the same. Failure to do this will cause exceptions.
**NOTE - ODBC driver implementations of MSAccess may be different, and thus this may not work for your computer
***NOTE - as you can see from the previous 2 notes, this probably isn't a solution to something that will go into production...then again using MSAccess isn't either
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic