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