CFQUERY a view that queries 2 databases
Filed under CFC , ColdFusion , Flex , T-SQL
I made a view on SQL SERVER 2005 that queries 2 databases. I then set up a datasource to the database that contains the view. I set up a coldfusion login specific to that database containing the view. When I try to RemoteObject the view in flex 3 I get an error stating that the cfc could not be invoked. Is this because the coldfusion login only has permission to one of the databases? Does anyone have any experience with this problem? Thanks in advance
PS I set up a view that queries only one database with the same datasource and it works no problem..
Oct16