Dunno WHAT happened - I recreated the tables and now it works. Spooky... -----Original Message----- From: Venable, John [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 7:54 PM To: 'Ian Lurie ' Subject: RE: Client var weirdness
Interestingly enough, we just had the same thing happen. Try re-establishing your client variables DB. Change it to save into cookies, save that, and then change it back to the DB you are using. Dunno why it happened, but we upgraded from SQL Server 7 to 2000 and got the same error. John Venable Director of Web Architecture Epilepsy Foundation -----Original Message----- From: Ian Lurie To: CF-Talk Sent: 4/18/02 10:37 PM Subject: Client var weirdness Help?! We just set up a new SQL box. Now we get this whenever you access a CF page in an app that uses client vars: ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CGLOBAL' We set up the client var table as normal - both tables are there, so I'm not sure what it's not finding... Any ideas? Ian ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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