Hi All - I recently setup a Win2K SP2 / CF5.0 Ent server to store client variables in a SQL Server 7 via a OLEDB connection, but whenever accessing any pages using client variables, I would receive this cryptic error: Error Diagnostic Information OLEDB Error Code = 0 Null accessors are not supported by this provider. I did a search for the error over at forums.allaire.com, and noticed that other people were receiving the same error when trying to store their client vars in a OLEDB DSN. I change the DSN to back to ODBC, pointed towards the same exact SQL server, same database, same tables, everything the same - and now I don't get the error anymore. Perhaps not so coincidentally, when I was setting the server up CF server wouldn't create the necessary tables using an OLEDB connection. I had to create a ODBC DSN and use that DSN to create the client variable tables. All of this begs the question ... Why can't I store client vars in a OLEDB DSN, even though OLEDB is recommended over ODBC? Any insight into this rather odd problem would be appreciated. Jay Sudowski --------------------- Handy Networks LLC TEL: 877-70-HANDY FAX: 888-300-2FAX URL: www.handynetworks.com --------------------- Providing reseller and dedicated Windows 2000 web hosting solutions. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
