Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle8i Server with MSAccess as front end. help!

Re: Oracle8i Server with MSAccess as front end. help!

From: AleX <ashteren_at_netwiz.net>
Date: Tue, 29 Jun 1999 16:35:23 -0700
Message-ID: <3779583A.8B3FF6E8@netwiz.net>


Ricky_Prado wrote:

> Our site is having trouble getting Oracle ODBC and Access to play
> together as well Brad, so you are not alone. We have an Oracle db on a
> UNIX server and we run Windows 98 and Microsoft 97 SR1 on our clients.
> We create a Service containing our server IP address and port using
> Oracle Net8 Easy Config and it tests out successfully. Here are the
> steps and error messages we receive in Access:
>
> 1. Open Access 97 on our client PC's and open a new, blank database.
> 2. Go to File/Get External Data/Link Tables.
> 3. Files of Type = ODBC Databases
> 4. Under Select Data Source pop-up, click the Machine Data Source tab
> and select the Data Source Name you created in Oracle Net8 Easy
> Config. Click OK. (It doesn't seem to matter whether the type is
> System or User or if you create a File Data Source all pointing to
> the same server) & click OK.
> 5. When the Oracle8 ODBC Driver Connect box pops up, the correct
> Service Name is listed and you enter the User name and Password who
> has read privileges to the db. Click OK.
> 6. The Link Tables pop-up appears with only one tab: Link Tables. It
> lists all the tables (in the format dbname.tablename) on the Oracle
> server. Highlight one and click OK.
> 7. After about two minutes you receive two error messages:
> ODBC--call failed
> Click OK and then receive:
> [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current
> operation [#1013]
>
> We're stumped over here. I cannot think of anything else to solve this
> problem. Does anyone have any ideas out there?

Which ODBC driver are you using? Received on Tue Jun 29 1999 - 18:35:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US