Date:  04/30/2007 12:57:03 PM Msg ID:  003406
From:  Wonmi KOh Thread:  003399
Subject:  Re: Remote data connection
Thanks, it works!
Sent by FoxWeb Support on 04/27/2007 01:28:52 PM:
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
support@foxweb.com email
Sent by Wonmi KOh on 04/27/2007 12:35:42 PM:
Hi!
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
  ...
ELSE
  =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?
Thanks!