Error while trying to retrieve text for error ora-01019

Question

0.00/5 (No votes)

See more:

Hi,

I have one excel in which we retrieve oracle database data using VBA. It was working on windows 7 but now systems are upgraded to windows 10. After upgradation we are facing runtime ora-01019 error.

Error: "Run-time error '-2147467259 (80004005)': Error while trying to retrieve text for error ORA-01019"

Please help.

What I have tried:

I tried installation on of Oracle client drivers 32 bit and 64 bit. now I have installed on 32 bit drivers.

Posted 29-Aug-17 23:54pm

anurag9179

Updated 30-Aug-17 3:01am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-08-30T00:06:00

Solution 1

If you get an error message you don't understand, Google it: Run-time error '-2147467259 (80004005)': Error while trying to retrieve text for error ORA-01019 - Google Search[^] as you can see, loads of possibilities...

Posted 30-Aug-17 0:06am

OriginalGriff

Comments

anurag9179 30-Aug-17 6:10am

Hello OriginalGriff,

I already did google thats why I put this question on code project.

Jochen Arndt · Answer 2 · 2017-08-30T00:44:00

You have two errors:
At first you have an ORA-01019 ("unable to allocate memory in the user side") from the database driver. Then you have a 0x80004005 (E_FAIL = "An undetermined error occurred") error when trying to get the database error message.

A quick search for the ORA error: ORA-01019[^]

After fixing the database error you should also fix the second one. You have probably a function that tries to get and show the error message. There you should catch the failure and show an appropriate message like "Unable to get error message text for [Oracle error code]".

anurag9179 · Answer 3 · 2017-08-30T03:01:00

Solution 4

Hi,

Finally lot R and D I found soultion my self and that is nothing but a VBA Project ref.

VBA Window -> Tools -> References -> and check OracleDataControl, OraOLEDB 1.0 Type Library
Now its working fine

Posted 30-Aug-17 3:01am

anurag9179