I'm going out on a limb here and say that you're going to be out of luck.
You CAN query between multiple databases, as long as you've prepended the
column name with the table name, and db name. But querying across two
seperate softwares? Doubt it.
SELECT u.id, u.name, c.category
FROM db1.users u
INNER JOIN db2.categories c
ON u.fkCategories = c.id
That works just fine, but I doubt you can hook between two competing
products. Have you considered a nightly import from the DB2 database into
your SQL server database?
andy
-----Original Message-----
From: Tim Stutzman [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2008 2:33 PM
To: CF-Talk
Subject: Query Muliple Databases
Hi,
I need to write a query that selects data from two different databases,
which are a MS SQL Server and DB2.
The SQL Server has all the fields I need but one field that is in the DB2
database. I need to join between the two databases, but I have never wrote
a query that uses two different data sources.
Any help would be appreciated.
Thanks
Tim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312466
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
