Date:  04/27/2007 01:28:52 PM Msg ID:  003401
From:  FoxWeb Support Thread:  003399
Subject:  Re: Remote data connection
This is most probably caused by the fact that the FoxWeb service is running as the System user.  Please refer to the Running as a System Service section of the Operating your Server topic in the FoxWeb documentation.
FoxWeb Support Team email
Sent by Wonmi KOh on 04/27/2007 12:35:42 PM:
I would like to connect informix database located in Linux server. I loaded odbc driver on the IIS which this foxweb is running.
I used vfp commend something like this -
STORE SQLSTRINGCONNECT('dsn=informix;uid=informix') TO gnConnHandle,  
IF gnConnHandle <= 0
  =SQLEXEC(gnConnHandle, "SELECT * FROM ...", MyCursorc')...
This works from vfp but it doesn't work from foxweb.
Would you tell me which commend should I use and show me some example?