That's exactly what happened. The datasource was there but with no database specified on one of the servers.
>From: Dave Watts <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: sql error >Date: Wed, 15 May 2002 18:51:11 -0400 > > > > I think I figured it out. I have a web farm and the database > > > name was not specified on one of the server's CF Admin. > > > > that's not it. That would give you a DATASOURCE NOT FOUND > > error. Chances are you just mapped to the wrong DB somewhere > > or your permissions are screwed up somehow. > >No, that would do it - the datasource would exist, but it just wouldn't >point to a specific database, and with say SQL Server, you'd end up >querying >the default database, which unless you change that for the specific db user >account would be "master". > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
