Import acess database sqlserver2000, read the data no problem, but can't write data,
Write programs did not change, as shown in the following
<% dim conn
Dim connstr
On the error resume next
Connstr="driver={SQL Server}; Server=127.0.0.1; Uid=sa; The PWD=123456; The database=test2
"Set the conn=server. Createobject (" ADODB. CONNECTION ")
% & gt;
'database for links above statement
'to write data the following sentences
<% SQL="select * from the product where acticleid=476"
Set the rs=server. Createobject (" Adodb. You ")
Rs. The open SQL, conn, 1, 3
Rs (" title ")="to change the title"
Rs. Update
Rs. Close
Set the rs=nothing
% & gt;
Enter SQL statements directly in the sqlserver2000 query analyzer [update product set title='test title where articleid=476]
Can modify the data,
CodePudding user response:
Problem resolved: will the product in the table fields, allowing is empty, all marked) set articleid primary key, problem solved