Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Randy Paries — — source: Informix-list mailing list archive (1991-1998)
Hi,
I need some help.
We are trying to use MS Access, Q&E ODBC Driver , and 4.10 PC_Net
going to a Online system running STAR.
The database I am going to has about 300,000 records and is a very busy
database. The table I am quering against is always being used.
I a trying to do some very large count(*)'s.
I keep getting the error -246.
I think it is the default isolation level.(big guess)
If I could I would do a
isql - - set isolation to dirty read;
isql - - set lock mode to wait 30;
but I can't do it thru access. (at least I don't think I can).
Has any one had this problem??
Any ideas on help???
Thanks for any input.....
--
---------------------------------------------------------------------------
Randy Paries rtparies@turq.b8.ingr.com
x6191 cr041 Intergraph, Huntsville Alabama (B&B Rule Heh heh heh)
---------------------------------------------------------------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.