Re: Access97 link to Oracle synonym link to DB2

After trying some more searches I found the solution in a TechNet article dealing with a bug in VB. The solution was to create a view against the synonym, then point the Access link to that view rather than the synonym.

• Ed Stevens

In article <8d2kcb$al4$1_at_nnrp1.deja.com>,   Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote:
> This is not strictly an Oracle question, but Oracle is in the middle
 of
> it, so . ..
>
> We have a need to use MS-Access97 as a front end to an Oracle8
> database. The Oracle db has a synonym for a link to a DB2/MVS table
> via the Oracle Transparent Gateway. We have no problem linking from
> Access to any of the tables or views in the Oracle db, but when we try
> to link to the synonym, it fails. The error is actually MS reporting
> "The Microsoft Jet database engine could not find the object
> 'NMM.SY_COMMON_PARAMETER.' Make sure sure the object exists . . ."
 We
> are using the Oracle ODBC driver that came with Ora8. This error
 only
> occurs when linking to a synonym that points to a db link to DB2. If
> we link from Access to an Oracle synonym that references a table that
> is local to the Oracle database, everything works as expected.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Ed Stevens
(Opinions are not necessarily those of my employer)


Sent via Deja.com http://www.deja.com/
Before you buy.