We have some strange behavior in a VFP app that connects to a SQL Server database, and I'm hoping somebody can tell me where to start in tracking it down. Here's the situation ...

* a VFP9 application in heavy production use, running on lots of desktops with no problems

* we recently rolled out a Citrix server for some remote users who run this same VFP application, and those users get a timeout error the first time they connect to the SQL database, then each subsequent connection (in that Citrix session) runs fine

* the code that generates the timeout error looks like this:
lnConnHandle = sqlstringconnect( 'DRIVER=SQL Server;'+ ;
'SERVER=xxxx;' + ;
'NETWORK=DBMSSOCN;' + ;
'UID=xxxx;' + ;
'PWD=xxxx;' + ;
'DATABASE=xxxx' )

* the specific error they get (the first time only) is "Connection failed; SQLState: 'S1T00'; SQL Server Error: 0; [Microsoft][ODBC SQL Server Driver]Timeout expired'. Also note that immediately after this error the "SQL Server Login" dialog box appears, with our server and uid/pwd info in it, and when they click OK on this dialog box they connect immediately and then everything runs fine.

One other key piece of information: we can re-create this same behavior on the Citrix server at a VFP command prompt, by executing a PRG with the same SqlStringConnect command. So it seems that this problem isn't really related to Citrix, but rather to some configuration detail of this particular server.

Anybody have any thoughts or suggestions on this one?

TIA,
Doug