Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 General ODBC Error
Has anyone experienced this problem?
It occurs intermittently when we open an Excel report (heavy on VBA), so the workbook would appear to be the problem. The crazy thing is, this report uses OLAP and not ODBC at all. 99 out of 100 times, it works fine. 1 in 100 times, we receive this error. If anyone has seen this before and can shed some light on this, I'd apprecaite it. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 General ODBC Error
Not much help, I'm afraid; just an explanation: OLAP uses ODBC in the
background, I believe. Why it is erroring I can't say. A General ODBC error is often an attempt to use a function not supported by your driver so it may be dependent on the particulars of your DB engine. If the error tends to happen on more complex data sets perhaps you are exceeding some limitation of the query parameters or something. You may want to search MDSN - this might be a good starting point: http://msdn.microsoft.com/data/ Perhaps try a search on "OLAP ODBC" or "General ODBC Error". Also suggest you go to the support site for your database driver and look at their info on ODBC/OLAP. -- - K Dales "YCI" wrote: Has anyone experienced this problem? It occurs intermittently when we open an Excel report (heavy on VBA), so the workbook would appear to be the problem. The crazy thing is, this report uses OLAP and not ODBC at all. 99 out of 100 times, it works fine. 1 in 100 times, we receive this error. If anyone has seen this before and can shed some light on this, I'd apprecaite it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run-time 1004 general odbc | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Run time error '1004': Generaol ODBC error | Excel Programming | |||
Run time error 1004 General ODCB Error | Excel Programming |