Re: ASP and Informix

--------------C255635DE5E08B27F2FAF3A0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bryan Allison wrote: > I have been able to run sql queries against my ODS 7.23 database > using ASP. What problems are you experiencing? I get the following error when trying to connect to an informix database using the INFORMIX-CLI ODBC driver: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. /prereport.asp, line 10 I can successfully connect using MS Query or MS VInterdev using the same system DSN/ODBC driver, but my ASP connection fails with the above error every time. ASP Code: Set objConnect = Server.CreateObject("ADODB.Connection") objConnect.Open ";DRIVER={INFORMIX-CLI 2.5 (32 bit)}; server=mySERVER; uid=myUID; pwd=myPWD; database=myDB;" --- Any suggestions? --------------C255635DE5E08B27F2FAF3A0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> &nbsp; <P>Bryan Allison wrote: <BLOCKQUOTE TYPE=CITE>I have been able to run sql queries against my ODS 7.23 database <BR>using ASP.&nbsp; What problems are you experiencing?</BLOCKQUOTE> I get the following error when trying to connect to an informix database using the INFORMIX-CLI ODBC driver: <BR>&nbsp;Microsoft OLE DB Provider for ODBC Drivers error '80004005' <P>[INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. <P>/prereport.asp, line 10 <P>I can successfully connect using MS Query or MS VInterdev using the same system DSN/ODBC driver, but my ASP connection fails with the above error every time. <P><U>ASP Code:</U> <BR>Set objConnect = Server.CreateObject("ADODB.Connection") <BR>objConnect.Open ";DRIVER={INFORMIX-CLI 2.5 (32 bit)}; server=mySERVER; uid=myUID; pwd=myPWD; database=myDB;" <P>--- <BR>Any suggestions? <BR>&nbsp;</HTML> --------------C255635DE5E08B27F2FAF3A0--