Re: Linking Access 2000 to Oracle 7.3.4.5

Michael,

I've had the same issue when we upgraded from Access97 to 2000 ODBC--Call failed
I've found quick workaround: save the password when linking the tables. To minimize security breaches, I created a user in Oracle with minimum privileges. Use NT's security to limit the access to the database (Access2000) as well.
It solved 95% of ODBC failures.

HTH,
Vladimir

"Michael Brown" <mtbkab_at_yahoo.com> wrote in message news:9839f5a4.0106150652.596ff3c0_at_posting.google.com...
> 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 - 15:56:31 CDT