Programming Help

Web Development



What's Here?

  • Members: 136,871
  • Replies: 480,650
  • Topics: 74,929
  • Snippets: 2,567
  • Tutorials: 675
  • Total Online: 1,660
  • Members: 94
  • Guests: 1,566

Welcome to Dream.In.Code
Become an Expert!

Join 136,871 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,660 people online right now. Registration is fast and FREE... Join Now!




How we can ftech the database of Remote PC i.e connected throught inte

 
 Reply to this topicStart new topic

How we can ftech the database of Remote PC i.e connected throught inte, more explaination: Let a school in Noida have there own LAN. Similarly
anuj.2005.4all
17 Jul, 2008 - 11:19 PM
Post #1

New D.I.C Head
*

Joined: 17 Jul, 2008
Posts: 1
more explaination: Let a school in Noida have there own LAN. Similarly school in Delhi have there own LAN. Both also have internet connection. How a d
User is offlineProfile CardPM
+Quote Post

jairaj.net
RE: How We Can Ftech The Database Of Remote PC I.e Connected Throught Inte
19 Jul, 2008 - 01:43 AM
Post #2

New D.I.C Head
*

Joined: 18 Jul, 2008
Posts: 1


My Contributions
CODE
This can be done when u hav static IP Address. Because if u r using MS SQL 2005 as a backend then U can specify IP Address and Port Number of ur SQl Server in Connection String.

User is offlineProfile CardPM
+Quote Post

NickDMax
RE: How We Can Ftech The Database Of Remote PC I.e Connected Throught Inte
19 Jul, 2008 - 09:45 AM
Post #3

2B||!2B
Group Icon

Joined: 18 Feb, 2007
Posts: 2,859



Thanked: 50 times
Dream Kudos: 550
My Contributions
generally speaking it is very common for a database to exist upon one machine and then for other application to connect to that machine though a TCP/IP or other network connection.

So it is not terribly difficult to set up. However you need to keep security into account. Generally in my experience the DB has been behind a firewall and accessed though some secure interface -- but the various DB's do offer security.

I think you could get more help by posting your question in the "Databases" forum here at DIC.
User is offlineProfile CardPM
+Quote Post

kikz
RE: How We Can Ftech The Database Of Remote PC I.e Connected Throught Inte
22 Jul, 2008 - 05:00 PM
Post #4

New D.I.C Head
*

Joined: 21 Jul, 2008
Posts: 32



Thanked: 1 times
My Contributions
It's more a networking question actually smile.gif You need to open ports in your firewall to allow TCP/IP connections to the port used by your DBMS. Then you can connect via IP address, or machine name, if you got DNS entries setup correctly. Then there's the question of security. Do you want to connect using Windows Authentication or SQL authentication (ok might have assumed you're talking about SQL Server here wub.gif ).

Another possibility is to connect to the networks via VPN, then you become part of their LAN, and you do as you normally would if you were onsite.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/3/08 08:00PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month