WinForms connect to Hosted Database?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MisterKen - 25 Feb 2005 20:01 GMT

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.

Reply to this Message

Christophe Hivert - 28 Feb 2005 17:28 GMT

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.

> Is it possible to using connect to a SQL Server database on a shared
> hosted
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Billy B - 28 Feb 2005 18:13 GMT

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.

Reply to this Message

MisterKen - 28 Feb 2005 18:45 GMT

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

> 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.

Reply to this Message

Rate this thread:

WinForms connect to Hosted Database?

Free Magazines