Problem With Adodc And Datagrid!!![RESOLVED]

[eranfox]

Hello Everybody,
I dont know what happened ,But when i try to connect to AS400
the computer is not responding.
when i tested the connection - it was succeessful,
but when i tried to set the record source property of the datagrid to tha ado control (adodc1) the computer didnot respond.

i'm using vb6 sp5 i even installed mdac2.7

please help - cause i dont know what to do!!

IS THERE A PROBLEM TO RETRIEVE 200,000 RECORDS AND MORE WITH ADODC AND DATAGRID???

thank you all in advance,
ERAN

[eranfox]

IS THERE A PROBLEM TO RETRIEVE 200,000 RECORDS AND MORE WITH ADODC AND DATAGRID???

[tpfkanep]

1st - do NOT use the adodc control.
Check out beacon's post (the 1st post of this forum).

2nd - Why return 200000 recs for the datagrid?

[eranfox]

Hello tpfkanep,
Thank you for your reply!

I'm using the adodc1 because I'm a lazy sod (sex pistols)!

About the 200,000 records - well it was my mistake to write it like that - i thought the problem was with the size of the table from the AS400 but i was wrong.

The problem was intalling mdac2.7 on win98se
(with client access 3 (this is an old version))

so with all the mess i had to uninstall the visual basic 6.0 and to unregister/delete files from registry and to install the vb6.0 again and to install mdac2.6

now its working great!!!!

Thank you again,

ERAN

p.s. i spoke with a IBM technical support Ing. and he told me that mdac2.7+win2000 is working fine.