Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |