Re: Does Active Server Page Work with Informix ODBC?
Posted in 1998
I have spent about two weeks trying to make it work with no success. I could not figure out how to set the environment variable for that session. When you run an ASP page, the process runs on behalf of a special user that you create in IIS. Before, you issue any commands, you have to set the INFORMIXDIR and other variables. After fiddling around with it for 2 weeks, I finally decided to switch to MS SQL Server. I don't know why Informix wouldn't put any documentation regarding this on their web site. If you find a way, please let me know too. Imran ysj wrote: > > I could not get either Informix-Cli ODBC or Intersolv DataDirect ODBC driver to > work with IIS4.0. > > The INFORMIX ODBC data source works fine with MS Access. But when I try to open > connection in active server page, I get "Microsoft OLE DB Provider for ODBC > Drivers Error '80004005',[INTERSOLV][ODBC Informix Driver][Informix]Cannot open > file 'csql.iem'" for Intersolv DataDirect ODBC driver. > > I also tried Informix-Cli ODBC driver and got "error 'ASP 0115', Unexpected > error". > > The informix ODBC drivers are from the INFORMIX-Client SDK ver 2.0. I have > tried to use the setnet32 utility to set the INFORMIXDIR etc enviroment > varibles but had no luck in fixing the problem. > > I read on Microsoft site that ASP does support INFORMIX. Could anyone give me > some hints if you have made it work? > > Thank you, > > Yi Fang -- =========================================== Imran Hussain MCP, MCSD imranh@summitdata.com http://www.summitdata.com/imranh ===========================================