Hi Brian,

CursorAdapter is unable to handle ADO data types for three last columns in the recordset. I believe, they are not in the list of supported data types in "Data Type Conversion Control" help topic either.

Thanks,
Aleksey.


>Hello,
>
>Does anyone know why trying to get a cursor of SQL Server tables using oConn.OpenSchema would fail when using an ADO CursorAdapter? The following returns a "Data type mismatch" when calling CursorFill()...
>
>Thanks,
>
>- Brian
>
>
>
>

>    lcConnString = 'Provider=SQLOLEDB.1;' ;
>                 + 'Persist Security Info=False;' ;
>                 + 'Integrated Security=SSPI;' ;
>                 + 'Initial Catalog=Northwind;' ;
>                 + 'Data Source=(local)'
>
>    * Make an OLEDB connection
>    goConn = CREATEOBJECT("ADODB.Connection")
>    goConn.ConnectionString = lcConnString
>    goConn.ConnectionTimeout = 30
>
>    * Make sure cursors are client-side
>    goConn.CursorLocation = 3  && adUseClient
>    goConn.Open()
>
>    LOCAL ARRAY laADCRIT[4]
>    LOCAL loSchemaRS as ADODB.Recordset
>    #DEFINE adSchemaTables 20
>
>    laADCRIT    = .NULL.
>    laADCRIT[4] = "TABLE"
>
>    loSchemaRS  = goConn.OpenSchema(adSchemaTables, @laADCRIT)
>
>    loCA = CREATEOBJECT("CursorAdapter")
>    loCA.Alias           = "csrSQLTbls"
>    loCA.DataSourceType  = "ADO"
>    loCA.DataSource      = loSchemaRS
>    loCA.BufferModeOverride = 5
>    lbOk = loCA.CursorFill( .F., .F., 0, loSchemaRS )
>    IF NOT lbOk
>        AERROR(laErr)
>        MESSAGEBOX("Error: " + TRANSFORM(laErr[1,2]))
>    ENDIF
>
>    loCA.CursorDetach()
>
>    IF USED("csrSQLTbls")
>        BROWSE FIELDS table_name
>    ENDIF
>