p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   ADO.NET (http://p2p.wrox.com/forumdisplay.php?f=109)
-   -   Database at different location (http://p2p.wrox.com/showthread.php?t=42895)

gaurav_jain2403 May 23rd, 2006 03:07 AM

Database at different location
 
Hello,
Is there any way in .NET that we can access the database from the computer at different location(say in different city) connected only through internet. If it is possible, What do I need to do. What is the syntax? What will be the connection string?

Gaurav Jain.

anubhav.kumar May 23rd, 2006 04:34 AM

hi,
 You have to put the public ip of the remote system in data source and username pwd as well in connection string

Anubhav Kumar

gaurav_jain2403 May 23rd, 2006 04:58 AM

So, this means I can write as below:
dim sqlstr as sqlconnection = new sqlconnection("server=101.103.11.22,database="pubs ",uid="sa",pwd=")
I wonder if this really work. In this manner anyone who knows the database name and public IP can access its database..........

gaurav_jain2403 May 24th, 2006 07:01 AM

Can anyone help me. Please tell me exactly how can I do this if possible....

anubhav.kumar May 29th, 2006 12:50 AM

hi,

Any one who knows public Ip does not know user name and password. Moreover increase secuiry by using integrated windows security instead


All times are GMT -4. The time now is 10:21 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.