Can you post connection string? You can use SQLGETPROP(gnConnHandle,"ConnectString") to get it. Did you try with another table?
>Hi
>
>I am trying to get an ODBC query to work but keep getting
>
>
Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources
>
>
Can someone enlighten me as to what I should do to fix this?>
>The query
>
>
sqlreply = SQLEXEC(gnConnHandle, 'SELECT SALES_ORDER.* FROM SALES_ORDER SALES_ORDER', 'csrBarcode')
>IF sqlreply=-1
> AERROR(aRet)
> ?aRet(1,2)
>ELSE
> ?sqlreply
>ENDIF
>
>worked once but I cannot figure out what I did to make it work.
>
>A bit lost
>Geoff Scott
--sb--