Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Daatabase Link to MS Access using HSODBC
"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
![]() |
![]() |