Skip to main content
D
Dax_Trajero
Inspiring
July 2, 2008
Question

client variables problem

  • July 2, 2008
  • 1 reply
  • 319 views
Ami I correct in thinking I setup client variables in application.cfm

<cfapplication
name="DrivelinkCatalogue"
clientmanagement="Yes"
sessionmanagement="Yes"
setclientcookies="Yes"
sessiontimeout="#CreateTimeSpan(0, 0, 360, 0)#"
applicationtimeout="#CreateTimeSpan(0, 0, 360, 0)#"
clientstorage="cfclientstore"
loginstorage="session">

<cfparam name="client.color" default="blue">

I've got cfclientstore pointing to a local msaccess database for testing purposes, which Coldfusion gives OK when checked in the administrator

The problem I'm finding is, my application isn't storing changes to this client variable eg.

On page setRed.cfm I can <cfset client.color="red"> and it outputs the color as red
But, if I then open another page, checkColor.cfm, it shows the value as blue

Any ideas why this might be happening ? Even though I don't want to, when I set the clientstore to registry it works fine. Something is up with my client store DSN I believe. Is a MSACCESS database ok to use ? Do I need to alter any advanced settings to accomodate MSACCESS as my client data store ?

Incidentally I did a search for anyone experiencing a similar issue and found this guy:
http://kiribao.blogspot.com/2008/05/coldfusion-client-variables-voes.html


This topic has been closed for replies.

1 reply

D
Dax_TrajeroAuthor
Inspiring
July 2, 2008
I've since found out there is an incompatibility between CF8's access drivers and MS Access 2007. All explained here for the benefit of anyone finding this post and suffering the same problem as me.

Microsoft Access 2007 and ColdFusion 8

With Microsoft Office 2007, Microsoft strikes again and implements a new format for their Access database standard. I do not recommend using Microsoft Access databases for production applications. In fact, I believe you will pay, sooner or later, for adopting such a practice. Nevertheless, it is useful for testing or development at times, and more importantly, you may be in a situation like me, where there are databases that you do not "own" or control but your ColdFusion apps must use them.

That said, please note that the drivers that come with CF8 do not support Access 2007. This is mentioned in the ColdFusion 8 Release Notes under #69495. The solution is nicely described right in the release notes. Download and install the Data Connectivity Components for Office 2007, set up a Windows ODBC connection, and use ColdFusion's ODBC socket driver to connect to the Windows ODBC connection. A bit irritating that all of this has to be done, but like I said at the outset, these irritants are the price you pay, among other things, when using Access databases.

Another point to note! You thought you were done, but no, Microsoft has more joy in store for some of us. The Office 2007 drivers do not support Windows 2000. So if your server is still sitting on a Windows 2000 installation, the final word is either (a) No Access 2007 for you, or (b) Time to upgrade to Windows 2003 SP1 or later.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices