Re: Daatabase Link to MS Access using HSODBC

From: Mark D Powell <mark.powell_at_eds.com>
Date: 29 Aug 2002 06:02:07 -0700
Message-ID: <178d2795.0208290502.479cc960@posting.google.com>

"Richard Calo" <richard.calo_at_bt.com> wrote in message news:<akiijt$gg2$1_at_pheidippides.axion.bt.co.uk>...
> Does anyone have any knowledge regarding creating a database link to an
> MSAccess ODBC connection on an NT4 domain using the HS agent HSODBC.exe?
>
> I'm currently having problems access the Access db via the ODBC connection
> and my suspicions are that the hs agent is not passing the right credentials
> onto the ODBC connection as declared in the create database statement.

There is trace information available based on your entries in (UNIX systax) $ORACLE_HOME/hs/admin/initX.ora where X relates to listener/tnsnames entries

The error information there should help you. I have only used the facility to link from Oracle on AIX to SQLServer on NT, but if you have a valid ODBC driver for the target then it should be possible.

HTH -- Mark D Powell -- Received on Thu Aug 29 2002 - 08:02:07 CDT