Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL 7 - VB6, DTS Package, LoadFromStorageFile Error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-22 : 09:18:04
Leo writes "Hi,
My VB6 app executes DTS package on SQL7 sp1. Method

< oDTSPackage.LoadFromStorageFile mUNCFilePath, "" >

runs OK on developer's PC (WinNT, Enterprise Manager, VS6) and when executed on user's PC (Win98, MSDE) returns error:
#-2147024809 "The parameter is incorrect."
I suspect that despite DTS package implements SQL authentication it still requires developer's workstation ID passed to server with connection string. Is this correct? If so, any workarounds?
Thanks a lot.
Leo"
   

- Advertisement -