Hey - thats it solved. Just deleted the repository and recreated it. Don't recall, but maybe I didn't have the create tables option checked first time around.
Thanks for all who replied Richard Barney Boisvert wrote: > you have to tell cf to create the client storage tables when you create > the datasource as a client variables repository. In the CF > administrator, go to the client storage page, and remove your current > repository. Then recreate it, making sure that the 'create tables' > option is checked. I'm not quite sure on the verbage, since I don't > have > the admin to look at right now, but that should get you close. > > cheers, > barneyb > > -----Original Message----- > From: Richard Tugwell [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 04, 2002 10:23 AM > 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 > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.368 / Virus Database: 204 - Release Date: 5/29/2002 > > > ==^================================================================ 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 ==^================================================================
