Hi Shailesh,

How you open connection?
If you open connection by SQLSTRINGCONNECT(), then check result value of SQLGETPROP(0, "Asynchronous").
If you open connection by SQLCONNECT() or at open remoteview view, then check property "Asynchronous" of connection in DBC.

The result value must be .F. If .T., then connection is in Asynchronous mode and you cannot it again. But you can use function SQLCANCEL(handle) for canceling running SQL command (SPT or remote view).

MartinJ


>Hi All,
>
> We are using SQLConnectstring to connect database . But sometimes i m suffering from the following error as
>Connection "name" is busy
>and then if i suspend it and again run it it runs finely . Why is this error comming ? Any suggestions to overcome this ?
>
>
>Thanking You.