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