ADO 2.8 working Asynchronously in C++
-
Hi Guys, I have some C++ code that is working in Real-Time with a decoder. Its job is to Insert into SQL 2008 R2 and its currently using ADO 2.8 to do it. However i dont want it to block while doing the Insert, because it holds up other packets arriving from the decoder. So i am trying to convert it to perform its calls Asynchronously so i can blindly Insert my packets which will be faster. Although depending on the speed, it is possible that i may need to Insert a 2nd packet before the 1st one had finished. I have written some sample code in C# (ADO.NET) and proved that Async mode works, but i cannot get any sample code (ADO 2.8) to work in Async mode in C++ and it is driving me nuts!! I want to use the ExecuteComplete event but that does not fire either? Please would somebody help me find out what the heck i need to do make some progress on making Async work? Many many thanks, Rich.
-
Hi Guys, I have some C++ code that is working in Real-Time with a decoder. Its job is to Insert into SQL 2008 R2 and its currently using ADO 2.8 to do it. However i dont want it to block while doing the Insert, because it holds up other packets arriving from the decoder. So i am trying to convert it to perform its calls Asynchronously so i can blindly Insert my packets which will be faster. Although depending on the speed, it is possible that i may need to Insert a 2nd packet before the 1st one had finished. I have written some sample code in C# (ADO.NET) and proved that Async mode works, but i cannot get any sample code (ADO 2.8) to work in Async mode in C++ and it is driving me nuts!! I want to use the ExecuteComplete event but that does not fire either? Please would somebody help me find out what the heck i need to do make some progress on making Async work? Many many thanks, Rich.
Did you try below link as well: http://social.msdn.microsoft.com/Forums/eu/sqldataaccess/thread/a262abdf-4516-45c6-8065-8203ca29977f[^]
regards, vatsa www.objectiveprogramming.com