Interview Question in SQL Server Data Services (SSDS)
Interview Question :: Visual Studio 2005 and SQL Server problem
I can't use Visual Studio to create Update and Delete Queries through the Data Source configuration Wizard. Visual Studio 2005.
I can use the wizard to create the Select query. The check boxes for Update and Delete queries are dimmed out and I can't select them. I do have the primary key in my select query and that works fine when I test it. I am also able to manually write a delete query and put it into the data souce object. The manually created query works fine!
This worked fine until last Friday or so. It has not worked today at all. I think something was changed at the hosting service because I have not changed anything.
I am logging into the SQL Server on xxxxxx.com with this connection string:
connectionString="Data Source=xxxxxx.com;
Initial Catalog=vTrac;
Persist Security Info=True;
User ID=xxxxxxx;
Password=xxxxxxxxx"
The 'xxxxx's are to redact sensitive info.
Loading ...