Post reply

Running DTS on VB6 against Virtual PC

  • June 2, 2005 at 9:05 am

    #89378

    I am running a DTS package from VB6 on NT4 connectioning to a SQL Server 2000 on a virtual PC using the following line of code, however getting an Access denied error.

    DTSPackage.LoadFromSQLServer ServerName:=DataSource, ServerUserName:="sa", ServerPassword:="sa", Flags:=DTSSQLStgFlag_Default, PackageName:="dts_Package"

    When I set up the main connection to the database I add in the 'Network Library=DBMSSOCN' and this works but can not see how this can be added to the above line of code.

     

     

  • July 20, 2006 at 10:30 pm

    #650589

    Hi,

    Me too facing the same problem.

    No Solution to this ?

     

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply