>Cetin,
>
>Sorry it's take so long to respond. The error I get is Statement parameter is required for non-prepared SQLEXEC calls. One note: If I run this code with a static DSN name gnHandel = SQLConnect('mydsn',userid, password) it all works just fine. But when I use SQLSTRINGCONNECT(myString) I make a connection but am unable to do an SQLEXEC call.

Non-prepared ? There is a SQLPrepare() call there. However I generally do not use it and directly add the statement :
lcSQLStatement = 'select ...'
SQLExec(gnHandle,lcSQLStatement)

Would you try this one.
Cetin