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.
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?