Runtime error '1004' General ODBC error
 

I'm getting this error when i run a Excel macro which connects to oracle
and reads data from a table

Runtime error '1004' General ODBC error

this marco used to work fine, until i installed a Win 2000 patch.

i'm using oracle version 8.1.6

i chked the path and classpath they look good and im able to connect to
the same oracle instance using the Oracle ODBC Test and able to run
queries.

i use microsoft Excel 2000.


--
star_lucas
------------------------------------------------------------------------
star_lucas's Profile: http://www.excelforum.com/member.php...o&userid=26757
View this thread: http://www.excelforum.com/showthread...hreadid=400110