> This was a weird one. I setup a MS SQL database and forgot > to fill in "database" under the CF admin. > > I submitted it and it said it was "OK". > > I thought, OK my database is hooked up, but in my code I kept > getting these strange errors basically saying the table you > are trying to query is not a valid object. I beat my head > agains the wall thinking it was my code, and eventually look > back in CF Admin at the database and discovered my mistake. > > So once I filled in the "database" field in the CF admin it > all started working. > > Why would CF Admin report back that the database connection > verified if the database itself could not be connected too? > Sound like a bug.
This is the expected behavior. CF isn't connecting to a database, it's connecting to a database server. If you don't specify a database, you'll use whatever the default database is for that user - probably "master". Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312022 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
