>>I have a problem using sql pass Through commands when for a moment loose network connection.
>>More Details:
>>I have an application (vfp9) and I am using remote views (against SQL Server) and sql pass Through commands in one connection handle for the entire application. When for some reason stop and start the network connection (instantly). The remote views continue to work but the sql pass Through commands (I have one to exec a stored procedure on sql server to obtain a uniqueID) gives error “communication link failure”.
>>
>>Since Remote views and pass Through commands work on the same connection handle and with the same settings, why after stopping and starting network connection the remote views continue to work but the sql pass Through gives error ?
>
>Are you retrieving a statement handle for SPT every time you need it or just once?
I am using the same connection handle for the entire application life cycle (deklarit when application start) and i pass it when I am trying to execute the stored proc, so I suspect that the answer is once.
----------------------------------------
Nikos Kiriakoulakos
Software Engineer
Dep. of Medical Informatics
Apollo Ltd.
Greece
----------------------------------------