Re: How to connect oracle using ADO

From: <ps2cheung_at_yahoo.com>
Date: Tue, 16 Nov 1999 23:52:07 GMT
Message-ID: <80sqn6$qpl$1@nnrp1.deja.com>

Thanks to Rob,

my problem is solved

solution from Rob McEwan -------------------

I saw your newsgroup posting. Try this:

con.connectionstring="uid=UUUU;pwd=PPPP;server=(DESCRIPTION = (ADDRESS =
(PROTOCOL = TCP) (HOST = HHHH) (PORT=1521)) (CONNECT_DATA = (SID = ZZZZ)));driver={Microsoft ODBC for Oracle}"

Where:

UUUU = Oracle username
PPPP = Password
HHHH = Host DNS name or IP address (assuming you are using TCP/IP

connections).
ZZZZ = Oracle Intance name

Works for me under MDAC 2.1 SP2

Cheers,
Rob McEwan
rob.mcewan_at_warnerbros.com <mailto:rob.mcewan_at_warnerbros.com>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 17:52:07 CST