I have been reading the below article and I have got it to work.
[URL]
The problem is when I use my database script file it throws an error 1001 saying error next to keyword 'GO'. But if i take the exact same script and run it in SQL Management Studio it works fine.
Try this small script, this is what I am using and its giving me an error, An above is a lovely article to creating a database from microsoft.
[Code]....
I am working on an ASP.NET project in Visual Studio .NET 2010 and attempting to make an MSI installer using a Web Setup Project. I added the Primary output from the project (which seems to pull in the relevant dependencies) and the Content Files from the project (which pulls in the Web.config and the .svc files).
The issue is that rather than applying the XDT transform and creating the Web.config using the Web.Release.config, it just copies the Web.config, the Web.Release.config, and the Web.Debug.config into the installer without doing any transformation at all.
How do I get it to apply the Web.config transformation before creating the installer?
I tried to install Amplifeeder today with the Web Platform Installer. When I arrived at the database setup I had to fill out some informations like "db admin user/password" and user username/password. Using SQL Express I do not have any username/password (neither admin or user). How should I be able to install applications with the WPI and SQL Express 2008 ?
Basically I had this error while trying to install in the logs: DownloadManager Error: 0 : MS Deploy exception: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'AmpliFeederDB' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Can anyone guide me to a website where I can see the list of all the keywords available in a windows installer like [TargetDir] and [ProductVersion].
Can anyone also show me a very detailed tutorial of customizing the windows installer?
We are working in healthcare domain and intergating various medical equipments with the web application.Earlier i was window forms control libray and embedd it into my html page but as it is a .net component so to run it on d client machine i had to set the CAS(code access security ) settings on the client machine and for that 1stly client should have .net framework which comes very windy for the client to download closly 350MB data and then do all the CAS stuff. This time i want to get rid from this method and want to use some other way to do this activity.
The major thing that i have to do i need to excute the 1 exe file on click of Button and then once ECG start recording on the client machine its binary file get store on d static path on client machine and after that i browse this file and save it on my server. Now, simply wanted that i should create one installer which can automatically install .net framwwork and do required CAS settings automatically. second thing is how can i upload the file lying on machine to my server. How can i do that in asp.net 3.5?
Is it possible to get the sql script for creating the database, when using Entity Framework 4.0 code first, without using the designer? When i use the designer it creates an .....edmx.sql file with the script. But i don't want to use the designer.
View 3 RepliesJust trying to download it from [URL] for the first time. Web Platform Installer says regarding "Frameworks and Runtimes" (and also "Visual Studio Tools"), "All the recommended products from this group are already installed", even though they're not. Did have something called Visual Studio Runtime Redistributable installed which is just a handful of DLL's. I uninstalled it though - made no difference. Also removed entries from registry with "Visual Studio" in them, also made no difference.
View 1 RepliesI'm attempting to create an ASP.NET/C# page that runs a PowerShell script that will run an .exe installer. The ASP.NET page is currently running in IIS 6.0 on Windows Server 2003. The PowerShell script works correctly from the PS command line but when invoked from the ASP.NET page the page just hangs. No processes are created and it appears that the server just appears to hang forever. I have successfully gotten other PowerShell scripts that run simple Cmdlets or other scripts to work from the ASP.NET page.
I've verified that the Website has script and execute permissions and that the ASP.NET page can see the script on disk. When I run the script on the command line I am an Admin user, I've checked the user in the ASP.NET page and its running as the 'NT AUTHORITYNETWORK SERVICE' user. I gave that user full permissions to execute the script but there was no change. I feel like the issue is 1. User permissions which I am still a novice on in Windows. 2. Some prompt is being given to execute the script that I am not answering, however no Windows or prompts are displayed when this is run from the ASP.NET page, (the installer is shown when running the script from the command line).
I get the following error when i try to install asp.net mvc 3 using the Web Platform Installer 3.0: "This product did not install succesfully: Downloaded file failed signature verification and may have been tampered with" The other thing I've noticed is that inside the "Application DataMicrosoftWeb Platform InstallerinstallersMVC3..." folder, the Web Platform Installer creats a "AspNetMVC3Setup.exe" file that has a size an aprox file size of 200KB. Meanwhile, at the beginign of the instalation process the Web Platform Installer informs that it will download a 20MB file.
View 1 RepliesSeemed simple. I clicked on install now, downloaded and ran the Web Installer. First, ASP.Net MVC didn't install. I have uninstalled and reinstalled everything twice without luck. The Web Installer insists ASP.NET MVC is already installed. Second, given a nice menu of CMS dbs to try, I tried Atomz, N2CMS and Umbraco. Atom won't work with the net version downloaded via this download, so why is it even included here? I could not figure out what N2CMS or Umbraco wanted in terms of user names and passwords, so those CMS's didn't install. So, what all do I really need to create a website with ASP.Net MVC? Do I need Visual Studio Express (don't we have to pay for this?). I have Win 7 64 Home Premimum.
View 4 RepliesThis is a simplified example of what I need. Imagine a person table with several different club tables. Every person can belong to any number of clubs, but must belong to at least one club. The association would be a 1 to zero or one between the person table and each of the club tables.I've created the databases, then the entity model. The associations are all 1 to many, which isn't what I want.
Is there a way to modify the database so that the model is created correctly? I'm still building the project, making lots of changes, and I've had problems with updating the model, so I keep recreating it. Setting up the database correctly would be preferable.I'm trying to follow the quickstart here: [URL]but I'm using the SQL Management Studio designer, and I can't find how to fix the associations I add.
I've been reading about using or not using foreign keys in the model, but it's only confused me more. Can someone help me understand this? I'm starting to write code with what I have, and I'm running into problems. I'm about to start using joins, which means I'm trying to use a hammer instead of a saw because I don't know how to use my saw. I'd rather understand my tools and use them the right way!
How to set up the Windows installer to launch some DLL into GAC when it is needed?
View 1 RepliesI have an add-on for a commercial ASP.NET website. My add-on requires people to merge entries into their web.config, add/overwrite existing files, and add some DLL files to the bin folder. Is there a good and safe way to create an installer than can do this with a wizard type of installation?
View 2 RepliesI have created an ASP.NET website which accesses a DB. The DB can will be alrady installed at target machine. It can be anything from SQL server 2000 to SQL server 2008. Further more the target OS can be anything from Windows server 2000 to Windows 7. I have kept the target .Net framework version as .Net 2.0 to keep matters simple. Also, the target machine can be x86 or x64 or Itanium. Do I need to create separate builds for different target platforms? How do I create an Installer which will : Put this website on a Virtual Directory of IIS server(can be any IIS version) Detect the target platform and install the appropriate build. I need to do this either using the standard MSI installer of VS2008 or using WiX or any open source installer for that matter.
View 1 RepliesMy company has built a web application using ASP.NET MVC and SQL Server 2008 which also requires some other custom windows components that we built to be installed. What we would like to do is create an installer package that will automate as much as possible to make deployment easier at customer sites. Some of the tasks we are looking to do is: install .net 4, IIS, sql server, setup IIS, deploy web application, configure web.conifg, deploydatabse, and install custom windows services. We are using VS 2010 and the installer has to work on IIS 6 and up. Having never done something like this before, does anyone have any insight and/or where could I look to start finding answers on how to go about this process?
View 2 RepliesI need to implement a web site installer for my asp.net application. The installer will be handling following features - Deploy the .net web application on to the IIS server Setting up the Sql database connection to run the DB scripts. Execute all the DB scripts. Run another exe for the license management. If some thing goes wrong, need to rollback everything. I have heard about wix and install shield and wondering what would be the best technology suitable for this particular case.
View 2 RepliesCan not download anything from Microsoft download, asp .net 4, sharepoint services 3.0, SQL server Express 8.0 and services pack
View 2 RepliesI am getting the error: The installer was interrupted before the application could be installed you need to restart the installer to try againI am having a asp.net 3.5 project created in VS2010...and selected the target as .net framework 3.5....still when i try to run the MSI it gives the above error..
=== Verbose logging started: 7/9/2010 9:27:47 Build type: SHIP UNICODE 4.05.6002.00 Calling process: C:Windowssystem32msiexec.exe ===
MSI (c) (C4:40) [09:27:47:116]: Resetting cached policy values
MSI (c) (C4:40) [09:27:47:116]: Machine policy value 'Debug' is 0
MSI (c) (C4:40) [09:27:47:116]: ******* RunEngine:
[code]...
I am using WCF, now can somebody guide me how to make installer to install the services in IIS??? i don't wan to do manually.
View 1 Replieshow I can create a Database in SQL Express, then add tables and columns .. etc to the Database.
On PHP & MySQL I use to go into PhpMyAdmin and do that all there ! However with SQL Server Express and Visual Studio 2010. how to do it.
i got an requirement where in the user submits the database scripts,stored procedures ,triggers ,functions or packages.i have create those in the database .if it throws an error it must be roll backed.how can i achieve this.
View 7 RepliesI know how to create an rss feed using xml, but not sure how to with my access database. Can anyone tell me how?
View 1 RepliesI wanted to use the "create database query" from my ASP.Net page, say "install.aspx". So that when the page is run, it works as an automated tool to create database and tables required for the application.
1. What should be the connection string (if any)?
2. What functions are to be used?
I am working in asp.net application and need to download an installer package from the webserver to the client machine.My installer would contain..
1.Drivers(i.e exe file) for one hardware machine.[IT shouuld automatically run and install in the program file]
2.I have to register MSCOMM32.ocx.Its entry would go into the registry.(like manually we do Regsvr32 path of OCX to register it)
And, I want that above both should done within a single installer package.
But,how to do these things within .Net applications.
I have a large Web Application ( ErPwith 11 subsystem) and I want tocreate a setup for itwith Microsoft WebPI. Currently We send our application for customers once a week (for weekly updates). We usefollowing tools in this application, So How to create a setup for out project toconfigure it in client IIS automatically
List item
.netFramework 3.5
SQL server 2008
Asp.net
C#
NHibernate
Log4net
castleProxy
SQL Server Reporting Services (RDL)
Visual Studio Client Reports (RDLC)
Javascript
JQuery