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

Try either a Pass-Though Query (seems to be more stable than Linked Tables and uses straight SQL statements) or OpenLink's Multi-Tier drivers at http://www.openlinksw.com

--
Thanks,

Edward A. Geddis
Technical Support Consultant
OpenLink Software
http://www.openlinksw.com
Making Technology Work for You

Ricky_Prado <ricky_prado_at_my-deja.com> wrote in message news:7lbeat$sa0$1_at_nnrp1.deja.com...
> 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?
>
> In article <xH983.109$_S1.2212_at_client.news.psi.net>,
> "Brad Pybus" <brad_pybus_nospam_at_hotmail.com> wrote:
> >
> > I am REALLY having much trouble get MSAccess to work with Oracle8i
> Server
> > via the Oracle ODBC driver.
> >
> > I would really like to know if there is anybody out there who has
> gotten the
> > two to work together properly!?!?!?
> >
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 01 1999 - 12:01:35 CDT