Having a problem where i'm happily running my VB6 application against a sql2000 database.
My VB6 application will do a certain number iterations (reading from a recordset, and then inserting records into a table), and then it
will fall over with the following error message.
Run Time Error ='2147467259 (80004005)' :
CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d:
(Error description unavailable)
At this point, I try closing the ADO connection, and re-opening, and I get the same error.
Whenever I try to load another windows program (i.e. Windows Explorer), I get a 'not enough memory to load program' error
I know that I have memory avaliable, (at least 80mb is being reported in the 'Free Physical Memory').
If I try running the SQL Insert statment in SQL Query Analyser, the insert works perfectly. (And I can also disconnect / reconnect to the SQL Server)
The only way to get my VB6 App to run the SQL Insert line is to stop the SQL Server process, and re-start it.
Obviously this is not a great solution, as my code is running on a client's machine which I do not have control over.
I've looked on newsgroups, and forums, and have come across a few references to this problem, yet none of them have had definative answers.
Can anybody help me please?????