Date:  04/27/2007 12:35:42 PM Msg ID:  003399
From:  Wonmi KOh Thread:  003399
Subject:  Remote data connection
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!