Using DSN

[MInu]

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.

[Maximilian Xavier Stocker]

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.