Sorry for jumping in, but I if you not set this sqlsetprop correctly, that annoying popup to confim your dsn;s just keeps coming up..
Here is a snip of code, wich might help.

If SQLGETPROP(0,'DispLogin') <> 3
   = SQLSETPROP(0,'DispLogin',3)  && No login -- error on fail
Endif
If SQLGETPROP(0,'DispWarnings')
	= SQLSETPROP(0,'DispWarnings',.F.)  && No errors
Endif

Bob Lee

>Cetin,
>
>I got a connection now but I am getting an error SQLEXEC() statement. Here is all my code:
>lcConnection = 'DRIVER=Client Access ODBC Driver (32-bit);'+;
>'DBQ=webprddtx;SYSTEM=GVAS400;TRANSLATE=1;SIGNON=0;SSL=2;CONNTYPE=0'
>
>gnHandle1 = SQLSTRINGCONNECT(lcConnection)
>
>If gnHandle1 <= 0 Then
> Wait Window "Connection not Made"
> Cancel
>Else
>= SQLSETPROP(gnHandle1, 'asynchronous', .F.)
>= SQLPREPARE(gnHandle1, "Select * From drawmstrp", 'mySeeThisfit')
>= SQLEXEC(gnHandle1)
>EndIf
>= SQLDISCONNECT(gnHandle1)