Re: Oracle Personal 8 and ODBC

From: Svend Meyland Nicolaisen <smn_at_logosdesign.dk>
Date: Wed, 25 Aug 1999 12:08:03 +0200
Message-ID: <miPw3.35$7t2.1488@news010.image.dk>

Thanks I will try that but what does "2:" mean??

Keind regards
Svend Meyland Nicolaisen

Christopher Stennett <sigh_at_ozemail.com.au> wrote in message news:01beeeb8$5823ffe0$6dc26ccb_at_chriss...
> Ok, I am assuming that you have Oracle 8 installed!!
>
> I use SQL*Net 2.x and the Oracle73 ODBC driver, but it will work with Net8
> and the latest ODBC driver (if slightly modified instructions)
>
> So, install SQL*Net and ODBC. Both drivers should be on the Oracle 8 CD.
>
> From Control Panel, select ODBC Administrator, System DSN, Add a new DSN.
> Select the Driver, Finish.
>
> Give the datasource a name, and a description. For the SQL*Net connect
> string, enter
>
> 2:
>
> (that is two colon)
>
> and then some user ID.
>
> Using the 2: will not work with Net8, so you need SQL*Net 2.x.
>
> click OK to save.
>
> To test your DSN, use Excel or Access to "Get External Data" utilising
your
> DSN.
>
> I hope that this is helpful.
>
> Regards,
>
> Christopher
>
Received on Wed Aug 25 1999 - 05:08:03 CDT