Deployment Problem 1

[jgsteeldev]

I have a problem. I created a small ASP .Net appliction for our developers. The application allows the developer to select a database and or table that exists on our production and Beta SQL servers and refreshes the Beta Version with the Production Data. The aplpication creates and runs DTS packages on the Beta server that pull the data from the Productionsever. In order to use the DTS object i had to create aRCW for it. I created the sn key and the RCW on my local machine and put the resulting .dll file in the GAC. The application works beautifully when running on my localhost server on my machine. So, I need to copy the application to the company's webserver. I created a folder on the webserver. the network admin created a new website. I chose to copey the project to the folder on the webserver. I selected copy files that are needed to run application. When I try and run the site from the webserver I get af far as clicking the button to refresh the data. Then I got an error.

File or assembly name Microsoft.SqlServer.DTSPkg80, or one of its dependencies, was not found.
File name: "Microsoft.SqlServer.DTSPkg80"

I copied the dll to the bin folder on the webserver.

Then i tried again and got a new error.

System.Runtime.InteropServices.COMException (0x80040154): COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

Can anybody help me from here. I have just about googled myself out. Is there a step I am missing. Every thing I have read say "the beauty of ASP.Net is that you don't have to registeer your dlls. Just slap them inthe bin folder. That is not working. help me please.

Note: SQL SERVER and Visual Studio .Net 2003 are not installed on the web server.

Here we go Royals! Here we go!!!!!

 

[ca8msm]

My guess is that there are DLL's from the SQL Server setup package that are used to run your DTS scripts. Try installing SQL Server (the client version should be fine I think) and see if that helps.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[jgsteeldev]

Thanks ca8msm,

I believe this is not the first time you have helped me out. I have been thinking the same thing. install SQL server. I am trying to get the admin to do that. I have msde on my machine so He should be able to put it on the web server and get the program to work.


Thanks again!

Here we go Royals! Here we go!!!!!

 

[ca8msm]

No problem. Let us know if it doesn't work though but I have a feeling it will.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[jgsteeldev]

Just so every body knows SQL server was installed on the web server and I used xcopy to re-copy the application over. Now it works just fine. So, Note to self: if you are going to use a com object in your application make sure it is registerd on the web server!

You are the man ca8msm!!!!

Here we go Royals! Here we go!!!!!

 

[bensonthomas]

'ca8msm' is correct about requiring DLL's from the SQL Server setup package that are used to run your DTS scripts, but installing the installing SQL Server (or the client version) is normally not required. However installing it would make it run. The DTS runtime dll's needs to be registered for SQLServer. The list of dlls required for registration are located in the URL

http://www.sqldts.com/default.aspx?225

This should solve the problem.

 

[bensonthomas]

The list of dll's are sqlresld.dll, dtsffile.dll, dtspkg.dll, dtspump.dll, axscphst.dll, dtsffile.rll, dtspkg.rll, dtspump.rll, axscphst.rll. Register the 4 dll's along with all the required files. The Interop dll ' Microsoft.SqlServer.DTSPkg80.dll' will be requiring these files.

All the best..