Well this is what I have done, and it works just fine. My server people won't like it though. They are firmly of the opinion that OLEDB <--> SQL Server is much more stable than ODBC <--> SQL Server. (and the reverse with connections to Access)
Strange that it says in CF_administrator "To configure a data source for client variable storage, first configure an ODBC, OLE DB or native data source... " Dave Watts wrote: > > > 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 > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists