*
The moose likes JDBC 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
Bookmark "Using DSN" Watch "Using DSN" New topic
Author

Using DSN

MInu
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.
 
 
subject: Using DSN