aspose file tools*
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Using DSN
 
Similar Threads
working with access?
java.sql.SQLException: No suitable driver
Connect to DSN
how dsn can be used on deployment server
how dsn name is recognised by the website host