Database at different location

gaurav_jain2403 · May 23rd, 2006, 03:07 AM

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