error while trying to retrieve text for error ora-01019 windows

It looks like you are using the Microsoft drivers.  You should be using the Oracle native drivers.

Check the Bit version of the Oracle Client installed.  It needs to match the Bit version of the software using it and not the Bit version of the OS.  My guess is Your Windows 10 is 64Bit and you installed the 64Bit Oracle drivers and Excel is 32Bit.

Hi slightwv,

Thanks for quick reply.

I am not sure about excel because it is installed in C:\Program Files (x86)\Microsoft Office location also I have installed both oracle client i.e. 32bit and 64bit on Windows 10 which is 64 bit.

x86 is 32Bit.  Now you need to make sure your VBA code is accessing the Oracle 32Bit drivers.

Make suse you installed the correct drivers in the 32Bit client.  Not all of them are selected by default.  I prefer the Instant Client because it doesn't require a full client install.

I would use an Oracle native connect string.

I don't remember anything about the msdora driver but Google says it is OleDB so try these:
https://www.connectionstrings.com/oracle-provider-for-ole-db-oraoledb/

while using OraOLEDB.Oracle provider it given me Catastrophic failure error message.

did you put easyconnect in sqlnet.ora ?
that looks what you want to use by your connect string

easyconnect is not sqlnet.ora by default

Without some Oracle Error message, it will be next to impossible to troubleshoot.

Oracle almost always logs something somewhere that gives you an Oracle Error number.  If you aren't getting one, it might not be Oracle complaining.

What Oracle Client version did you install?
Is there anything in the Windows Event Log for the error?

I have installed Oracle 11g both 32 and 64 bit

11gR1 or 11gR2?  I'm going from memory but I remember 11gR1 working but not being certified on Windows 10.  I think 11gR2 was.

Anyway, I think any version of 11g will work fine on Windows 10.

Did the Event Viewer show anything?  I've never seen an Oracle error message mention Catastrophic failure.

Another question:  What version is the database you are connecting to?  Please include all 4 numbers.

It also might be possible that Excel is trying to use the 64Bit drivers.

If you do not need them, I would remove them.  If you need them for some other application, can you remove them for now until you get Excel working?

I think I can remove 64bit version of Oracle and will try.

Thanks slightwv and Geert

Hello,

Once again I am working on same issue, now I removed 64 bit Oracle drivers but it showing me Run-time error '-2147467259 (80004005)': Error while trying to retrieve text for error ORA-01019.

Please help.

If you Google around for those error numbers, everything points to a bit incompatibility.

From my previous post:
Look for events in the Event Viewer, look for logs somewhere.  There should be more information being captured somewhere.

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Anurag Jadhav (https:#a42275194)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

broomee9
Experts-Exchange Cleanup Volunteer