Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Access an MS SQL Database with SQL Plus

Re: Access an MS SQL Database with SQL Plus

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: 2000/03/07
Message-ID: <G7fx4.2508$NU5.160410@news0.telusplanet.net>#1/1

Oracle Lite definitely has it. I've used it to access a Adaptive Server Anywhere database.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

DriftWood <drift_wood_at_my-deja.com> wrote in message
news:8a3j8f$2i2$1_at_nnrp1.deja.com...

> You need to have a product called the Open CLient Adapter (or OCA)
> installed and a valid ODBC DSN for the foreign database configured.
> Then you use the following style connect string in SQL*Plus:
>
> ODBC:myDsn
>
> OCA used to install with the FOrms/Developer series of products, I am
> unsure what it may be bundled with anymore -- it must be bundled with
> Oracle Lite since that is an ODBC RDBMS and SQL*Plus can get to it when
> installed together...
>
> --
> -cheers
> DW
> --------------------------------------------------------------------
> "It is a kind of good deed to say well; and yet words are not deeds.
> -William Shakespeare"
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Mar 07 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US