vb.net error after moving sql database to cloud (rackspace)
Posted on 2013-01-19
Incorrect Syntax Near "44446"
Specifically, getting an error in the code on the dataapapter.update line:
Dim myDataRowsCommandBuilder As SqlCommandBuilder = New SqlCommandBuilder(dataadapter)
do dataadapters work on hosted sql servers?
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.