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 *
FROM Table1 JOIN Database2.dbo.Table2
ON Table1.Field = Database2.dbo.Table2.Field
ORDER BY Table1.Field
That select fails, when sent via Cold Fusion. Here is the error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM
clause.
Data Source = "Datasource1"
SQL = "SELECT * FROM Table1 JOIN Database2.dbo.Table2
ON Table1.Field = Database2.dbo.Table2.Field
ORDER BY Table1.Field"
Is this even possible? Why is there an Access driver error? Both of these
are SQL Server datasources.
Thanks.
------
Paul Nagai
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
