WinForms connect to Hosted Database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to using connect to a SQL Server database on a shared hosted
web account using sqlconnection objects?

What would the connection string look like?

Thanks.
 
Hello,

You just need to know the address of the server hosting the database, the
name of the account, the password, and the name of the database.
You have an account on the SQL Server ? If so, no matter.
I don't see where there could be a problem.

Christophe Hivert.
 
One problem you may run into is if your site's hosting company uses virtual
hosting. Most virtual hosting firewalls are setup to block outside
connections to SQL & MySQL by default. So if you can't connect and you are
sure you have your string setup correctly, look to the firewall.
 
This particular host gives the IP address for the database. I can also
connect my Query Analyzer and Enterprise Manager to it as well via IP.

I'll have to give it try with WinForms, SqlConnection and DataGrid this
week sometime.

Thanks.

Ken
 
Back
Top