connection strings

I am trying to develop a web site. I have a local ms sql database on my machine.

I am trying to connect to a ms Sql database on a goDaddy server from the application.

I am trying to understand the connection string and its total properties.

here is what I think should be in my web.config file

<

add name="Personal" connectionString="Server=whsql-v12.prod.mesa1.secureserver.net;

Database=DB_XX10;

User ID=myID;

Password=myypassword;

Trusted_Connection=False" providerName="System.Data.SqlClient"

/>

<remove name="LocalSqlServer"/>

can someone please tell me where I am going wrong, Thanks for your help....

If you search these forums for "GoDaddy" you will find that a lot of people have had problems with them. One being, that Go Daddy does not allow remote SQL Server connections.|||

Do you think it might be possible that somene would share their web.config that would overcome the problem?

Am I asking too much to think that I could develop my site locally and then have some reasonable way of uploading the web site AND update the database on the GODaddy ms sql server with the new data etc.

I am really looking for an overview of the process.

Thanks for your response......

|||You can NOT use a GoDaddy SQL Server from any server except their own, that is how they have things configured. It isn't about the Connection String.|||

So that means I can not access The GODADDY server from my local development enviroment?

SO to set up a development enviroment I would have to update the database directly as well as the web site it self. Is there a overview of such an enviroment available on the net AnyWhere?

Thanks for your quick response

|||

krisfr:

So that means I can not access The GODADDY server from my local development enviroment?

Pretty much. Can't do it. As for your other question, I am not sure. Google can help though.

|||Can I set up the web.config to look for the database locally first, and if it can not find the database then look for the GoDaddy datadase?|||Not really, no. What you can do is setup two connection strings, one for local and another for GoDaddy, and switch them out.