Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issues connecting MS Excel/Access 2019 to 18c XE

3329564Jun 4 2019 — edited Jun 5 2019

I recently upgraded from XE 11g to 18c, and now I cannot connect from MS Access and Excel to my XE via ODBC. Everything was working just fine previously on 11g. I am using 64-bit for all applications and Windows 10 OS.

I am able to setup the ODBC connection and test the ping successfully. I am also able to login into XE via SqlDeveloper and SqlPlus successfully.

odbc.png

But when I try to connect to XE via Power Query, Power Pivot, or Access I get these connection errors:

access.png

excel.png

Interestingly a pass through query in Access works fine

pass through.png
This post has been answered by 3329564 on Jun 5 2019
Jump to Answer
Comments
Post Details
Added on Jun 4 2019
#access, #excel, #odbc
11 comments
1,201 views