C/ODBC 3.6 Delay opening ADO Recordsets

Siggi

Hi !

I wrote a VB6 - Program that searches Navision Tables through C/ODBC
by using ADO recordsets of VB6 - this worked pretty fine under Navision 2.x.
Now we changed to Navision Attain 3.6 and the Program is so slow accessing Navision Tables.
The problem comes up when I using a recordset in a loop opening and closing it at every iteration (with different SQL - queries), the open - Method takes longer and longer from iteration to iteration .
After 200 Iterations it takes about 5 -6 seconds, at the first one below one second.
Has somebody any experiences wiht that ?

Please let me know

borsicsj

Hi!

As I remember the ADO control has a property about cursors -I used it some time ago, but unfortunately don't remember-. I'd try to find and change server side from client side cursor.

I hope it helps.

Siggi wrote:

Hi !

I wrote a VB6 - Program that searches Navision Tables through C/ODBC
by using ADO recordsets of VB6 - this worked pretty fine under Navision 2.x.
Now we changed to Navision Attain 3.6 and the Program is so slow accessing Navision Tables.
The problem comes up when I using a recordset in a loop opening and closing it at every iteration (with different SQL - queries), the open - Method takes longer and longer from iteration to iteration .
After 200 Iterations it takes about 5 -6 seconds, at the first one below one second.
Has somebody any experiences wiht that ?

Please let me know

Siggi

Hi, thanks for you comment - I'm already running on serverside cursor, had that problem also when running on Navision Financial 2.x - but this doesn't make a change.
Seems it is something in the C/ODBC driver which causes a problem together with ADO, might need to switch to latest ADO - Version maybe.
So far I'm still not sure where to go .[/quote]