|
|
You're in the
sql server dts
group:DTS and ASP
sql server dts:
once I try it from the web it is crashing , I am trying just a simple package that moves an excel doc to a Sql server table. Works thu enterprise but not thru web. Does Excel need to be installed on Web server, am I missing a ODBC or ole DB driver on the server. When coming in thru the web what user is it trying to use, do I need to set up a particular type of user with what permissions? I can do a delete on a table, I just can't move data from point A to point B. Any help on this is greatly appreciated.
First things to check are -
DTS components correctly installed on the web server Correctly determine the execution context and verify that this account has permissions to load and execute any commands inside the package. If you give us an error message it may help. -- Darren Green http://www.sqldts.com [quoted text, click to view] "GregIpaper" <anonymous@discussions.microsoft.com> wrote in message news:375901c48f72$dec877a0$a501280a@phx.gbl... > I have seen many examples of ASP and DTS package, however > once I try it from the web it is crashing , I am trying > just a simple package that moves an excel doc to a Sql > server table. Works thu enterprise but not thru web. Does > Excel need to be installed on Web server, am I missing a > ODBC or ole DB driver on the server. When coming in thru > the web what user is it trying to use, do I need to set up > a particular type of user with what permissions? I can do > a delete on a table, I just can't move data from point A > to point B. Any help on this is greatly appreciated. > > Thanks
....and no you don't need Excel installed on the web server, just DTS
components and normal MDAC which would already be there I assume for your website to work at all.. -- Darren Green http://www.sqldts.com [quoted text, click to view] "GregIpaper" <anonymous@discussions.microsoft.com> wrote in message news:375901c48f72$dec877a0$a501280a@phx.gbl... > I have seen many examples of ASP and DTS package, however > once I try it from the web it is crashing , I am trying > just a simple package that moves an excel doc to a Sql > server table. Works thu enterprise but not thru web. Does > Excel need to be installed on Web server, am I missing a > ODBC or ole DB driver on the server. When coming in thru > the web what user is it trying to use, do I need to set up > a particular type of user with what permissions? I can do > a delete on a table, I just can't move data from point A > to point B. Any help on this is greatly appreciated. > > Thanks
Not sure what components you are referring to ?? The
connection to Sql server is there, I can do deletes, just cannot do a transfer of data from A to B. I am thinking it's a security issue signing in thru the Intranet. I understand when coming in thru the web the user assigned in the application is not used (true ??). I am still not sure what I am missing The code came straight from www.sqldts.com website. Surely it can't be this hard, I am just missing something, course I get not real error message back other than Step [DTSStep_DTSDataPumpTask_1] failed Task "Transform Data Task: undefined" Thanks for your help [quoted text, click to view] >-----Original Message-----
>....and no you don't need Excel installed on the web server, just DTS >components and normal MDAC which would already be there I assume for your >website to work at all.. > >-- >Darren Green >http://www.sqldts.com > >"GregIpaper" <anonymous@discussions.microsoft.com> wrote in message >news:375901c48f72$dec877a0$a501280a@phx.gbl... >> I have seen many examples of ASP and DTS package, however >> once I try it from the web it is crashing , I am trying >> just a simple package that moves an excel doc to a Sql >> server table. Works thu enterprise but not thru web. Does >> Excel need to be installed on Web server, am I missing a >> ODBC or ole DB driver on the server. When coming in thru >> the web what user is it trying to use, do I need to set up >> a particular type of user with what permissions? I can do >> a delete on a table, I just can't move data from point A >> to point B. Any help on this is greatly appreciated. >> >> Thanks > > >.
I built a similar application though not using Excel. However, a few things
to watch out for: a) The app under ASP.net runs as the ASP.net user. Make sure that your database has appropriate permissions. b) Verify your authentication mechanisms -- Windows/SQL server authentication. One thing I would try to narrow the problem would be to modify your app first to see if it is able to process the Excel file (open it and dump out contents to a text file). If so, the problem can be narrowed to interactions with the SQL Server. [quoted text, click to view] "GregIpaper" <anonymous@discussions.microsoft.com> wrote in message news:375901c48f72$dec877a0$a501280a@phx.gbl... >I have seen many examples of ASP and DTS package, however > once I try it from the web it is crashing , I am trying > just a simple package that moves an excel doc to a Sql > server table. Works thu enterprise but not thru web. Does > Excel need to be installed on Web server, am I missing a > ODBC or ole DB driver on the server. When coming in thru > the web what user is it trying to use, do I need to set up > a particular type of user with what permissions? I can do > a delete on a table, I just can't move data from point A > to point B. Any help on this is greatly appreciated. > > Thanks
The components I refer to are the DTS components. DTS is a set of COM DLLs
which must be installed on the machine running the package. Can you call a COM DLL from ASP if not installed on the web server, no, so neither can you create DTS.Package if not installed correctly. By the sound of your description, this is not the case, as the objects are created, and the package is loaded OK. By default application code called from ASP uses IWAM_MACHINENAME so does this account have permissions to create the file? The SQLDTS article also suggest using a COM object setup in COM+ so that you can use an identity and abstract the permissions required for DTS away from those used by ASP. -- Darren Green http://www.sqldts.com [quoted text, click to view] "GregIpaper" <anonymous@discussions.microsoft.com> wrote in message news:444b01c49048$f689d650$a601280a@phx.gbl... > Not sure what components you are referring to ?? The > connection to Sql server is there, I can do deletes, just > cannot do a transfer of data from A to B. I am thinking > it's a security issue signing in thru the Intranet. > I understand when coming in thru the web the user assigned > in the application is not used (true ??). I am still not > sure what I am missing The code came straight from > www.sqldts.com website. Surely it can't be this hard, I > am just missing something, course I get not real error > message back other than Step [DTSStep_DTSDataPumpTask_1] > failed > Task "Transform Data Task: undefined" > > Thanks for your help > > > >-----Original Message----- > >....and no you don't need Excel installed on the web > server, just DTS > >components and normal MDAC which would already be there I > assume for your > >website to work at all.. > > > >-- > >Darren Green > >http://www.sqldts.com > > > >"GregIpaper" <anonymous@discussions.microsoft.com> wrote > in message > >news:375901c48f72$dec877a0$a501280a@phx.gbl... > >> I have seen many examples of ASP and DTS package, > however > >> once I try it from the web it is crashing , I am trying > >> just a simple package that moves an excel doc to a Sql > >> server table. Works thu enterprise but not thru web. > Does > >> Excel need to be installed on Web server, am I missing a > >> ODBC or ole DB driver on the server. When coming in thru > >> the web what user is it trying to use, do I need to set > up > >> a particular type of user with what permissions? I can > do > >> a delete on a table, I just can't move data from point A > >> to point B. Any help on this is greatly appreciated. > >> > >> Thanks > > > > > >. > >
Error in Object Execution
Number: -2147467259 Source: Microsoft OLE DB Provider for SQL Server Description: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. This is the error I receive when executing thru the com component. Still no luck, least on the server, it will run from my laptop windows XP iis. Just not from server. So must be a privledge thing ????? [quoted text, click to view] >-----Original Message-----
>The components I refer to are the DTS components. DTS is a set of COM DLLs >which must be installed on the machine running the package. Can you call a >COM DLL from ASP if not installed on the web server, no, so neither can you >create DTS.Package if not installed correctly. By the sound of your >description, this is not the case, as the objects are created, and the >package is loaded OK. > >By default application code called from ASP uses IWAM_MACHINENAME so does >this account have permissions to create the file? >The SQLDTS article also suggest using a COM object setup in COM+ so that you >can use an identity and abstract the permissions required for DTS away from >those used by ASP. > > >-- >Darren Green >http://www.sqldts.com > > >"GregIpaper" <anonymous@discussions.microsoft.com> wrote in message >news:444b01c49048$f689d650$a601280a@phx.gbl... >> Not sure what components you are referring to ?? The >> connection to Sql server is there, I can do deletes, just >> cannot do a transfer of data from A to B. I am thinking >> it's a security issue signing in thru the Intranet. >> I understand when coming in thru the web the user assigned >> in the application is not used (true ??). I am still not >> sure what I am missing The code came straight from >> www.sqldts.com website. Surely it can't be this hard, I >> am just missing something, course I get not real error >> message back other than Step [DTSStep_DTSDataPumpTask_1] >> failed >> Task "Transform Data Task: undefined" >> >> Thanks for your help >> >> >> >-----Original Message----- >> >....and no you don't need Excel installed on the web >> server, just DTS >> >components and normal MDAC which would already be there I >> assume for your >> >website to work at all.. >> > >> >-- >> >Darren Green >> >http://www.sqldts.com >> > >> >"GregIpaper" <anonymous@discussions.microsoft.com> wrote >> in message >> >news:375901c48f72$dec877a0$a501280a@phx.gbl... >> >> I have seen many examples of ASP and DTS package, >> however >> >> once I try it from the web it is crashing , I am trying >> >> just a simple package that moves an excel doc to a Sql >> >> server table. Works thu enterprise but not thru web. >> Does >> >> Excel need to be installed on Web server, am I missing a >> >> ODBC or ole DB driver on the server. When coming in thru >> >> the web what user is it trying to use, do I need to set >> up >> >> a particular type of user with what permissions? I can >> do >> >> a delete on a table, I just can't move data from point A >> >> to point B. Any help on this is greatly appreciated. >> >> >> >> Thanks >> > >> > >> >. >> > > > >.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |