I have client vars working fine on an ODBC connection to the default tables CF set up for me in "Master". Then methinks, its a good idea to have client vars for the app stored in the same db as the one for the app. (WIN2K - CF5 - OLEDB - SQL Server 7)
In the first instance, when adding the client variable store in CF administrator, if I enable the "Create Client database tables" option then it returns the message "Unknown Database type: Unsable to create client tables, please uncheck Create CLient Tables". Undaunted, I created the CDATA and CGLOBAL tables manually in the DB. Yes I am certain the structure, datatype, sizes etc are correct (I double cheched from a post on this list a while back) and yes, "Enable the retrieval of long text" is enabled in the datasource section. (also gleaned from this list's archive). I set the CFAPPLICATION name, clientmanagement and clientstorage attributes in the APP but get the error: OLEDB error code = 0 Null accessors are not supported by this provider. Does this mean that in fact client vars don't work with OLEDB datasources? note my dev server for this app is CF5 but the production one is 4.5.1, I have even tried a cold reboot after doing this setup but no difference. -- Regards; Richard Meredith-Hardy ------------------------------------------------------------- [EMAIL PROTECTED] Mob: + 44 7771 526513 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
