Datasource as Client Store

I have tried restarting the server and recreating the db client store tables. When I set my client variables to cookie my forum software is able to remember my username and password when I check the box requesting the values to be remembered. As soon as I switch the client variables to be set in the db the forum software is no longer able to remember my username and password and I never get any records written to the client variable tables.

Have you tried restarting the server?

Hi je4pym,
Thanks for the response to my question. After creating I did select the database client store and applied the settings. I have a third party web store and forum that both seem to require client variables because if I set the setting for client variables to none both pages give an error that they need client variables and the administrator is set to none.

A little more background on the situation. My site had been using the registry for client variables for the last 9 months. The registry grew considerably and seemd to be causing performance issues on the server. I changed the client variable setting to cookies a week or so ago and used the clientvarpurge template available from adobe. Yesterday I created the tables in my database using the ColdFusion Administrator and set the client variables to use this as the client variable store.

It now appears that I have client variable in my registry and I can not get any to be written in the database. Looking through the log files I do not see anything that would seem to point out the issue.

After you create it, you've still got to go back and actually select that store as your client store and then apply it. I don't remember if you need a server reboot or not.

Also, if your code is forcing variables into session scope then nothing will be written to your db.