Sleeper: Found connection problem when run VBA to direct connect Oracle Database

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

Try using a different ODBC driver version or OLEDB provider. Sometimes different driver versions can have different behavior and compatibility issues, so it may be worth trying a different version to see if it resolves the issue.wordle

Quote:

---

Originally Posted by juiweasley

Try using a different ODBC driver version or OLEDB provider. Sometimes different driver versions can have different behavior and compatibility issues, so it may be worth trying a different version to see if it resolves the issue. 68 angel number 1223 angel number

---

Hello felow newbie! Unfortunately, this does not work. I tried almost everything and nothings seems to be working and I haven't been able to find a solution... :(

It's really hard to easily solve the problem. I follow you and update other comments as well. I'm also having a similar situation that needs to be resolved.

struttelling..... what is going on? That's two posts you have made that are basically throw away lines. If you feel the need to post then please make your posts more constructive, particularly when posting to an old thread.