When the ODBC DSN was set up, the default database is master, so you are trying to connect to the Events table in the master database which doesn't exist. The solution will be to edit the ODBC DSN to point to the proper database
HTH Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "Gieseman, Athelene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 5:09 PM Subject: RE: connection error > 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> > > > > ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
