> I have 2 databases located on the 2 different NT servers, Is
> there any way i
> can write one query that refers to different odbc sources, if
> yes, how and the syntax,
If they are the same database type, then there is usually a way...
in SQL Server it's quite easy;
<cfquery name="myQuery" datasource="myDSN">
select t1.column1, t2.column2
from table1 as t1, serverName.databaseName.dbo.table2 as t2
...
</cfquery>
using Access you can refer to the database by a it's exact location, but I
can't remember the code as I haven't worked in Access for over a year now
If they are differing database types, as in Access and SQL Server, then no,
you can't
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
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.
