The DTS COM Object that installs with SQL Server, only runs locally to the
best of my knowledge (I don't think it can be called from remote machines
the way DCOM objects can). I wrote that code on a machine running SQL
Server and Enterprise Manager, so I'm not sure, but I believe you can
install the enterprise manager alone on the machine running CFAS, and be
able to use the code.
~Simon
Simon Horwith
Allaire Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-----Original Message-----
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 12:32 PM
To: CF-Talk
Subject: RE: DTS/Com error...
No... Sql7 lives on a seperate machine called SQL_Server. I take it this is
a problem?
Marcus
> Are SQL Server or the SQL Server Enterprise Manager installed on the same
> machine as the CF Server?
>
> ~Simon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
