July 24, 2002 at 3:17 pm
Using VB6 ADO to connect to SQL Server 7
On a BeginTrans I am getting a Run Time Error -2147168227(8004d01d) Cannot create new transaction because capacity was exceeded. There is not a transaction active - if I attempt a CommitTrans I get "No transaction active". I cannot find this error message in any of my documentation or a search at MS. Can anyone help?
Thanks
Tom
July 24, 2002 at 7:04 pm
I looked through the newsgroups, didnt find anything definite. Things to check are that you arent out of disk space (or space allocated to the db), that you dont have a nested transaction, and that you're not using a read only recordset. Maybe could post the code?
Andy
July 25, 2002 at 5:39 am
Take a look here. http://www.aspemporium.com/aspEmporium/help/helpsys.asp?PRB027
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 25, 2002 at 4:02 pm
I finally found the problem - although I don't understand it. The cause was several singleton selects. Sometimes you could run the program with no error, and sometimes you would get the error. I am not sure why they were causing a problem - especially since they were executed with adModeRead and Nolock hints in the SQL. The fix was to close the ado record.
Thanks for you help.
Tom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply