Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how access the DSN which is in other system

 
ganshre
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.
 
Frank Carver
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.
 
Tano Ortiga
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic