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
    
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
add comment

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

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

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.