Re: Linking Access 2000 to Oracle 7.3.4.5

First of all, I appreciate the responses.

I understand that my description of my problem has been vague so I will attempt to explain the problem I'm having as detailed as possible.

I am attempting to link access 2000 to an Oracle database (7.3.4.5). The Oracle database is located on an NT server.

These are the steps that I have taken.

1. I installed Oracle7 ODBC Driver Version 2.5.3.1.7 (32 bit) for Windows NT 4.0/95/98 on a desktop.
2. I then went to ODBC Data Sources (32 bit)and clicked add user DSN and selected the Oracle driver I had just installed.
3. I entered the following: Data Source Name: Oracle Description: <Blank> SQL Net Connect String: QTOT User ID: SYSADM
4. I then went into access File>Get external data>Link Tables
5. I selected in Files of Type ODBC Databases()
6. I then selected the data source I created.
7. I was prompted for a password, I entered the password and i received the following error:

   ODBC--Call failed    

   [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-03121: no interface    driver connected - function not performed. (#3121)    [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr    failed(#0)[Microsoft][ODBC Driver Manager] Driver's    SQLsetConnect Attr failed (#0)

Now I'm not sure if I have loaded the wrong driver or if I need to load something on the server.

Any suggestions please?

TurkBear <noone_at_nowhere.com> wrote in message news:<bt42itc4ev0clpjlk79qg42vh48gd90rdn_at_4ax.com>...
> Sorry, but you will have to be a little clearer:
>
> What do you mean by 'can't locate Oracle'?
>
> In Access 2000
> Use
> File..External data...Link Tables
> select ODBC databases as the type,
> Find the DSN for your Oracle database
> Use it to pick the table(s) you want to link..
> ( this is not a lot different, as I recall, from earlier Access methods)
>
>
> mtbkab_at_yahoo.com (Michael Brown) wrote:
>
> >"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<thvdqsl78uog6d_at_beta-news.demon.nl>...
> >> "Michael Brown" <mtbkab_at_yahoo.com> wrote in message
> >> news:9839f5a4.0106070856.72a9fab_at_posting.google.com...
> >> > I am attempting to link access 2000 to an Oracle database (7.3.4.5).
> >> > The Oracle database is located on an NT server. Currently I have several
 Access
> >> > 2.0 databases linked to Oracle from several desktops. We are trying to
 upgrade
> >> > to Access 2000 but I can't locate Oracle with it.
> >> >
> >> > Please. . . any suggestions?
> >>
> >> Only if it is not too much trouble for you to post any specific error
> >> messages.
> >>
> >> Regards,
> >>
> >> Sybrand Bakker, Oracle DBA
> >
> >I wish i could provide more information. I should have explained that I'm not
> >familiar with ODBC's, networks, oracle, etc. I just know that I didn't have
> >any trouble whatsoever linking to Oracle through Access 2.0. Now that we are
> >making the upgrade to access 2000 I just can't locate Oracle. I'm not sure
> >where to begin.
> >
> >Please. . . any suggestions . . . actually I need more like step-by-step
> >instructions.
Received on Fri Jun 15 2001 - 09:52:08 CDT