Re: Personal Oracle via ODBC
Date: 1996/05/26
Message-ID: <31A86AE1.5B3E_at_johnbryce.co.il>#1/1
Robert Risholm wrote:
>
> I have installed Personal Oracle trial version and am trying to
> connect with ODBC via MS Access.
>
> I have installed the Oracle ODBC drivers using the Oracle installation
> kit.
>
> What should I put in the ODBC Administration setup for my ODBC source
> to connect to the Personal Oracle database?
>
> I can't seem to get it to work.
>
> The options in the ODBC setup for Oracle are.
>
> Data Source Name ?????
> Description ??????
> SQL*NET Connect String ???????
>
> Thanks
>
> Bob Risholm
> Robert Risholm
> Sony Electronics Inc.
In the Data Source name and Description you can type whatever you want. SQL*Net Connect string should be "2:" which is the default local Personal Oracle7.
Good Luck
Amir Farhi
- Amir M. Farhi *
- Oracle consultant *
- *
- Office: Home: *
- John Bryce (Systems) 1984 Ltd. 4 Yochanan Hagadi St., *
- 35 Jabotinski St., Tel-Aviv 62269 *
- Ramat-Gan 52511 I S R A E L *
- I S R A E L TeleFax: 972-3-5445458 *
- Phone: 972-3-5765660/6 Mobile: 972-52-450424 *
- Fax: 972-3-6131175 e-mail: phantom_at_math.tau.ac.il *
- e-mail: afarhi_at_johnbryce.co.il (Tel-Aviv University) *
- visit my WWW home page at http://www.math.tau.ac.il/~phantom *