How to include SQL 200X Express with VB app.

MS SQL SERVER

    Sponsored Links

    Next

  • 1. SQL Server 2000 Agent and Node Connection in Active/Passive Cluste
    Are there any known failover problems using SQL Server Authentication instead of Windows Authentication for the SQL Server 2000 AGENT in active/passive cluster environments? Also, are there any known failover problems at the instance level using SQL Server Authentication instead of Windows Authentication?
  • 2. MSSQL 2005 in workgroup (p2p) connecting thru WinNT Integrated Security
    Hi. I've installed MSSQL 2005 in a PC which is part of a workgroup. From that PC, I can connect to the database via WinNT Integrated Security. Now, does anyone know how or if its possible to connect to this database server from another PC (member of the workgroup) via WinNT Integrated Security? Currently, I can connect by specifying the SA User ID and password. Any idea? Thanks,
  • 3. SQL 2005 language always US English
    Hi, I have just installed SQL Server 2005 Developer Edition on our development server, but under the properties, it says "Language (United States)". How can I change this setting? I am in the UK and I wish it to have United Kingdom defaults. We have had this problem in the past and we even have some software which physically won't install if the SQL Server locale does not match the operating system locale. Can somebody please explain where this option is configured in SQL 2005. Also, is it possible to install SQL Server Management Studio on my workstation? I installed the client utilities but it only seemed to install SQL Server Configuration Manager. Thanks, Nick...
  • 4. side by side migration sql 2000 to sql 2005
    I am considering doing a side by side migration by installing a named instance of SQL 2005 on the same physical server, and then migrating my databases and analysis services to the new named instance. My question is: If I do this and then when all is working, delect the 2000 server, is there a way to make my "named instance" the default instance for the server? I have an accounting package that states that it can only use the default and not a named instance. Thank you in advance for your assistance.
  • 5. SQL Server Express 2005 leaves out file in installation process
    I've tried several times to install SQL Server Express 2005, but each time the enterprise manager file is left out/not installed. Is there a way I can install this file manually? At the moment I can find it but not access it (DOS and binaries are beyond my knowledge). What should I do? Download everything from the beginning and try again? Is there any additional software I need besides .NET framework 2.0? Is there any of my current software that might interefere with the program? (have un-installed all other database software). Please help, because as far as I've understood, SQL Server Express is pretty useless without the enterprise manager and I desperately need to get this working. /Sofia

How to include SQL 200X Express with VB app.

Postby The Ricster » Sun, 29 Mar 2009 06:08:29 GMT

Hi all, I have searched everywhere for instructions on how to use sql
2005 (or 2008) express as the database for a multi-user app (built in
VB6), that currently uses an access db.

Here is the complete scenario: I need to install sql (w\ a custom .mdf
file) along with the Server version of my program, and have access to
the data over a lan, by the client versions of my program. No special
sql commands or functions are needed, the db will be used in the
simplest way, and passed sql commands via ado.

I would also like to make the installation as seamless as possible, with
the db being installed automatically by the application setup program
(Wise or PDW).

Does anyone know where to find a simple walkthrough explanation of how
this can be done, or can someone provide me with the steps to:
     1. Install the sql engine.
     2. Connect the custom db file to sql.
     3. Enable TCP/IP or Named pipes for lan communication.
     4. Do all this without user intervention.

any help would be greatly appreciated. 

The Ricster

*** Sent via Developersdex  http://www.**--****.com/  ***

Re: How to include SQL 200X Express with VB app.

Postby Richard Mueller [MVP] » Sun, 29 Mar 2009 07:39:26 GMT

"The Ricster" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...

You can download the setup program sqlexpr.exe for SQL Server 2005 Express
from the Microsoft site. Command line parameters are documented here:

http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx

There is a similar document for SQL Server 2008 Express. There are switches
for quiet install, to specify your instance name, and to enable TCP/IP
and/or Named Pipes. Note the requirements are not trivial: .NET Framework
2.0, MDAC 2.8, Windows Installer 3.1. See this link:

http://msdn.microsoft.com/en-us/library/ms143506(SQL.90).aspx

You must copy your mdf and ldf files to the local system and then run the
T-SQL statement to attach the database to your instance. In the past I found
that I must start the instance before the attach, as it seems to be stopped
after the SQL Server setup. I simply run the command "net start
mssql$myinstance".

When I used MSDE I tried to install both MSDE and my database in one setup
program (using InstallShield), using a merge module, but soon found that was
a big mistake. First, MSDE was not recognized by Windows Update so it was
not updated with security patches and SP's. Also, when I later tried to
upgrade the database (using InstallShield) I found that the first step is to
Remove, then install the new version. This blew the database away. I decided
the only solution was to have the customer run two setup programs, one for
MSDE and the other for the database. The later setup program deployed server
utilities, started the instance, and attached the database (using
InstallShield custom actions). So far I have decided that the same applies
to SQL Server 2005/2008 Express; I need one setup for the SQL Server Express
instance and another to deploy and attach the database. Note that .NET
Framework 2.0 must be installed before SQL Server Express. I believe newer
versions of InstallShield can handle this (I need to upgrade my
InstallShield once again, as seems necessary every year). Otherwise, you
must instruct your customers to install the Framework before running
sqpexpr.exe, if they don't have 2.0 (or higher) already.

If anyone else knows of any easier method, I'd like to hear it as well. I
decided that coding my own VB app to deploy SQL Server Express would be way
too complicated. Asking my customers to run the setup themselves would only
be reasonable if they install on a new OS, like Vista or Windows Server
2008. I don't want to no longer support Windows Server 2003, XP, (or even
2000).

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--



Re: How to include SQL 200X Express with VB app.

Postby Sm9obg » Wed, 01 Apr 2009 03:45:01 GMT

We've been successfully installing/deploying SQL EE 2005 along with our VB6 
app for a couple of years.  Our CD starts a Demoshield intro, which drops 
down to a CMD batch file to do the following:

ECHO  This Full_Install.bat Batch file will install the following:
ECHO       1. Dot Net Framework 20
ECHO       2. SQL Server 2005 Express Edition
ECHO       3. SQL 2005 Express Management Studio
ECHO       4. [our app] SQL Database
ECHO       5.  [our app]  Client Application

1.  Many PCs already have .Net 2.0 or newer, so enduser may need to plow 
thru this as needed.   

2.  Right from the comand line:  start /wait setup.exe /qb 
INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SQLAUTOSTART=1 SECURITYMODE=SQL 
SAPWD=SomePassword DISABLENETWORKPROTOCOLS=0

3.  Not essential, but nice to have if needed.

4.  We script everything.  
SQLCMD -S %COMPUTERNAME% -U sa -P SomePassword -b -i 
CreateOurAppDatabase.sql -i Tables.sql -i Procedures.sql -i Triggers.sql -i 
Data.sql -i CreateOurAppUser.sql

This has worked nearly flawlessly for us for most clients.   At least up 
until the recently introduced conflicts by Microsoft XML 6.0 SP2 and 200x 
Setups, which is a big problem for us, and poorly documented in 
 http://www.**--****.com/ 



Similar Threads:

1.Confusion: VB Express/VC Express/Sql Server Express Edition

2.Installing a database in SQL Express during VB app setup

Hi,
I have a vb.net application that uses a SQL Express database.

The end user already has SQL Express setup on there server, but they have no 
skills at using it.

Is there a way I can have my VB.net Setup program install the database onto 
this server? Executing a massive SQL Script I guess would work, or perhaps 
just restoring a backup of the database would work as well.

Also happy to do a dedicated SQL setup program if this is the best option.


3.connect vb app to sql 2005 express

I'm pretty new to both sql 2005 and VB but please bear with me. I have
installed SQL 2005 express on a Windows 2003 Standard server. I have
also installed VB 2005 Express edition on the server. SQL seems to be
running fine (I can create databases, tables, modify them, etc.) I have

created a very basic app in VB express that just lets me view and
modify the current tables. It works just fine on the server. However, I

am trying to make this app connect from an XP pro machine on the
network and I really don't know where to start. I tried running the app

that works locally over the network and I get "error 26" can't connect
to database server. I've read about using strings and ADO but I'm not
familiar enough with VB to make it work. Also, both machines are on the

same network and I can connect to the server from the XP pro machine
with SQL server management studio express.

Any help is greatly appreciated. 
Thanks, 
Josh

4.installing SQL 2008 express and database with my vb app

Hi

I have built a application in vb.net pro 2008 that uses a SQL express
database

I have been able to create an installation application project that
installs the application perfect, but I am having to manually setup SQL
express and my database 

I have had a look on the web with no luck, but would like to be able to
have my application instalation also install the SQL express product as
well as my database 

Is this possible and where can I find a guide on how to do this ...

Thanks

5.VB 2005 express not saving data to sql express

hello. I can enter in data in the vb program itself and it will save
data there but when i run my program and enter data it will not save
the changes to the database. Any ideas on how to get my program to use
to commit the data. I used the built in code generator to get a link to
the database, i do not get any errors when i click on the save button.

6. VB Express SQL Express Remote Connection

7. Can't connect to SQL Express using VB.NET express

8. 26 - Error Locating Server - VB Express to SQL 2005 Express



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 82 guest