I am trying to select a cursor from a MSDE database using the following code...

gnConnHandle = SQLCONNECT('KCHP') && returns 9
lnTest1 = SQLSETPROP(gnConnHandle, 'asynchronous', .F.) && returns 1 (ok)
lnTest2 = SQLEXEC(gnConnHandle, ;
'SELECT * FROM dbo.Policy WHERE cStatusId="C"', ;
'AA') && returns -1 (connection-level error)


No cursor is produced. I cannot fathom why the last line is failing. There are no error messages. Table dbo.Policy definitely exists in the database the connection is pointing to, as does the field cStatusId. Has anyone out there any idea what I might be missing?

TIA,
Alan Harris-Reid