Nah, we are using MS SQL Driver. I wouldn't mind switching to a JDBC driver but I guess SQL 7 doesn't have one (without spending $$).
arrrg. -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:33 AM To: CF-Talk Subject: RE: Client Variables 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
