Re: Personal Oracle via ODBC

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 *

  ---