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
posted 10 years ago
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.