Q: Remote database connection

[Guest]

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?

 

[Karl Seguin [MVP]]

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

 

[Guest]

Thank you very much for the reply. Will there be any performance difference
if I call a web service and let it access the remote database?

 

[Karl Seguin [MVP]]

hitting the database directly will likely be somewhat faster. web services
aren't particularly quick - they relly on verbose SOAP and XML. Depending
on the application, the difference might not be noticeable.

Karl

 

[Terry Burns]

Yes. By definition here, the web service acts as a proxy in this scenario,
So there will be a performance hit, but it may not be noticable. You will
need to try it.