On Wed, Nov 10, 2010 at 12:02 PM, Carl Von Stetten <[email protected]>wrote:
> +1 on the link Matthew sent. If the databases are on two different > servers (or two different instances of SQL Server on the same box), you'll > need to create a linked server on one of the servers to connect to the other > one. > Right--good point, and bear in mind this is something I haven't had to do in about 5 years. But you don't create datasources to both databases. You just point to one, and on that server you do whatever is necessary to let you refer to the other database within your SQL. At least that's my recollection. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
