James Blaha

This article is a continuation of the how-to guide (Part 1 ran last month) for setting up a ColdFusion 5 server and a Microsoft SQL Server 7.0 to execute a DTS package through the ColdFusion server. The main objective of the guide is to create a DTS package that will result in file output that will be delivered to a network UNC path or mapped drive using a set of stored procedures executed by ColdFusion. The configuration for this setup will also allow a ColdFusion server to properly propagate user rights across networked servers and domains for using shared access. Although this guide focuses on the use of a ColdFusion 5 server and SQL Server 7.0, you can easily apply this information to a ColdFusion MX server and SQL Server 2000. Let's review the key areas that were co... (more)

ColdFusion and SQL Server Permission Integration

In this article, I'll show you how to set up a ColdFusion 5 server and a Microsoft SQL Server 7.0 that will execute a DTS package through the ColdFusion server. The main objective is to create a DTS package that will result in file output that will be delivered to a network UNC path or mapped drive using a set of stored procedures executed by ColdFusion. The configuration for this setup w... (more)