RE: Can i use 2 datasources in one app?

It can work with SQL Server, too (if the databases are on the same server ... and possibly, even if they're not). I'm working on a query that looks like this: cfquery name="MyQuery" datasource="MyDatasource" SELECT * FROMTable INNER JOIN servername.databasename.dbo.table2 ON

joining two tables from different databases/datasources

Howdy, I want to join two tables from different databases/datasources. Both databases are on the same SQL Server. Both databases are Cold Fusion datasources. The following select returns the correct data in SQL Server Query Analyzer. SELECT * FROMTable1 JOIN Database2.dbo.Table2

odbc to ole db driver between cold fusion, access

Howdy, My question: Is anyone aware of a resource on the changes required for this conversion? I've noticed some queries supported by ODBC are not supported by OLE DB and some date formats are not supported. I'm hoping there aren't more conversion issues than those I've already discovered...