specify a uname and pword in the <CFQUERY...>
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Rick Eidson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 22, 2002 12:58 PM
To: CF-Talk
Subject: RE: connection error
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>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
