Printable View
Using VB5 professional, I have placed a recently downloaded ADODC control on a form, filled in the properties (selecting an existing ODBC data source name, and a valid SQL statement for the recordsource). Then I have placed a text box on the form to bind the fields to the ADODC, selected the Datasource property, and it does not recognise the existence of the ADO Data Control. Can anyone shed any light on this?. (I have no problems using the old DAO data control, just the ADO.)
Thanks
Check in Project, References if there is Microsoft ActiveX Data Objects 2.0 (or 2.1) Library. In VB 6 it's done automatically when you place ADODC on a form. If you do not see it checked, but you have that entry in References, check it, if no, look for msado20.tlb or msado15.dll and add one of them to References. If you don't find it on your computer you need to download it, but I know the product name only, it's MSDE (it has ADO2.1 inside).
Vlad
Thanks Vlad,
I have checked all you said out, and all is well. But, I still can't get the ADODC to work properly. When I run the program, the arrows for flicking through the data are greyed out, and the text fields still wont see the ADODC control in the Recordsource fields.
Any other hints
I don't know what you did already. Sorry if I'll tell obvious things, but maybe it will help. After you placed ADODC on Form, right click it and select properties. On appeared Property Page click on build, select Microsoft Jet 3.51 OLE DB Provider, click on Next and select your database, click Test. If succeeded, click OK. After you return to Property Pages window, click on Record Source and choose adCmdTable from first combo and the name of Table from second Combo. Now after OK your text box will be able to see DataSource and DataField.
If it doesn't work, maybe you do not have something on your computer installed.
Vlad
Hi Keith,
From my experience in VB programming, I find out that the ADODC control comes with the VB6 version. I am not sure you'll be able to use it with the version
5 of Visual basic. I suggest you to move to VB6 to use the ADODC control features.