Are you using ODBC Socket type connections? I tried that with Oracle and SQL Server and the results were weird stuff like you describe and worse. Switching to the jdbc drivers provided by CF solved my problems.
--Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:19 AM To: CF-Talk Subject: Client Variables Is anyone experiencing odd database issues with MX? We are migrating to MX, have MS SQL 7 database, and are experiencing things such as: * client variables not being saved - cfide:token are but the data is not * some select statements that used to work in 5 are now returning 0 records in MX, but when run in query analyzer return records (so it's good SQL) Seems odd that everything worked fine on 5 now lots of stuff is bombing on MX. We are thinking it might be a JDBC-ODBC problem... Anyway, is anyone having strange database happenings with MS SQL 7? Cheers, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
