I had this happen to me last week for the first time. I'm not sure exactly what happened. I'm using CF 5.0 on Windows 2000. I restarted the server where CF lives and it worked just fine. It happened again last weekend when I changed a data source. It was almost like it needed to be restarted to refresh something. Restarting the CF services did not do the trick. Sorry I can't be more specific. Hopefully it will point you to something that you can simply restart or refresh to get it going.
Athelene Gieseman [EMAIL PROTECTED] -----Original Message----- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:02 PM To: CF-Talk Subject: connection error I have establised a connection with my SQL database throught CF Administrator and have verified it's connection. However, when I go to my main .cfm page, I get an error that it cannot find my base table. How can that be? I can see my database and see that it's connected and see all the tables in it when I open it in SQL? Anyone know what's going on? This is the exact message. Error Diagnostic Information ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Events'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (5:1) to (5:48). Date/Time: 04/22/02 15:50:15 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Remote Address: 127.0.0.1 Here's my query to access the database: <cfquery name="selectevent" datasource="Events"> SELECT * FROM Events WHERE ID = ID </cfquery> ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
