Hi guys,
After successfully uploading the csv file to the database i have done some error checking and error logging. The client requirement was to abort the entire transaction even if one record in not able to be inserted in the databse.
I have done this using <%Transaction=Required%> in my ASP page. And on error of insert i abort the transaction (rollback) and do the proper error logging.
Alls fine uptil now, i have submitted the files to the client, well he says, he is getting error the the object is closed. And says it wrks fine if he comments <%Transaction=Required%>. But obviously we require transaction. So wht could be conflicting and causing the error "Object Closed".
He and i are using SQL Server 2000, i guess its regarding some setting issues of the server, but thts a guess......how come its wrking on my system and not in his ???????????????/
Any thought pls,
Regards,
ASD.
Enter your message below
Sign in or Join us (it's free).