Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Access an MS SQL Database with SQL Plus
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...Received on Tue Mar 07 2000 - 00:00:00 CST
> 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.
![]() |
![]() |