Re: MS-Access to Oracle

Kurt Batsel <batsel_at_dns.nxus.com> wrote:

[snip...]
>3) Then I went to the oracle home page:
>http://www.oracle.com/
>and downloaded this Oracle Driver:
>Oracle ODBC Driver for Rdb size=9451 bytes
>
>4) I then installed and configured the Oracle driver as follows:
>Data Source Name: enviro
>Description: EPA Metadata Files
>Server: earth1.epa.gov
>Class: generic
>User ID: enviro
>Attach Statement: t:envirofacts.sql.gov.enviro

The driver you downloaded is for Rdb, not Oracle. Rdb used to be owned by Digital then Oracle bought them. You need something called Oracle Open Client Adapter (or something like that). Otherwise you could buy drivers from Intersolv or Visigenic.

+------------------------------------------------------------+
| Chris Fischer                           cfischer_at_nando.net |
| Sr. Systems Analyst                    Work: (919)676-0062 |
| Toys "R" Us                                                |
+------------------------------------------------------------+