Re: Oracle Personal 8 and ODBC

From: Christopher Stennett <sigh_at_ozemail.com.au>
Date: Wed, 25 Aug 1999 05:16:51 GMT
Message-ID: <01beeeb8$5823ffe0$6dc26ccb@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

(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 - 00:16:51 CDT