Found connection problem when run VBA to direct connect Oracle Database

pwebjunior

New Member
Joined
Mar 13, 2019
Messages
1
Hi,

Currently, I write VBA script to connect Oracle Database by using ODBC.
But I found connection problem until I do steps to success inquiry to get data as followings:

1. Open excel file > Tab "Developer" > Visual Basic > Run button to get data


Found error message
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Driver for Oracle]Error while trying to retrieve text for error ORA-01019


2. Then, change connection string from connection using ODBC to OLEDB (Comment ODBC connection string) > run button to get data again.


Found error message
Run-time error '-2147418113 (8000ffff)'
Catastrophic failure


3. Save and close excel file


4. Open excel file again. Then, try to run button to get data as OLEDB (Latest Saved File from no.3)


Found error message
Run-time error '-2147467259 (80004005)'
ORA-01017: invalid username/password; logon denied.


5. Finally, I change connection string from OLEDB to ODBC again. Then, run button to get data.
Excel can normally connect and get data as I expected.


Could you please advise me to solve this problem?


Current Software:
- Windows 10 Enterprise 64 bit
- MS Office 2013 Professional Plus 32 bit
- Microsoft ODBC for Oracle "MSORCL32.DLL" 10.00.17134.01


Thank you and Regards,

Pathikorn
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top