Ado problems

[RaquelG]

1- Runtime Error 429 ActiveX componenet can't create object,
this occurs when I try to create an adodb.recordset, like this
set xxxxx = New ADODC.Recordset.

I'm using Access97, Vb6.0,

2-A datagrid linked to a ado control, does not retrieve the structure from the ado recordset , so the datagrid is empty, whitout the columns from teh recordset.
I'm very confusse.
Does anybody have a answear, please?.

 

[zemp]

Error 429 usually means that you are missing or the app cannot locate a necessary .dll or .ocx file. If this is occuring on a computer other than your development computer then you definatly are missing a file. Probably the file file for the ADODC.

I recommend that you use the Package and deployment wizard to create a setup package for your application. The P&D wizard will automatically include all necessary files. This virtually eliminates error 429. You can also use another installation package if you prefer.

With the P&D wizard you will have to manually add your Acces 97 database.

If I have missed my guess then post more details about what was done before the error occured. Thanks and Good Luck!

zemp

 

[Terpsfan]

I think the problem is this line, could be wrong. Don't you have to set it to an ADODB.Recordset?

set xxxxx = New ADODC.Recordset.

 

[zemp]

Yes, that could be true. There is an ADO data control (ADODC) and ADO active X data objects (ADODB). Make sure you have the correct one for the reference or component in your VB project. Thanks and Good Luck!

zemp