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
<!--- Get notes data --->
SELECT NoteID, SourceTable, SourceKeySegment1, Subject, Note
INTO ##tmpNotes
FROM ACCESSNOTES...NOTES
WHERE ExpirationDate >= #Now()#
</cfquery>
Hi --
I need to query an Access DB that is on a remote server. The remote server
also has SQL 2005 and the Network Admin has set the Access DB up as a linked
server on the SQL Server. (I can see it remotely using Management Studio and
drilling down to Server Objects\Linked Servers - however I cannot open it
like a SQL DB and see the tables). My questions are: 1) how to I connect
to this using CF8 to pass queries? 2.) Do I set up an ODBC Connection? 3.)
do I have to write stored procedures for everything? I need some basic info
so if anyone could point me in the right direction it would be most
appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:320381
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
