Is the problem random or reproducible? Is dbBanana used anywhere by the Web site, or should that database not be used at all? If it should not be used at all, do a site-wide search for dbBanana to make sure it does not show up anywhere in the code. Are the two databases allowed to talk to each other? Is one user account given permission to both databases?
Watch our for SQL like "Use dbBanana" or "SELECT FROM dbBanana.dbo.table." Maybe do a site-wide search for "use " If you think it is a DNS issue, put in the IP address of the db server in cfadmin to eliminate that possibility. Every time I have seen the issue with the symptoms that you describe it turns out to be a developer-caused error, not a server error, network error, or a random bug. -Mike Chabot On Thu, Feb 10, 2011 at 1:03 PM, Matt Williams <[email protected]> wrote: > > Basics: Windows 2003 server, CF 7.0.2, SQL Server 8 > > Multiple datasources, but lets specifically look at the ones named Apple > and Banana. They point to separate databases on the same SQL server, > connecting to db Apple and db Banana respectively, as expected. However, > occasionally, datasource Apple gets mixed up and attempts to use db Banana. > > At first my error reported the following: > Datasource: Apple > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'dbo.company'. > > After verifying the table did indeed exist, I did a simple cfquery to > return the tables that do exist in datasource Apple. This query returned the > tables from database Banana! I double and triple checked the datasource in > the CF Administrator. It is correctly set to Apple. > > This is happening on our dev server. My solution thus far has been to > create a new datasource called Apple_tmp. It seems to work. I did try to > then delete Apple and rename Apple_tmp back to Apple, but it soon had the > same issue. Ahhhh! > > My suspicions are some DNS or IP funkiness but have yet to track that down. > This is all on one physical box, so I don't know if that would be it or not. > I'm mainly curious if anyone else has seen this. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
