>CLOSE DATABASES ALL
>CLOSE DATABASES
>CLEAR ALL
>CLEAR
>*
>xyz=SQLCONNECT("trnnbruq")
>
>*!! I am receiving the following two errors after the above command
>*!! although the program code still works (now ... sometimes it doesn't).
>*!! Error #1: Warning: The query timeout cannot be set.
>*!! Error #2: Warning: The connection sync/async mode cannot be set.
>
>
>WAIT WINDOW "Open = "+STR(xyz)
>*
>abc=SQLEXEC(xyz,"SELECT * FROM trnnbruq","tmptrn")
>WAIT WINDOW "Select = "+STR(abc)
>*
>*
>BYBY=SQLDISCONNECT(xyz)
>WAIT WINDOW "Closed = "+STR(byby)
>*
>RETURN
>
>
>
>PROGRAM : VFP50
>ODBC : VFP50
>NT4 Workstation
>(I am using ODBC because pretty soon we will be using SQL Server.)
>
>Can anybody tell me why I am receiving the errors?
>Thanks,
>Gene Berger
I am still very green on sql server stuff, but since you say that it does work sometimes, 1)Have you checked to see that all your datasessions are in fact closed?
2)Try closing out "tmptrn"..(i.e. USE IN tmptrn) before SQLDISCONNECT..