Is the default storage mechanism for Client sessions set to the right db in the Administrator?
Or is this some other table named Cglobal? I'm assuming it is dealing with client sessions because of the name of the table. Steve -----Original Message----- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 7:09 AM To: CF-Talk Subject: RE: help! cgi.global Hi Steven, I've configed another db and other sites are using it ok. It's only on this site and with one query I'm seeing the error. jenny >>-----Original Message----- >>From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] >>Sent: 02 February 2006 12:06 >>To: CF-Talk >>Subject: RE: help! cgi.global >> >> >>Jennifer, >> >>Looks like your database for client variables wasn't configured. If you >>go into the CF Administrator there should be an option to create the >>tables you need. >> >>Steve >> >> >>-----Original Message----- >>From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] >>Sent: Thursday, February 02, 2006 6:58 AM >>To: CF-Talk >>Subject: help! cgi.global >> >> >>I've just moved a site to a new server and I've set up a separate >>database >>for the client variable store. >> >>I changed the value in my application.cfm, but I'm getting the following >>error on some pages: >> >>Error Executing Database Query.[Macromedia][SQLServer JDBC >>Driver][SQLServer]Invalid object name 'dbo.CGLOBAL'. The specific >>sequence >>of files included or processed is: >>C:\Inetpub\chicksnchaps.co.uk\search\browse.cfm >> >>So the application is still looking for the tables in the old location. >> >>How do i solve this please? >> >>Thanks, Jenny >> >> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231086 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

