This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Svelte and Sapper in Action and have Mark Volkmann on-line!
See this thread for details.
Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

how access the DSN which is in other system

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am having a Data Source Name in my server(say system1) . I want to connect this DSN from a Client(Say System2). Is it Possible ? if so, Kindly Reply me.
 
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"ganshre",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please choose a new name which meets the requirements.
Thanks.
 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There could be other better ways to solve this. But this is what I would do if i were in to solve your case.
OPTION 1:
If security is not an issue. I would share the System1's DB file on a network and point the client's DB connection to the DB using the UNC (network path).
OPTION 2:
If I want to have a more secured DB access (not to mention more elegant). I will make use of RMI. Create an RMI application server in System1 which "hosts" connection to the DB. And then have the clients connect to this RMI server. The clients would pass query, delete, update and insert SQL commands to the RMI server. The RMI server would then execute this commands on the DB in behalf of the client.

I hope this helps.
Jonathan
 
    Bookmark Topic Watch Topic
  • New Topic