473,804 Members | 3,804 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

deplying vb.net with SQLExpress database

2 New Member
Hello,

How do you deploy a vb.net application with a SQL express database?

My vb.net programming book offers a single paragraph that amounts to "Select publish, choose options in wizard, job done". LOL

So I gave it a try and everything seemed ok until I tried to run the program. It errored with many references to SQL... So the deployment wizard isn't smart enough to realise your application has database requirements. Strange that as all the information is sitting their in the app.config xml file. Makes you wonder why they bother exposing all this information if their own wizard can't be bothered to pick it up.

I try the wizard again and make a concerted effort to find the bit where it asks for database information. But it doesn't. I am convinced I must be missing something obvious so if anyone can point me to where or how I get the database added to the deployment I would be grateful.

Fininding the installation directory

After using the setup.exe produced by the wizard I tried to find the setup directory so I could dump a copy of the MDF and be done with it.

Does anyone know where it goes? It wasn't in Program Files, not off the root. I did a search for the exe name across the entire disk and never found it. I opened the shortcut it created but there was a long string which vaguely resembled the name of the exe repeated a few times.

Performing a manual deplyment

If however the wizard is as I suspect, a waste of time then there are a few things I need to get done manually and I wondered if anyone knew of an article that would cover the following:

1. The installation program will need to ask the location of the MDF so that it can build the connection string.

2. The connection string is going to have to be saved somewhere.

3. The program is going to have to check that some form of SQL is running and if not SQLExpress will then need to copy the contents of the MDF up to the running server (the application includes data).

Wow. VB used to be so easy, I must be getting old...

Thanks,
Lex.
Jan 21 '07 #1
1 2049
kenobewan
4,871 Recognized Expert Specialist
You are using SQL Server Express with Visual Web Developer to publish the site? There is a free utility that would help you create a mdf:
Cool SQL Server and SQL Express Command-Line Utility

However, this article may be more helpful in resolving your problem:
Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)

Hope that this helps.
Jan 21 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2059
by: Borek | last post by:
Hello, I am getting the beforementioned error when trying to populate DataSet object with data taken from SQL2k database. Then I want to bind DataSet to GridView control. But when I use SqlDataSource object to bind data from the same database to the GridView everything is ok (using the same connection string and SqlClient provider). And on top of that I don't know why does this error refer to SQLExpress??? And it wants to create an mdf...
3
1603
by: andrewcw | last post by:
I am trying to use the NorthWind database or anything with SQLEXPRESS on VS 2005 RC. I can see SQLExpress started with the tool SQL Server Configuration Manager. But when i select DataBase | New Connection | Data Source | Microsoft SQL Server - I see other SQL servers but not SQLExpress. What should I be doing... Thanks -- Andrew
1
1055
by: VB Programmer | last post by:
I have created an ASP.NET 2.0 site and just published it to my webserver. None of the database stuff works, including membership, etc.... because my hosting company (webhost4life) claims that they do not support SQLExpress, just SQLServer 2005. 1. How difficult is it to migrate over to SQLServer 2005 OR MS Access as my database? 2. Will the new .NET membership classes, profile classes, etc... still work if I switch to a SQLServer 2005...
2
1879
by: Crash | last post by:
Windows XP MS SQLExpress VS 2003 ..NET 1.x SP1 {for Application} ..NET 2.0 {for SQLExpress} MS Enterprise Library June 2005 This works from a command prompt osql -E -S localhost\SQLEXPRESS
13
2449
by: Matt Fielder | last post by:
First off, if this is better posted in another group that qualifies as a manged group, please let me know. I currently have an application written in VB.Net using MSDE as the database. Current install is via InstallShield. As I've just found out that MSDE is not supported under Vista, I need to migrate to SQLExpress. I am also potentially interested in migrating to using an installer built in Visual Studio. I have a few questions:
2
1343
by: Michel Vanderbeke | last post by:
Hello, I have a program, running in several places, using SQLEXPRESS as database. The different places are stand-alone, and not connected to a network. Regulary, I have to apply changes on certain tables of the database. In a previous program, written in VB6 with an Access database, I used JRO through VB6-code to delete the table in the different databases and to copy the new one.
5
2683
by: =?Utf-8?B?bXVzb3NkZXY=?= | last post by:
Hi, I wonder if someone could shed some light on this one for me. I have developed a web app in VS2005 with the built in server. It uses an sql database, everytihng works. I need to test it across the network, so i've installed IIS7 on my Vista machine and created a new website, point at the website's directory. After I switched to the 'Classic .net' app pool, it shows up on the port.
1
366
by: Daniel | last post by:
i seem to be having memory issues, will deplying a release build instead of a debug build help with memory usage of my .net process?
1
8193
by: Aykut Canturk | last post by:
Can I use SqlExpress2005 AttachDatabase feature with classic ADO connections in my .asp pages ? But I need ConnectionString. Although I searched the web for couple of weeks I still coulnd't find any solution. anybody succeeded to use classic ado with attach feature without attaching database filed from enterprise manager ? I want tou use SQL2005 and I don't want directly attch files to sql. Best regards...
0
9576
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10567
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10323
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10074
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9138
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6847
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4291
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3809
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2983
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.