hrothenb

Try: Imports CrystalDecisions Imports CrystalDecisions.CrystalReports Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Dim RptDoc As New ReportDocument() Dim CrTables As Tables Dim CrTable As Table Dim crtableLogoninfo As New TableLogOnInfo RptDoc.Load(Server.MapPath(ReportFullFilename)) With crConnectionInfo .ServerName = "myServer" .DatabaseName = "myDatabase" .UserID = "myUserID" .Password = "myPassword" End WITH CrTables = RptDoc.Database.Tables For Each CrTable …

--Generate BCP DOS command to export pipe delimited data. DECLARE @BCPCommandString VARCHAR(8000) DECLARE @FilePath VARCHAR(1000) DECLARE @FileName VARCHAR(1000) DECLARE @SPName VARCHAR(1000) DECLARE @ServerName VARCHAR(1000) DECLARE @tSQL VARCHAR(1000) SET @ServerName = 'myServer' SET @tSQL = 'Select top 10 * from myTable' SET @FilePath = 'C:\temp' SET @FileName = 'myFileName.tmp' SET @BCPCommandString …