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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle WITHOUT client s/w.....How? (ADO ???)

Re: Oracle WITHOUT client s/w.....How? (ADO ???)

From: Brent Douglas <Brent.Douglas_at_DAYTONOH.NCR.COM>
Date: Thu, 19 Aug 1999 13:47:21 -0400
Message-ID: <37bc4391@rpc1285.daytonoh.ncr.com>


i don't think this is completely correct, but i am mixing environments in my defense... from what i learned, the ODBC sits on top of a SQL*Net layer... w/out that layer, ODBC can't make the connection... with ADO, we didn't have to use the ODBC driver, but we still needed the lower layer (but in this case, we were using MSSql and it's stuff - not it's ODBC, tho)... maybe we were doing something wrong, but it always required the sql dll (forget the name, but it's what showed up when setting up the client in MSSql)....

i may be wrong, but we never got this to work w/out the native connectivity s/w, sqlnet or whatever....

good luck!
brent

Charlie Barrett wrote in message
<76Vu3.13894$vu2.3852_at_news.rdc1.tx.home.com>...
>Yep, your remote machine needs to have either the Microsoft OLDDB or ODBC
>driver for Oracle, which I think is a standard driver included in Windows,
>but probably needs to be updated (see http://www.microsoft.com/data/ ). You
>then need to get into the Control Panel, select ODBC, and assign a
>connection string to your Oracle server.
>
>Then you can use ADO, DAO, or whatever to connect to the Oracle server
>through the connection string you assigned in the ODBC driver.
Received on Thu Aug 19 1999 - 12:47:21 CDT

Original text of this message

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