SQL SERVER DATABASE
C / C++ / MFC
1
Posts
1
Posters
0
Views
1
Watching
-
I have a problem on updating an sql server database. The connection string that I give is as follows: "Description=description name;DRIVER=SQL Server;SERVER=server_name;APP=Microsoft\x00ae Visual Studio .NET;WSID=wsid;DATABASE=dbtest;Network=DBMSLPCN;Trusted_Connection=Yes" I open multiple tables of the database as snapshot. The first problem that I have is that I want to search for a value of a field in one of the tables, so I use the MoveFirst and MoveNext functions. The MoveNext function doesn't work! The second is that when I run the AddNew function I get the error "Recordset is read-only"! Does anyone know how can I get the privilege to move in and change the database? Thanks in Advance sirtimid