Chris, You can put your client vars in any dsn you like, so long as you specify that dsn as a client var repository in the CF Administrator. If you've already created your tables, just leave the ''create tables'' choice unchecked when you do the above.
This lets you specify multiple client var datasources, one for each client assuming each client has its own dsn. You may or may not want to do that. I used to but mostly don't anymore, preferring instead to keeping those w/generic needs in a server-wide db. I have some clients whose expirations differ from the norm, so I break them out into their own db's. I'm not sure this is something you can really manage with a shared host. You'll have to ask them directly if they can set you up. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 9:44 AM To: CF-Talk Subject: Client Variable Database Storage Howdy, I finally have an opportunity to get my feet wet using client variables and have some questions. I have a Forums app (fbOpenForums) running fine locally, but have a question about the database storage part. Reading thru the WROX book Professional ColdFusion 5 last night, the author states (on page 386): "There is only one requirement for the client variables database: it must be empty. Create a blank database and call it ClientVariables. It is absolutely imperative that you do not create any tables or objects within this database. ColdFusion will enter the required tables once we are done configuring ColdFusion Administrator to use our new data source." So, before I read this, I had already created the client variables storage tables, using CF Administrator, in an existing database where my Forums app will be integrated with another site. It seems to be working fine. Can anyone explain why the client variables need to be stored in a separate data source and not combined with a pre-existing data source? Also, when I'm ready to go live with the production version on my site, this will be hosted with a 3rd party hosting company. How do they handle the issue of having a separate data source for storing client variables? Anyone know about that? TIA, Chris Montgomery [EMAIL PROTECTED] Airtight Web Services Web Development, Web Project Management, Software Sales Macromedia Sales & Consulting Partner 210-490-3249/888-745-7603 ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
