This errror is described as an implementation specific problem with ODBC... Unfortunately I don't think rewriting any of the queries will help, since Microsoft describes it as a connection failure. I wish there were more I could do to help... sorry...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/od bcodbc_error_codes.asp http://www.winsyslog.com/en/FAQ/odbc-error-codes.asp http://www.roth.net/perl/odbc/SQLState/ Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > Error Occurred While Processing Request >> Error Diagnostic Information ODBC Error Code = IM004 >> (Driver's SQLAllocEnv failed) [Microsoft][ODBC Driver >> Manager] Driver's SQLAllocHandle on >> SQL_HANDLE_ENV failed The error occurred while >> processing an element > with >> a general identifier of (CFQUERY), occupying document >> position (8:1) > to >> (8:51). Date/Time: 08/29/02 08:48:20 Browser: Mozilla/4.0 >> (compatible; >> MSIE 6.0; Windows 98) > Any idea what the hey is going on here? > All I did was upgrade from 4.5.1 to 5.0 > And this is an application I did not design, that > interfaces with a SQL > Sybase database. And now it odesn't work. > During the upgrade process the CF5 installer updated the > MDAC from 1.5 > to current. > The client is now blaming me for this...:-\ > -Gel ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists