473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error initializing the cache for disk storage

I've made a program that fetches data from an ODBC data source. Everything works fine when the table contains only a few rows. The problem is that when there are many rows (6000, in this case), the program terminates with the following OdbcException

"ERROR [26000] [ATI][OpenRDA ODBC]Error initializing the cache for disk storage

The SQL statement is simple
"SELECT * FROM Items;

If the SQL statement is reduced to this
"SELECT ItemID,ItemNumber,QuantityOnHand,ValueOnHand FROM Items;
then it works, fetching all 6000 rows. But, this is not useful to me in this form. I could hack my way through, fetching 4 columns at a time, and patching them together at the end, but that would stink

Does anyone know why this error is occuring? Even better, how can I fix this problem

Thanks
Mike
Jul 21 '05 #1
1 3706

OK way after the original post but I ran into the same issue wit
MYOB/Access and found a couple workarounds.

First is to put a dummy UNION on the end of the SQL.

SELECT * FROM MYOB_SalesHistory
UNION
SELECT * FROM MYOB_SalesHistory WHERE 1=2

This forces the query to NOT use disk cache but to dump to RA
instead.

The REAL solution is probably you need to create the cache folder. I
the Windows directory there should be a file called openrda.ini. Ther
should be a string with :

CacheOptions=PATH=C:\MYOBODBC\cache;INITIAL_SIZE=1 0;INCREMENT_SIZE=5;MAX_SIZE=5000;DATABLOCK_SIZE=64

What you want to look for is the path variable. The cache folder di
not exist in C:\MYOBODBC when I looked--I created the cache folder an
the queries now run.

Jake

=?Utf-8?B?TWlrZSBEYXZpc29u?= wrote:
*I've made a program that fetches data from an ODBC data source.
Everything works fine when the table contains only a few rows. Th
problem is that when there are many rows (6000, in this case), th
program terminates with the following OdbcException:

"ERROR [26000] [ATI][OpenRDA ODBC]Error initializing the cache fo
disk storage"

The SQL statement is simple:
"SELECT * FROM Items;"

If the SQL statement is reduced to this:
"SELECT ItemID,ItemNumber,QuantityOnHand,ValueOnHand FROM Items;"
then it works, fetching all 6000 rows. But, this is not useful to m
in this form. I could hack my way through, fetching 4 columns at
time, and patching them together at the end, but that would stink.

Does anyone know why this error is occuring? Even better, how can
fix this problem?

Thanks,
Mike

-
jakeros
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message49836.htm

Jul 21 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Udy | last post by:
Hi, We have a custom application used by a customer on DB2 8.1.5 AIX 5.1, we have tested it with 8.1.0 AIX 5.1 and everything works fine. But with 8.1.5 we get the above error. The other...
1
by: Mike Davison | last post by:
I've made a program that fetches data from an ODBC data source. Everything works fine when the table contains only a few rows. The problem is that when there are many rows (6000, in this case),...
18
by: siddharthkhare | last post by:
Hi All, what is the diference between these two cache control header. no-cache and no-store. I have read the w3.org explanation. So lets say I am using only no-cache ....my understanding is...
6
by: p175 | last post by:
2006-08-14-17.46.13.656000-240 I1472H436 LEVEL: Warning PID : 1452 TID : 336 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : SQ4V6...
2
by: teddybyte | last post by:
my script below is: #include "stdafx.h" int APIENTRY WinMain(HINSTANCE hInstance, HINSTANCE hPrevInstance, LPSTR lpCmdLine, ...
3
by: ary | last post by:
I try to create a weblog host site! in this case i can't use cache for every page because that cause to be my Server ram full of caching page. but if I can save cache in hard disk my problem...
29
by: =?Utf-8?B?SGVybWF3aWg=?= | last post by:
Hello, Please anybody help me. I have only a little experience with web development. I created simple project using ASP NET 2.0 (VS 2005) It works fine on local computer. When I tried to run...
5
by: | last post by:
Is it advisable to store my own data as XML in the folder returned by HttpRuntime.CodeGenDir? (i.e. in "Temporary ASP.NET Files") Each web service on the server must try to read its own cached...
13
by: WaterWalk | last post by:
Hello. When I consult the ISO C++ standard, I notice that in paragraph 3.6.2.1, the standard states: "Objects with static storage duration shall be zero-initialized before any other...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.