Re: Server side cursor

Hello,

We haven't found yet any salvation to the following problem. Would 
anybody have an idea for avoiding that error so that we could use Maxdb 
with server side cursors (through ODBC) ?

Quote :

Xavier CAMIER a écrit :
> Win XP SP2
> MaxDB Linux 7.6.00.34
> Turbo Delphi 2006
> ODBC 7.6.00.34
>
> Hi list,
>
>    I need to display a grid with a large amount of datas. I know I 
> shouldn't but I must do it anyway :-( To prevent network overload and 
> large form opening times I decided to test server side cursors. The 
> test project is quite simple : a dbgrid with a server side cursor 
> recordset. Using delphi and ADO I must set the recordset as beeing a 
> readonly keyset. The datas are retrieved as they should and about as 
> fast as they should (a little bit slower than when using SQL Studio 
> anyway. Does anybody know why ?). My problem happens when I scroll the 
> datas too fast. When scroll using the DBGrid the app hangs. When I do 
> it using code (simple loop through the datas) the app crashes sending 
> a "Access violation to address... in MSDATL3.dll" error message 
> depending on how large the cache is set. I thought the problem came 
> from MDAC but when moving my test application to a PostgreSQL database 
> it works fine. So I think the problem comes from MaxDB's ODBC driver. 
> Does anybody knows about that ?
>
> Kind Regards
> Xavier
>
Regards

Vincent

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]