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)
Endif
If SQLGETPROP(0,'DispWarnings')
= SQLSETPROP(0,'DispWarnings',.F.)
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)
In the beginning, there was a command prompt, and all was well.