Need data from a second server?

[jameslx]

I have a Crystalreport residing on server_1 and ParamTables on the same server. A DTS package (VBScript) gathers the Parameters and calls the CrystalReport and places the parameters into Crystal. Then CrystalReport.Export False statement is executed and the report runs a StoredProc on server_1 for the data and when complete places the report into a directory on the same server. This all works fine until CrystalReports needs to use a stored proc on another server Server_2 at which point the .export False statement fails to run Crystal. I am not sure how to correct this. The DTS package need to run for data from either server. Any ideas?

 

[DFleisch]

James,

I hoping we can help eachother. If your app/report needs to call multiple stored procedures on different servers, than I would imbed the calls withing the procedure that you initially execute. If you absolutely need to connect to another SQL Server to execute the other procedure, perhaps you need to Set your objects to NOTHING and respecify the login info i.e.

Dim craRpt ' is a CRAXDRT.Report object
Dim craApp ' is a New CRAXDRT.Application
set crClass = new CRAXDRT.Application
Set craRpt = craApp.OpenReport(DTSGlobalVariables("pvReport&quot.Value)
craRpt.Database.Tables(1).SetLogOnInfo DTSGlobalVariables("DBA_Source&quot.Value, _
DTSGlobalVariables("DBA_InitialCatalog&quot.Value, _
DTSGlobalVariables("DBA_Username&quot.Value, _
DTSGlobalVariables("DBA_Password&quot.Value


Now can you help me?

In my code that I've included above, DTS complains that the CRAXDRT class is not defined. For some reason, you can't do a CreateObject on this. Can you send me a sample of your code at DFleischman@Highlights-corp.com?

Thanks!