XL - Oracle Connection error
 

Hi All,

I have written a VB macro in XL to pull some data from the Oracl
datadase and display it on the XL.

My macro is working fine in some PCs and its throwing an error in th
rest.

The error is

RUN-TIME ERROR '-2147467259 (80004005)':
ORACLE ERROR OCCURED, BUT ERROR MESSAGE COULD NOT BE RETERIVED FRO
ORACL

Am using the following code to connect to Oracle.
CN.OPEN \"PROVIDER=MSDAORA.1;DATA SOURCE =\" & INPUT1.DATABASE.VALUE
\";USER ID= \" & INPUT1.USERID.VALUE & \";PASSWORD=\"
INPUT1.PASSWORD.VALUE & \";PERSIST SECURITY INFO=FALSE\

Pl help me in finding the solution.

Thanks,
Parthiba

--
parthi4
-----------------------------------------------------------------------
parthi4u's Profile: http://www.excelforum.com/member.php...fo&userid=2707
View this thread: http://www.excelforum.com/showthread.php?threadid=46594