LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
star_lucas
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
runtime error '6' overflow don Setting up and Configuration of Excel 1 July 26th 05 02:52 AM
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Runtime error for macro that works in workbook created in Crystal Excel Discussion (Misc queries) 1 June 22nd 05 08:43 PM
Excel 2003 Macro Error - Runtime error 1004 Cow Excel Discussion (Misc queries) 2 June 7th 05 01:40 PM
SQL Server ODBC Error Art Saffran Excel Discussion (Misc queries) 0 March 24th 05 02:37 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"