SQL="select * from b. poorder a inner join poorderentry b on a.f interid=b. interid where" & amp; Tempstr
CNCC. The ConnectionString="Provider=SQLOLEDB. 1; Persist Security Info=False;" _
+ "User ID=sa; Password=SA; Initial Catalog=A123456789; The Data Source=. "
MsgBox 1
Rs. The Open SQL, CNCC
MsgBox 2
Rs. Close
Set the rs=Nothing
Rs. The Open SQL, CNCC the sentence has been submitted to the connection to the user to perform operations in this context it may have been close
O solve
CodePudding user response:
CNCC. Open?CodePudding user response:
CNCC. The ConnectionString="Provider=SQLOLEDB. 1; Persist Security Info=False;" _+ "User ID=sa; Password=SA; Initial Catalog=A123456789; The Data Source=. "
This followed by CNCC. Open
Remember after use CNCC. Close