FYI: on 'SQL.iem not found!'

Hello folks... Well, this is to help any of you who may have the same problem I've just struggled with for the past four-and-a-half hours. I'm running an NT 4.0 server with Cold Fusion 3.01 and Intersolv ODBC 3.0 drivers. I was trying to connect to an Informix database on a Unix machine. I kept getting the blasted 'sql.iem file not found' message. I looked through my setnet32, my ODBC configurations and the CF datasources to no avail. I even tried having the Cold Fusion service make its connection under several different user accounts under NT. Looking at Deja News and this newsgroup all I found was 'check connect permissions and/or $INFORMIXDIR'. They were both right as far as I could tell. SO...I was trying all this under the 'Administrator' account. Cold Fusion was trying to connect as Informix. I got the wild idea that I should check Informix's environment, so I logged onto the machine as user 'informix'. Lo and behold, there was nothing set in its setnet32 environment -- including $INFORMIXDIR. I set all that crap, and came back in as Administrator and the bloody thing worked! Moral of the story ---> If you're on NT, pay attention to who the service you're working with is running as. The environment for the service depends not on who you're logged in as, but who the service is running as. My only comment through all of this is you would think the Informix installation would set up its' own damn user account with the right environment! SHEESH!!!! Carry on... Trevor Conn Developer ISPAlliance, Inc.