Re: [Reactor for CF] Schemas - MS SQL 2005

[Beth Bowden]

We normally associate a user with a particular schema.  So if we want a different schema, we set the username/password to the DSN appropriately. 

If I understand right, this won't work for you because you need to across more than one schema. Is that correct?

Thanks, Beth

On 24 Aug 2006 01:21:19 -0000, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:

To second Matt's email, we have implemented schemas in MS SQL 2005. So we
have tables like Core.User and ProductX.Products. Is this supported in Reactor?




I'm not sure we can simply put:

<object name="Core.User" alias="User"
/>

because that throws errors?



Anyone using Schemas in MS SQL 2005? I
see a similar thread on Oracle Schemas as well with no resolution attached.

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --