Programming Help

Web Development



What's Here?

  • Members: 118,587
  • Replies: 434,910
  • Topics: 67,215
  • Snippets: 2,407
  • Tutorials: 642
  • Total Online: 831
  • Members: 62
  • Guests: 769

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 118,587 Programmers for FREE! Ask your question and get quick answers from experts. There are 831 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! 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
post 18 Jul, 2008 - 12:19 AM
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

Go to the top of the page


jairaj.net
post 19 Jul, 2008 - 02: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

Go to the top of the page

NickDMax
post 19 Jul, 2008 - 10:45 AM
Post #3


2B||!2B

Group Icon
Joined: 18 Feb, 2007
Posts: 2,763



Thanked 37 times

Dream Kudos: 525
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

Go to the top of the page

kikz
post 22 Jul, 2008 - 06: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

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 10/11/08 07:25PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month