Re: Interfacing to Personal Oracle

In article <3g4pgj$q7l_at_ixnews3.ix.netcom.com>, Douglas Hackney <hackneyd_at_ix.netcom.com> wrote:
>In <3g4okg$t8g_at_bristol.onramp.net> mmarolda_at_bristol.onramp.net (Michael
>J. Marolda) writes:
>
>>
>>In article <3g3q31$1fi_at_viking.cs.ubc.ca>,
>>David Feldcamp <feldcamp_at_cs.ubc.ca> wrote:
>>>While it has been abundantly clear that no network connectivity is
>>>supported in Personal Oracle, it hasn't been clear to me from previous
>>>posts whether it is possible for third party interfaces (e.g., Excel5
>>>via ODBC or Omnis7) to connect to Personal Oracle *** if they are
>>>running on the same machine ***. Has anyone tried this and succeeded
>>>or have information one way or the other?
I've tried this with various Oracle apps, VB, Excel , Access using ODBC or Oracle Objects for OLE. It should and does work.
>>
>>I've been able to access personal Oracle from MS-Query using the ODBC
>>driver supplied with the oracle distribution. I just used "local" for
>>the SQL*Net connect string and everything worked okay.
>>
>>Mike Marolda
>>mmarolda_at_onramp.net
>>Onramp Productions - http://bristol.onramp.net/
>>
>>
>
>I've been able to access via the Oracle7 ODBC driver with both MS Access
>and GQL.
>
>I haven't been able to get the SQL*NET/Local connection to work yet
>though. Keep receiving "no interface driver loaded" error. I didn't have
>any problem getting this to work with Oracle 6.
>
>Any ideas anyone?
Are you using the correct sqlnet specifier? The one for the local database is '2:' as opposed to TCPIP which is 't' ot named pipes which is 'p:'.
>
>
>--
>--------------------------------------------------------------------
>Doug Hackney hackneyd_at_ix.netcom.com
>--------------------------------------------------------------------
>
>
Received on Thu Jan 26 1995 - 20:20:15 CET