Correction... I double checked with our DBAs and they said it can be done. As long as SQL Server can se your DB2 database, and you have the proper drivers to allow the two to speak, then yes...you can do this.
-----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2008 3:12 PM To: CF-Talk Subject: RE: Query Muliple Databases 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:312468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
