Problem with ASP

Hello! I am new with Informix. I have server NT 4.0 + 3SP on wich is installed Informix 7.2 Dynamic server and MIIS 4.0 as webserver with ASP (active server Page). I had tryed to build Web page, who get date from informix tables. I had make a connection trought ASP with VBScript wich use the ODBC driver on my server. So the connection string is: objConnection.Open " DSN=informix;DB=stores7;HOST=xxx;UID=informix;PWD=informix;SERV=turbo;SRVR=o l_xxx;PRO=olsoctcp" all settings seems right. but server resolve me - Microsoft OLE DB Provider for ODBC Drivers error '80004005' [INTERSOLV][ODBC Informix driver][Informix] Cannot open file 'sql.iem' Maybe someone can help me ? Where and what had i does wrong ? Tnx a lot! Girts Mazais KOMIN LTD Latvia

Girts Mazais wrote in message <7qke6r$dhv@news.latnet.lv>... >Hello! > >I am new with Informix. >I have server NT 4.0 + 3SP on wich is installed Informix 7.2 Dynamic server >and MIIS 4.0 as webserver with ASP (active server Page). > >I had tryed to build Web page, who get date from informix tables. I had make >a connection trought ASP with VBScript wich use the ODBC driver on my >server. >So the connection string is: >objConnection.Open " >DSN=informix;DB=stores7;HOST=xxx;UID=informix;PWD=informix;SERV=turbo;SRVR= o >l_xxx;PRO=olsoctcp" >all settings seems right. >but server resolve me - >Microsoft OLE DB Provider for ODBC Drivers error '80004005' >[INTERSOLV][ODBC Informix driver][Informix] Cannot open file 'sql.iem' > >Maybe someone can help me ? Where and what had i does wrong ? The problem is the account that IIS uses to access the intersolv driver is missing the $INFORMIXDIR etc. variables. IIS does not run as you(your acct), it makes its own. You need to be sure set the correct environment variables for ROOT and run the regcopy.exe for the IUSR_HOST acct. > >Tnx a lot! > >Girts Mazais >KOMIN LTD >Latvia > >