-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: SitaramanM
Message 7 in Discussion
Hi Quite Right. I was testing in ASP.Net and it worked fine there. Tried from ASP
and i got the problem. Infact when debugging i saw that LoadFromServer does not load
the package from SQL Server(The opkg.name was blank)?????? Code is as follows
StrDTSPacName="aa1" Set Objcmd = Server.CreateObject("ADODB.Command") Set Objcn =
Server.CreateObject("ADODB.Connection") Dim oPkg Set oPkg = CreateObject
("DTS.Package2") oPkg.LoadFromSQLServer "localhost", "sa", "sa", 0, "", "", "", "aa1"
oPkg.Execute The problem is in security. Add the IUSR acct and ASPNet acct to
admin group and the program executes properly. This is for testing only and to
pinpoint the probem to security reasons. After this u need to check out and assgn
proper security permissions sop as to ensure that these anonymous accts o not have
admin priveleges regards, sr
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
