Yes I remembered that after I posted. Unfortunately I was too late to correct myself before you lot beat me to it. :-)
> -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 18 May 2004 15:09 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] OT - SQL query on two databases > > > This is incorrect, you can easily create a view from data > across two databases (in SQL Server anyway) with the > following caveats - 1) If the databases are on the same > server 2) the user has a login to both databases > 3) the permissions are set properly, then you can access the > data in two databases as easily as one. > > > > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 18 May 2004 14:51 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT - SQL query on two databases > > A view is local to a database, so you cannot have a single > view form two databases. But you can setup two DSN's, query > from both databases, and combine the results as long as you > are selecting the same data with the same structure from both. > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] > > Sent: 18 May 2004 14:25 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] OT - SQL query on two databases > > > > > > > > Hi, > > > > I am using SQL2K and want to query data from two databases. > > > > I want to create a view which has two databases as its source. > > > > How do I do this ...? > > > > > > Regards - Paul > > > > > > > > > > ************************************************************** > > *********************************** > > The information contained within this e-mail (and any > > attachment) sent by Birmingham City Council is confidential > and may be > > legally privileged. It is intended only for the named recipient or > > entity to whom it is addressed. If you are not the intended > recipient > > please accept our apologies and notify the sender immediately, or > > telephone +(44) 121 303 6666. Unauthorised access, use, disclosure, > > storage or copying is not permitted and may be unlawful. Any e-mail > > including its content may be monitored and used by Birmingham City > > Council for reasons of security and for monitoring internal > compliance > > with the office policy on staff use. > > E-mail blocking software may also be used. Any views or opinions > > presented are solely those of the originator and do not necessarily > > represent those of Birmingham City Council. > > We cannot guarantee that this message or any attachment is > virus free > > or has not been intercepted and amended. > > > > ************************************************************** > > *********************************** > > > > > > -- > > These lists are syncronised with the CFDeveloper forum at > > http://forum.cfdeveloper.co.uk/ > > Archive: > > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > CFDeveloper Sponsors and contributors:- *Hosting and > support provided > > by CFMXhosting.co.uk* :: > > *ActivePDF provided by activepdf.com* > > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > > proworkflow.com* > > *Tutorials provided by helmguru.com* :: *Lists hosted by > > gradwell.com* > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > This e-mail is from Reed Exhibitions (Oriel House, 26 The > Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a > division of Reed Business, Registered in England, Number > 678540. It contains information which is confidential and > may also be privileged. It is for the exclusive use of the > intended recipient(s). If you are not the intended > recipient(s) please note that any form of distribution, > copying or use of this communication or the information in it > is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the > sender or call our switchboard on +44 (0) 20 89107910. The > opinions expressed within this communication are not > necessarily those expressed by Reed Exhibitions. Visit our > website at http://www.reedexpo.com > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
