>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:320394
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
