Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.
Solved
SQl2000 / VB6 ADO, cryptacquirecontext error
Posted on 2002-07-01
Hi Guys
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?????
Steve
-
3
2
- +1
7 Comments
This what i found:
http://dbforums.com/archive/68/2001/10/4/181489
I think that you have the protocol encryption enabled, which uses the CryptoAPI. Unless you need this, you should disable it.
Independently of this, I could solve some problems with the CryptoAPI by
1) ensuring every user had full permissions to all the Crypto Hives in the registry
2) ensuring that no invalid/unknown users existed in the registry permissions for that hives.
CHeers
http://dbforums.com/archive/68/2001/10/4/181489
I think that you have the protocol encryption enabled, which uses the CryptoAPI. Unless you need this, you should disable it.
Independently of this, I could solve some problems with the CryptoAPI by
1) ensuring every user had full permissions to all the Crypto Hives in the registry
2) ensuring that no invalid/unknown users existed in the registry permissions for that hives.
CHeers
Thanks for replying so quickly.
I'm not explicity using the Crypto API, so how do I disable the protocol encryption??
Cheers
I'm not explicity using the Crypto API, so how do I disable the protocol encryption??
Cheers
Start the "Server Network Utility" on the "Microsoft SQL Server" menu (Start->Program Files is the default location). You will find the option in the first tab.
CHeers
CHeers
The option there does not allow you to explicitly set 'no encryption', only to enforece encryption.
I have tried various protocols and still no luck :(
Steve
I have tried various protocols and still no luck :(
Steve
The option there does not allow you to explicitly set 'no encryption', only to enforece encryption.
I have tried various protocols and still no luck :(
Steve
I have tried various protocols and still no luck :(
Steve
Featured Post
There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows. This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
- SQL
- Microsoft SQL Server
- AWS
- Azure
- Docker
- *DevOps
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses
Course of the Month9 days, 20 hours left to enroll
606 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.