Skip to Main Content

DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to connect ORACLE11g using the oracle 11g driver from MS Access

user3514148Sep 30 2014 — edited Oct 5 2014

Hi,

We have an MS Access application that connects to ORACLE to pull the data. We are using the ODBC based DSN to connect to the Oracle. As of now we are trying to configure the DSN using the ODBC driver 'Oracle in OraClient11g_Home1'. We configured the TSN successfully in the TSNNAMES.ORA in the ORACLE HOME directory. The TSN name is appearing in the DSN configuration window. But when I tried to Test the Connection it is failing. the ODBC error is thrown with error number M004. Anyone please help in resolving the issue. We have configured the ORACLE_HOME and TSN_ADMIN in the environment variables. Earliest help is appreciated.

Regards,

KALYAN

Comments

S VISHAL KUMAR

Is the space in the folder name mandatory ? Please change the folder name to single word or use _ in between and try again.

Thanks,

Vishal Kumar

S VISHAL KUMAR

Hello,

It seems, OATS requires that the installation directory does not contain any special characters and may be because of space it is not working as expected.

Thanks,

Vishal Kumar

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2014
Added on Sep 30 2014
4 comments
2,589 views