> 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?
I don't know, since I've never tried to use OLEDB to connect to a Client variable repository. Perhaps there's something else going on, such as a permissions issue, although that seems unlikely based on the error message. However, there's nothing to stop you from simply setting up an ODBC datasource pointing to the same database, and using that for your Client variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
