The code wouldn't be that complicated considering you have both ODBC sources
set up on the box that the cold fusion queries are running from. Just
submit to both DataSources through your ODBC setup through cf. Or am i
missing a "HUGE" step?
~~~~~~~~~~~~~~~~~
Kevin Mansel
Senior Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 9:32 AM
To: CF-Talk
Subject: RE: SQL SERVER 7
> Could anyone give me any feedback on the following:
>
> We have a SQL Server say for example "SQL1" based in Belfast, and
> another SQL Server "SQL2" Based in London.
>
> What i need to do is write a stored procedure from a database in "SQL1"
> "Table1" to insert data into "SQL2" "Table2",i have a few ideas but any
> tips and feedback would be most apreciated.
As long as the 2 servers can "see" each other, then there shouldn't be too
much of a problem
If either is invisible to the others, then this will obviously be impossible
Never done it with a SP, but I've done it in queries quite happily - in
fact, one in New York and one in London
It was quite a while ago, but I'm sure I still have the code somewhere
Philip Arnold
Director
Certified ColdFusion Developer
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.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
