Hrmm.. I found the problem. It wasn't that query - it was CF trying to use an OLEDB datasource for Client variable storage. I temporarily switched it to the system registry (ack!) and the problem went away.
Does anyone have the schema for the CDATA and CGLOBAL tables so I can make sure everything is set up correctly? <cf_rant> This DB was moved by the hosting company, and a lot of table attributes were lost. Generally unimportant things like indexes, primary keys, identity columns, etc.. what fun!! I love workin with someone elses code.. makes me feel all.. tingly... inside.. </cf_rant> -----Original Message----- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 05, 2002 10:36 AM To: CF-Talk Subject: RE: Odd OLEDB Error Sure - here's the offending query. It's so simple I'm totally stumped! <cfquery name="checkit" datasource="FLORIDAHOLOCAUSTMUSEUM" dbtype="OLEDB"> SELECT usertext, passtext FROM useandpass WHERE usertext='#form.usertext#' AND passtext='#form.passtext#' </cfquery> -----Original Message----- From: Jennifer Larkin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 6:58 PM To: CF-Talk Subject: Re: Odd OLEDB Error The code, man. The CODE. I mean, it might help us to see the query that is causing this error. ;) At 06:00 PM 1/4/02 -0500, you wrote: >Does anyone have a clue as to what this means?? > >Error Occurred While Processing Request >Error Diagnostic Information >OLEDB Error Code = 0 > >Null accessors are not supported by this provider. > > > >Date/Time: 01/04/02 17:34:26 >Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) >Remote Address: 24.94.124.95 >HTTP Referrer: http://64.157.12.165/admin/cm_tree.cfm > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
