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 Using DSN 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 "Using DSN" Watch "Using DSN" New topic

Using DSN

Ranch Hand

Joined: Oct 09, 2003
Posts: 517
Hi all;

There is a problem in my task.

Actually i have a .mdb file and i created a DSN to get access to that.But my appliation is run on linux and it will not support ODBC connect.So i decide to create the DSN in a Windows mechine and access that DSN from my application(through JDBC).Is it possible ?
If yes how can i do that?

Thanks in Advance.

God Gave Me Nothing I Wanted<br />He Gave Me Everything I Needed<br /> - Swami Vivekananda
Maximilian Xavier Stocker
Ranch Hand

Joined: Sep 20, 2005
Posts: 381
If you are asking (and I think you are) if you can access a DSN on a windows machine from Linux...

No it is not possible.

It sounds to me like you need a type 3 driver which is basically a proxy driver. In this scenario you run a server on the windows machine that you connect to with JDBC from your application and the server actually queries the database directly (using ODBC).

Another alternative is to reconsider what database you are using. Using Access on Linux platform is not a winning combination largely.
I agree. Here's the link:
subject: Using DSN
It's not a secret anymore!