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

Try to use MS ODBC driver for Oracle. You can get it free on microsoft.com. We also use MS Access as Oracle front-end and had many troubles with Oracle ODBC. It seems to me that it doesn't support functions necessary for Microsoft products. On the other hand, MS turned its face upon Oracle and provide rather good drivers. Another decision would be Intersolv ODBC, we used it with PowerBuilder. But for MS products it is better to use MS driver.

Best regards,
Ivan Makkaveyev, GRT Inc.

Ricky_Prado wrote in message <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 - 11:47:46 CDT