Either that or you can set the user ID that that datasource uses to a different default database instead of master. In ODBC if you leave default database blank than it will default to the default database that the user id has rights to.
Josh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:55 AM To: CF-Talk Subject: RE: Client variable storage Have you set the default database of the datasource to the right value? -----Original Message----- From: JS [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 16:30 To: CF-Talk Subject: Client variable storage I set up a new SQL7 database. Registered it as an ODBC datasource in the CF Administrator. Added as a client variable store. Selected the new datasource as the default datastore. No matter what I do my applications are using the 'master' database as client storage. Even if I use the clientstorage parameter in the cfapplication tag to specify the new datasource. If I specify a datasource that does not exist as a client storage the template errors stating that the datasource is not set to store client variables. What is causing this? JS __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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