Re: DSN is Saving CF Query Ops to Wrong Database?

> the DEV table on one instance while the datasource 'mydb' is configured to use the TEST table

Ugh. Long night of tracking down shadows, hints, and allegations. That's the DEV *database* and the TEST *database*, not tables.

Turns out the problem was that the previous developer had buried sql queries explicitly stating the database to use in the query:

INSERT INTO [DEV].[dbo].[myTable]....

-Matthew

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324302
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4