Environment: win 10 64 32 bit Oracle client that excel 32-bit, 32 bit Oracle database.
Problem: ODBC 32-bit, configuration is complete, the successful test connection database,
But excel in choosing the ODBC data source, after a password prompt "unable to connect the data source, the reason: access denied, you may be the wrong data user id or password, or you do not have access to the database server,
And I was in PLSQL DEVELOPER can access the server normally, upload, download data,
Bosses, please help take a look at why I excel unable to connect to the database, thank you,