Hi

I have this app which uses SQLServer as the backend. I use a trusted connection to connect and VFPsp1 as the frontend.

Immediately after connecting, I set some settings:

SQLSETPROP(oConn,"IdleTimeout",30)

SQLEXEC(oconn,"Set Language British")

gnsetrole=sqlexec(oconn,"sp_setapprole 'username','password'")

Everything works fine till the app has been idle for some time. Then when the user opens any screen and tries to access the SQLServer I get a "Access Denied" error.

After much tracing we found out that :

(vfpHelp)
"The idle timeout interval in seconds. Active connections are deactivated after the specified time interval. The default value is 0 (wait indefinitely). "

Also VFP reconnects using the same connection string BUT DOES NOT SET ANY OF THE OTHER SETTINGS.

So after the idle timeout, and reconnect, LANGUAGE reverts to US, and APPLICATION ROLE disappears, hence the access denied error.

This connection/reconnection is supposed to be a "feature" of VFP, but it breaks the app and in my case has forced me to set IdleTimeout to 0 or OFF.

Is there any solution to this or is it a bug that can be fixed?

TIA

Bernard