Well, I've upgraded to Postgres 7.2 and RedHat 7.3, and I've re-recompiled the unixODBC driver. My select statements all work without a hitch, but when I'm doing an update or an insert, I'm still getting the "Query string is too long" ODBC error.
Anyone have any ideas? Thanks, Evan > -----Original Message----- > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 26, 2002 10:37 AM > To: CF-Linux > Subject: RE: CF5/Postgres - "Query string is too long - Still having > problems > > > Thank you Evan, this fixed one of my problems. :) > > And with an upgrade to the latest version, I appear to be clear sailing. > Whew! I was really hoping not to have to move to MySQL. > > -----Original Message----- > From: Evan Lavidor [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 25, 2002 1:54 PM > To: CF-Linux > Subject: RE: CF5/Postgres - "Query string is too long - Still having > problems > > > Jillian, > > After you were done compiling, did you move the new > libodbcpsql.so file that > was created to /opt/coldfusion/lib/ (or whatever your install > directory for > CF is)? > > I rebuilt the module per rudi's message and replaced it in the CF > directory, > and restarted the CF service for good measure and everything > started working > much better. (Many thanks to those who helped me!) I've still > got a couple > of issues I'm debugging, but I'm not getting the "query string too long" > error anymore. > > Thanks, > > Evan > > > -----Original Message----- > > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, June 25, 2002 11:44 AM > > To: CF-Linux > > Subject: CF5/Postgres - "Query string is too long - Still having > > problems > > > > > > I have installed the new UnixODBC driver for Postgres... is > there anything > > special I need to do so that CF will use it from now on? > > > > I've restarted Postgres and CF, and I'm still getting the > following error: > > > > Error Diagnostic Information > > ODBC Error Code = 08S01 (Communication link failure) > > > > Error while executing the query; Query string is too long > > > > Any help would be appreciated. > > > > -- > > Jillian > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
