Re: probs with odbc driver...

In article <Cr55Ir.9w2_at_du.edu> knguyen_at_du.edu (NGUYEN) writes:

>>I am not familiar with that particular error, however I do know that
>>attaching to Oracle tables and working with large volumes of data
>>chokes ODBC. I believe that it has to do with the buffering of the
>>data within ODBC to support various SQL commands. Unfortunately, I
>>have not been able to test my theory as of yet. Real work gets in
>>the way.
>>
>>Rick (rcronau_at_aol.com)

>Rick, I also notice the same thing. I also notice that the problem
>occurs a lot more when you are in the preview mode of the dynaset. However,
>the problem does not seem to be as bad if you link a report to a query, and
>view the data in the report. Also, I notice that the more memory you
>have on your PC, the less ODBC problem you will have.

Both of these are because Access tries to bring back the ENTIRE TABLE from Oracle before doing the deletes or processing the Where clause on a join to a local Access table. It ISN'T an ODBC problem, per se.

>Furthermore, whenever ODBC chokes and terminates MS-Access, it leaves a dangling
>session in Oracle7. I think this may be because of the way SQL*Net handles TCP,
>but I think the problem is also related to ODBC also.

Nope. SQL*Net does a really poor job of handling clients that disappear without logging off. We've seen exactly the same problem with a number of different applications/tools none of which use ODBC.

>Nguyen Nguyen
 

>BTW, has anyone used the ODBC drivers from Q+E? How is it compared to other
>versions of ODBC?

They're faster than the PageAhead driver that Microsoft distributes but you have to pay a license fee of about $99 PER USER to use them as a general ODBC driver. The cost is less if you use them strictly with apps you develop in-house with the Q+E Database Library, but it's still significant if the number of users is large. In general, Q+E has priced itself right out of the market.

--
Bill Meahan,  Senior Developer  |        wmeahan_at_ef0424.efhd.ford.com 
Electrical & Fuel Handling Division, Ford Motor Company
      "Computers are the most stupid machines in the world -
       they do EXACTLY what you TELL them to do!" (Gus Ogletree)