Create Installer File With Sql Server Database Attached?
Jun 21, 2010I have a problem with attaching sql server database to an installer file.
View 1 RepliesI have a problem with attaching sql server database to an installer file.
View 1 Repliesi have this solution that i'm suppose to make an installer of, but because it calls a datebase and the database is not within the solution therefore it was not included in the installer.
and my installer cant work correctly. is there anyway i can go around doing it?
I have an application that uses a SQL Server backend. I wish to be able to create an Install project where the it can install SQL Server and/or an instance on the users machine. Has anyone ever done this before? If so, how is it done? Any examples, etc.
View 2 RepliesI'm currently developing an application for a POS Terminal using VB.net. Our project is approaching the last stage of development and I've been tasked to create 2 installers. 1 for Initial Installation, and the other for upgrade installation.
The project is composed of several elements. These are:
1. The application executable
2. Common DLLs that we developed
3. some resources (.resx and XML)
The requirement for the upgrade installer is that only those files with modification should be installed. (i.e. if only the xml or resx files are modified those are the only items that will be reinstalled, since the size of the upgrade installer is a consideration so we cannot reinstall everything).
I'm using Visual Studio 2005 for my deployment project but I'm a bit confused about how to set the properties of each file in such a way that during the upgrade, only the files that were modified would be updated and the rest of the files will not be removed since I'm setting RemovePreviousVersion property to True. I have a hunch that I need to do something with the custom action but I haven't been able to figure it out. The upgrade installer setup is almost the same as the initial installer except that all files are excluded.I tried to acquire a copy of Phil Wilson's book (The definitive guide to Windows Installer) but its not available in our local bookstore and it would take too long to order it.
Basically while tinkering with the settings/properties there are instances where the dll was not updated and there are also times when the application exe was removed.
I already verified that the Product code is the same for both installers and that I'm sure that the version number is being incremented for each upgrade.
If I will be redoing both installers from scratch, how should I go about it?
I'm also confused about the Condition property and the transitive property.
I created a DB using following code.
Dim conn As New SqlConnection("Server=.SQLExpress;Data Source=;Integrated Security=SSPI")
Dim cmd As New SqlCommand("", conn)
cmd.CommandText = "CREATE DATABASE MyDBTest22 ON ( FILENAME = 'D:dbTestATTTTTTT.mdf' ), ( FILENAME = 'D:dbTestATTTTTTT_log.ldf' ) FOR ATTACH"
[code]....
It ran without any error but when I opened SSMS, I could not see my file attached to the server. Also, I tried to make a connection, but it says file does not exist but when I tried to re-run the above code, it says File already exists.Something wrong with my way of doing it? I want to see it attached with the instance of my SQL Server Express 2005, using SSMS.
How can I create such interface/buttons as in image attached
View 8 RepliesI'm really new to any form of VB programming and I am trying to create a form which will allow me to take information from an attached database holding information on:
class names (i.e. Year6 Dragons)
Students names (i.e. Sarah Jessica Parker)
I want the design to look very similar to the form used in MS Access for the query wizard, which will allow me to choose a class and then specific students.
I have develop a wiindows application and it's done in MS Visual Studio 2008 using the VB language and it connect to a 2005 sql database. now i want to deploy my application and want it to be directly attached to my database so that when someone installs it, it comes directly with the database attached to it.
View 1 RepliesMy question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 RepliesI have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I have already connected my database and have completed multiple forms and reports.Just discovered that I missed adding ONE field in an Access table.Since it is attached how can I add a field to the database without disconnecting it? If I do disconnect it and reconnect will I have to redesign all my forms and reports?
View 1 RepliesI have a program, and i need the user to be able to install it. How would i create an installer? I have my set up and everything i just need to figure out how to pack all my files into one program, then a code for my install button.
View 15 RepliesI need to develop an application which installs applications by accepting user inputs for example; there are 5 applications (exe files ) in my hand.say
1 . msoffice package,
2. mozilla firefox,
3. acrobat reader ,
[code].....
create an SQL Server (express) database (.mdf).
most of the example in the walkthrough make use of the pre made northwind database(.mdf)
i will use the database that i will make to get connected from my application. the connection would client-server and what i have noticed, that this is possible if your database is an SQL version with extension filename of .mdf.
Or if its possible to create this database just using the Visual Studio 2008 Pro(90-day trial)
Its two programs that work together called Script Writer and Script. My problem is, I need something that will install it on other peoples machines and will be easy to install and use to make. or possibly a way to manipulate the publish option under Vb 2008 to make a setup.exe for the file that won't install it in a funky place. It also needs to install both programs in the same directory. Because Script pulls its information from output.txt which Script Writer, writes information to output.txt. I can share the Vb scripts if you like. But I'm kinda perplexed on this. I've tried installing it after publishing it, then I go to the installation folder and copy its contents, then paste them in a seperate folder on my desktop. It works on my computer but not other peoples computers. Also when publishing my program from VB 2008 it won't publish anything in my debug folder, so html.txt and output.txt doesn't get published with the setup and doesn't install when the setup is ran. So I'm having a few problems here.[url]...
View 19 RepliesI have create an application in vb.net and ms sql 2005 as database storage. How do i create an installer that can be included in a CD. What i mean is if i want to install it in the virgin PC the Installer CD would be able to run the application without an problem. Which software protect licensing installer i can use to create this.
View 3 Replieswhat is the name of the installer used to create a vb.net program?
View 1 Replieschange the .txt extension of the attached file to .rar 123.txt (595.23K)Number of downloads: 79 Its the whole Project file including a video in to illustrate the weird error! Since is almost impossible to describe the error! For all of you who will try to open the project using visual studio be sure to Import the files in the rar for model model file.txt and catalogue file.txt for catalogue
'Marios Solomou
Imports System.IO
Public Class DAC
[Code].....
I know how to display attached modules but how do i check if a file is locked by a dll.
View 1 RepliesUsing Visual Studio .NET 2008 or 2005, is there a way to automatically generate properties for each column in an SQL Server database table? I am assuming other code-generation software exists that will do this. I know with Visio I can connect to my database and it will generate diagrams by table, this would be similar to that.
View 6 RepliesI have Visual Basic 2010 Express and SQL Server 2008 R2 (not Express) installed on my Windows 7 machine. In Visual Studio, I am attempting to create a Data Connection to a database in SQL server. Server Mgmt Studio is not running. When I attempt to add a connection in Database Explorer, to the AdventureWorks _Data database, I get the message "This file is in use. Enter an new name or close the file that's open in another program." There are no programs running except VB, except maybe for the SQL Server engine running the background.Please note that I can open and access tables within a database in code
within Visual Studio, I just can't add a connection in Database Explorer.Am I doing something wrong? I've been very frustrated on this issue for a long time
I just published a new sample on the MSDN Code Gallery. This may be useful for the community here if you would like to deploy your application without an installer and still have an option to create a shortcut.
This Desktop Shortcut sample allows programmers to give consumers a way to easily create a shortcut for the application. Most installers automatically come with this feature, but some prefer to keep installers lightweight and provide the shortcut manually.[URL]..
I am trying to create an install for my application that I have just created using visual basic express. I want to be able to tell it to put files in certain locations and create my own installer. For example I want to make a license page with a read me on the installer. From what I understand the clickonce technology is what comes with express editions and you cannot do it with them. Is there an alternative to being able to accomplish what I want to do without having to purchase the full version of visual studio?
View 7 RepliesI have a finished project and I was wondering what software was available to make this into an exe with a nice profesional looking installer? I am using express.I have already had a look into cyberinstaller suite, it is ok, but generaly it is turning my half mb project into a 4.8mb project.
View 12 RepliesI already know how to call insert, update, delete & select procedures in DataSet.xsd window. And I also know how to call queries by table adapters. But I just found out that its not possible to call all functions by queries (such as insert). It works when I test the query but when I try to add it, it says "Failed to get schema for this query". So I built a few stored procedures which do many functions (such as transaction, insert, update etc...). But I am unable to use these stored procedures in VB form. I found some tutorials mentioning that it can be done by defining connections and some other stuffs with which I don't want this to be. I want to call these procedures by writing code in VB code editor window with DataSets, TableAdapters, BindingSource etc...
View 2 RepliesI am trying to connect to an attached mdf (SQL Express local) file, where i want to delete all the stored procedures. When i execute my code at executenonquery command i get the error "There is already an open DataReader associated with this Command which must be closed first.".
[Code]...
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
I was just wondering if it's possible to create an app that interacts with a database hosted on a web server... or is it only possible using VB.NET? Also if it is possible, is there any good documentation or tutorials I could reference?
View 2 Repliesi want to create an installer of my program.but i want it to be with the aid of a wizardcould somebody tell me how to create it. i dun know how to create an installer.
View 2 RepliesI want to create desktop shortcut for exe file through program. I do not want to use installer to do this. Can a piece of code in program do this?
View 1 Replies