The SqlClient library can connect to a remote database just fine - assuming
the necessary ports are open - namely TCP 1433
In your connection string, simply specify the IP address of the database as
the Data Source.
Karl
--
http://www.openmymind.net/
"JIM.H." <JI**@discussions.microsoft.com> wrote in message
news:6E**********************************@microsof t.com...
Hello,
My database stays in a remote site and I have access it through VPN. I
would
like connect my current Windows based Asp.Net application with this
database.
What are my options? Can I connect remote database with SqlDataAdaper,
will
that be slow? Should I sue Web Services to connect database?