I have a sql server/vb.net application where we house the database onsite. The application works perfectly in house. We are testing hosting the database in the cloud (rackspace). We have successfully created the database and connected to it.

When our client (vb.net desktop application) connects to the cloud version of the database, it throws some new errors (that are not present when we connect to the local version).

Trying to understand/figure out what the difference is and if the code needs to be modified due to the cloud hosting.

If fmClientInfo.txtEstClosingDate.Text.ToString.Length = 0 Then
.Rows(0)("lestClosingDate") = System.DBNull.Value
Else
.Rows(0)("lestClosingDate") = fmClientInfo.txtEstClosingDate.Text.ToString
End If
End With

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

your dataadapter is calling GetLoanData which is a stored proc designed to query data. It just cannot update data!

If you have an adapter created with something like "select * from table", an update statement is automatically created and you can call the update method. But that's not true for a SP. You need to provide another command!

So you migrated the database from a local install of SQL Server (Which Version/Edition?) to a server with SQL Server 2012 Web Edition? If the answer is yes, have you verified that the schema is identical between the two and there are no TRIGGERs on the tables in the Stored Procedure ?

Also, please post the contents of your GetLoanData Stored Procedure.

0

browe68Author Commented: 2013-01-19

acperkins, that is correct. To Migrate, I detached database, copied files to cloud server, reattached. It is working perfectly other than this...

The only difference is in security, the local is a Windows Authentication. The cloud database is SQL Authenticaiton.

This error is occurring on every commandbuilder update statement, so it is not specific to this one statement.

The local version is SQL 2008 SP1
The cloud version is SQL 2012 Web Edition. (maybe commandbuilder not supported)

0

browe68Author Commented: 2013-01-23

The answer is that in Sql Web 2012, they must treat the data adapter differently. When I spin a new server to Sql Web 2008, it works with no tweaks to the code.