The datasource specified in the cfquery points to the SQL Server while the
linked server setup on the SQL Server points to the Access database. Thus
the ODBC driver is SQL Server.
I retrieve the contents of the Access table to a SQL Server temp table
because a later step in my process joins various tables and I want to avoid
a cross-server join.
>In this example, I copy the contents of an Access table into a SQL
>Server temp table. 'ACCESSNOTES' is the name of the linked server in
>SQL 2005 Express and 'NOTES' is the name of the table.
>
>
><cfquery name="qry_get_tmpNotes" datasource="#request.ds#">
> <!--- Drop temp table if necessary --->
> IF (object_id('tempdb..##tmpNotes','u') > 0)
> DROP TABLE ##tmpNotes
Thanks so in this example, id the datasource connecting to the SQL Server
temp table OR to the Access DB? What driver is used in the ODBC Manager?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320401
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
