I've run out of db space on our godaddy site, so I set up a SQL Azure database server and deployed my database to it. I then added my website's IP address to the Azure allowed IP list.
The problem is that I cannot get my site to successfully connect to the Azure database.
When I change the settings.txt to use the recommended connectionstring:
Server=tcp:myserver.database.windows.net,1433;Database=myuname;User ID=my@ID;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
I get an ASP.NET error saying that the keyword 'Server' is not supported...
When I try this one:
Provider=SQLNCLI11;Password=myPassword;User ID=[username]@[servername];
Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;
or this one:
Provider=SQLNCLI10;Password=myPassword;User ID=[username]@[servername];
Initial Catalog=databasename;Data Source=tcp:[servername].database.windows.net;
I get an ASP.NET error saying that the keyword 'Provider' is not supported...
When I try this one:
Driver={SQL Server Native Client 10.0};
Server=tcp:[serverName].database.windows.net;Database=myDataBase;
Uid=[LoginForDb]@[serverName];Pwd=myPassword;Encrypt=yes;
I get an ASP.NET error saying that the keyword 'Driver' is not supported...
The only one that gets different results is this:
DataProvider: sqlserver
DataConnectionString: Data Source=tcp:myserver.database.windows.net,1433;Initial Catalog=databasename;Integrated Security=False;User ID=my@id;Password=mypassword;Connect Timeout=30;Encrypt=True
BUT....I get a 'no database instance' error on that....
A few times, I got this error:
the argument 'nameorconnectionstring' cannot be null, empty or contain only white space.
But I found another post where they recommended commenting out the layout reference in the /Views/_ViewStart.cshtml, and since doing that, I haven't gotten this error...but still always the 'no database instance' error...
Anyone else have this problem?
I need to solve it ASAP because we won't be able to squeeze any new customers or orders into the database pretty soon!
Steve