>Cetin,
> I know this is an old thread, but I'm trying to figure out how to instanciate the ADODC (not ADODB) in code. The (visual) ADODC com works with the simple stuff being put through it. When attempting to instanciate in code, ODBC errors popup with Provider errors (Error 0?). Note: the ADODC property pane does not offer "Provider" and that the ADO.Refresh call pops these errors. Got any thing to share or shed about ADODC? Is it different from ADODB, or is that a subclass name? :) PS: CommandType is 8 (unknown) and the RecordSource calls a NortWind stored procedure.
>
>>oRecordset = CreateObject("adodb.recordset")
>>oConnection = CreateObject("adodb.connection")

ADODC (ADO Data Control) is an ActiveX control for data binding. Just another layer of abstraction. In most situations you can do binding without this control. What are you trying to use it for?