VB 2008 Express App install wants to install unnecessary components
-
Hi folks, I have created an app which takes a SQL table from a SQL 2005 server (separate from the machine running the application) queries it in some nice ways and generates an Excel spreadsheet with the required data. The problem I have is that when I publish the App and get another machine to install it using the "setup" file created, it wants to download and install: .Net Framwork 3.5 SQL 2008 Express edition Both take ages to download and install and I don't see why the SQL Express is required. Can I stop this process from happening as part of the install. Are they BOTH necessary?? Just to point out, AFAIK there is definitely no requirement for SQL 2008 Express to be installed on the client, the app just uses a connection string to connect to the remote database and queries are passed as strings.. Thanks
-
Hi folks, I have created an app which takes a SQL table from a SQL 2005 server (separate from the machine running the application) queries it in some nice ways and generates an Excel spreadsheet with the required data. The problem I have is that when I publish the App and get another machine to install it using the "setup" file created, it wants to download and install: .Net Framwork 3.5 SQL 2008 Express edition Both take ages to download and install and I don't see why the SQL Express is required. Can I stop this process from happening as part of the install. Are they BOTH necessary?? Just to point out, AFAIK there is definitely no requirement for SQL 2008 Express to be installed on the client, the app just uses a connection string to connect to the remote database and queries are passed as strings.. Thanks
So, what did you do to create the installer??
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
So, what did you do to create the installer??
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...Morning.... I didn't do anything... You click on Builds, then Publish.. You select a path and then whether the clients will want automatic updates and then that it... The setup files appear in the designated folder, the client runs them and then get prompted to install .Net 3.5 and SQL Express 2008.... Are these components defined in the code somewhere, or when the build is completed?? As it doesn't appear obvious. As a side note, the application was designed and tested using connections to SQL Express (Locally installed), but then the connection strings were changed to use SQL 2005 (full vers)
-
Morning.... I didn't do anything... You click on Builds, then Publish.. You select a path and then whether the clients will want automatic updates and then that it... The setup files appear in the designated folder, the client runs them and then get prompted to install .Net 3.5 and SQL Express 2008.... Are these components defined in the code somewhere, or when the build is completed?? As it doesn't appear obvious. As a side note, the application was designed and tested using connections to SQL Express (Locally installed), but then the connection strings were changed to use SQL 2005 (full vers)
nhsal69 wrote:
then Publish.. You select a path and then whether the clients will want automatic updates
That's what I thought. VS Express is coming up with the dependanies itself. I don't use the Express Editions, but in the full versions you can open the Project Properties dialog and there is a Publish tab in there. Clicking on that, you get a page that lists a bunch of information about how the project is, obviously, published, with a button labeled Prerequisits. Clicking on that button, you get a dialog that lists a of items that the installation will depend on being installed. On mine, I can just clear the dependancies I don't need, close the dialogs and re-publish the app.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009... -
nhsal69 wrote:
then Publish.. You select a path and then whether the clients will want automatic updates
That's what I thought. VS Express is coming up with the dependanies itself. I don't use the Express Editions, but in the full versions you can open the Project Properties dialog and there is a Publish tab in there. Clicking on that, you get a page that lists a bunch of information about how the project is, obviously, published, with a button labeled Prerequisits. Clicking on that button, you get a dialog that lists a of items that the installation will depend on being installed. On mine, I can just clear the dependancies I don't need, close the dialogs and re-publish the app.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...It's resolved now... I copied the entire Form1.vb and form1design.vb etc to notepad, created a new project and then pasted the code back into the new project.. This appears to have resolved the problem, I'm guessing that there must have been some residual "reference" somewhere which forced VB Express to require the above a pre-req, even tho they weren't utilised in the code... thanks for you thoughts anyway...