You need to configure these files in ColdFusion Server Administration under the "Variables: Menu Option if you haven't done so already.
Add an ODBC connnection to Client Variable Storage and then click on the check box that says "Create Client database tables" Then be sure your "default client variables" are then pointing to this connection. Thanks, Doug -----Original Message----- From: Richard Tugwell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:23 PM To: [EMAIL PROTECTED] Subject: Client VAriable problem Hi All I posted this on CF-Talk too - so don't get mad I have a site - (CF5/SQL7/W2000) FB3 of course! on my desktop, (also on an ISP - Intermedia). I have just copied it all to a new laptop to take and show a client (CF5/SQL2000/W2000). I scripted the SQL setup and it ran ok. The site uses client variables, stored in the database. I have configured client storage/users/logons/permissions etc identically on both machines, but when I try and run it through the laptop I get an ODBC error Base Table Not Found .... Invalid Object Name CGLOBAL etc etc. I thought CF configured these tables automatically as soon as it hit a <cfapplication tag> ? Everything runs ok apart from the client variable functions. If I disable this part of the site I get no errors and DB access runs unhindered Both my versions of CF5 are single use developer configurations Any ideas would be appreciated. I'm probably just being stupid Cheers Richard ==^================================================================ This email was sent to: [email protected] EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9 Or send an email to: [EMAIL PROTECTED] T O P I C A -- Register now to manage your mail! http://www.topica.com/partner/tag02/register ==^================================================================
