Found connection problem when run VBA to direct connect Oracle Database

[pwebjunior]

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