Database owner? dbo.tablename and username.tablename are two different tables.
Rick -----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> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
