Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the Oracle database. Steps I have followed:

Created a System DSN which points to the MS Access database file (mdb) on the network share. Created an file in the /hs/admin path of the Oracle Gateways directory with the entry: HS_FDS_CONNECT_INFO = DSN HS_FDS_TRACE_LEVEL = off

Created a listener which refers to the above DSN.

On the Unix box, created a tns entry and a public database link.

Upon querying a table over the db link, the error is:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. {HY024,NativeErr = -1023} ORA-02063: preceding 2 lines from DSN

However, when I create the System DSN which points to a file on a local drive on the windows box, I am able to query tables over the db link.

Please advise on where I need to make changes.

share|improve this question

migrated from stackoverflow.com Sep 24 '12 at 14:52

This question came from our site for professional and enthusiast programmers.

    
perhaps the Oracle user doesn't have access to the network share? –  Max Vernon Sep 24 '12 at 20:48
    
I've provided full access rights to both the oracle user and the windows user –  user996853 Sep 25 '12 at 7:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.