XL - Oracle connection Error
 

Hi All,

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

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

The error is

Run-time error '-2147467259 (80004005)':
Oracle error occured, but error message could not be reterived from
Oracle

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,
Parthiban


--
parthi4u
------------------------------------------------------------------------
parthi4u's Profile: http://www.excelforum.com/member.php...o&userid=27075
View this thread: http://www.excelforum.com/showthread...hreadid=467640