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")