Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by hocheeming
-
ADO Update/Insert
Hi everyone, Just a simple question. What is the best way to program ADO to insert and update record? We can use the "INSERT" SQL statement to insert into the database or use the "AddNew" command. So which is a better? The same goes to Update. Specifically use the Update...- hocheeming
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Operation not allowed when Object is closed
In VB code: Dim Connection423208 as ADODB.Connection Set Connection423208 = New Connection Dim Command423209 as ADODB.Command Set Command423209 = New Command Command423209.Name = _Chk_Fixed_Mobile_ASR2_16 Connection423208.Mode = adModeReadWrite Call...- hocheeming
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Operation not allowed when Object is closed
Hi everyone, I am using ADO and is facing the "Operation not allowed when Object is closed" during my load test. I had altogether 6 machines each running with 30 processes that calls the ADO api to retrieve records from a table to check on whether the recordset is empty or not...- hocheeming
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
