> Ok, enabling trusted connections and entering the database's > login info in the CF Administrator let me log in thru CF, > but now I'm getting a SQL base table not found error: > > "Error Diagnostic Information > ODBC Error Code = S0002 (Base table not found) > [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object > name 'Settings'. SQL = "SELECT * FROM Settings" > > The table is there, I've viewed/edited it in Enterprise > Manager. Any idea what could be causing this? The query > seems pretty simple.
The most common cause for this is neglecting to include the database name in the appropriate field in CF Administrator. If you leave the field blank, it'll use the default database, which is usually master. Also, in general, you shouldn't have to use a trusted connection, and you're usually better off using a native SQL Server account. For that to work, your SQL Server has to be configured to allow mixed logins (Windows authentication and SQL Server authentication). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
