wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC without DSN Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC without DSN" Watch "JDBC without DSN" New topic
Author

JDBC without DSN

Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2578

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

Joined: May 10, 2001
Posts: 3244
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.


Dave
Rene Larsen
Ranch Hand

Joined: Oct 12, 2001
Posts: 1179

Try this link (you can get a 30 days trial):
http://www.atinav.com/download/products/aveconnectJDBC1.htm
/Rene


Regards, Rene Larsen
Dropbox Invite
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC without DSN
 
Similar Threads
Connecting to a local (microsoft) database, best approach?
How to use File DSN in JDBC
What do I need to use Access with JDBC
how i can connect sql with my application without creating DSN
jdbcodbc for mac os x