• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Using DSN

 
Ranch Hand
Posts: 517
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 381
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
What's gotten into you? Could it be this tiny ad?
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic