Hi,

It's a right...

Messagebox(m.con1)
SQLDisconnect(m.con1)
Messagebox(m.con1)
?SQLGETPROP(m.con1, "Asynchronous")

MartinaJ


>Sir I am using these codes to connect sqlserver database
>
>

>Pubic con1
>m.lcCONN1 = 'Driver={sql server}; server=SERVER\SQLEXPRESS;Database=' + m.db1 + '; Uid=sa; Pwd=123'
>lcCONN1 = STRT(lcCONN1,CHR(13),'')
>lcCONN1 = STRT(lcCONN1,CHR(10),'')
>con1 = SQLstringCONNECT(lcCONN1)
>
>

>
>Database connects successfully.
>
>Now I try to disconnect database with following codes
>
>

>Messagebox(m.con1)
>SQLDisconnect(m.con1)
>Messagebox(m.con1)
>

>
>Messagebox display same value both time.
>It means database does not disconnect.
>
>What I doing wrong?
>
>Please help