Re: Select data from Access database

Quickly thinking the generic connectivity (ODBC) gateway is the way for you to connect Access Database. Installing the agent is a quick task so this should not overload your DBA.

• Harri

Frank <Xnews_at_snijf.com> wrote in
news:Xns92B4891F3B74AXnewssnijfcom_at_216.168.3.44:

> What is a good proofed solution for (in batch) getting data from an
> Access database 1:1 to Oracle database?
> Te keep control over the whole proces I prefer to select the date
> (from the point of view of Oracle) instead of pushing the data from
> Access to Oracle using ODBC-connection (or export data and use
> SQL*Loader to load the data into Oracle).
> I have read about Generic Connectivity (and Oracle Heterogeneous
> Services), but is that the only solution?
> If so, how can I (developer) convince a DBA to install the ODBC agent?
> Can it have impact on the database or imply extra work for DBA?
> Is the possibility of retrieving data from a non-Oracle database just
> possible from Oracle 8.1.6 (read in "What’s New in Oracle8 i")?
>
> Thanks in advance,
> Frank

-- 
-----------------------------------------------------------------------
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4