The most basic SQL Server questions....

ljh

(sorry if this posts twice....I waited several hours and didn;t see it - so
here it is again.....)

Perhaps I am somewhat dense.....but, I still need to know.....

What do you need to do in order to ship a SQL server Express or Developer
edition database with your Visual Studio .Net 2005 application?

Does SQL Server Express need to be installed on the target machines? Or,
can the database file be used as a stand-along databse (like an Access
database)?

Books on SQL Express and VS 2005 Database programming abound (I have 4 of
them) - but these simple ehings do not seem to be covered.

May 30 '06 #1

Subscribe Reply

1199

Kerry Moorman

ljh,

The SQL Server data files, .mdf and .ldf files, cannot be used in a
standalone way, unlike Access .mdb files.

Your application must access these files attached to a running SQL Server.

Either SQL Server must be installed and running on the target pc, or the
target pc must be able to gain access to a running SQL Server via a network,
etc.

Kerry Moorman
"ljh" wrote:

(sorry if this posts twice....I waited several hours and didn;t see it - so
here it is again.....)

Perhaps I am somewhat dense.....but, I still need to know.....

What do you need to do in order to ship a SQL server Express or Developer
edition database with your Visual Studio .Net 2005 application?

Does SQL Server Express need to be installed on the target machines? Or,
can the database file be used as a stand-along databse (like an Access
database)?

Books on SQL Express and VS 2005 Database programming abound (I have 4 of
them) - but these simple ehings do not seem to be covered.

May 30 '06 #2

Norman Yuan

You cannot ship SQL Server Developer Edition with your application to users.

Yes, you must have SQL Server Express installed. Then you need to create the
database your application requires on the SQL Server Express. You can either
wirte SQL script to create it, or ship the database file (*.mdf/*.ldf files)
to the user and and attach the database files to SQL Server Express. With
SQL Server Express, you can also use "User Instance". In this case, you can
use code to attach database files to SQL Server Express dynamically. To
user, it seems, as if your app is only work with database file.

You can make your app intallation package to handle SQL Server Express setup
(quite complicated). I'd prefer install SQL Server Express seperately.

"ljh" <So**@where.els e> wrote in message
news:q%******** **********@bign ews8.bellsouth. net...

(sorry if this posts twice....I waited several hours and didn;t see it -
so here it is again.....)

Perhaps I am somewhat dense.....but, I still need to know.....

What do you need to do in order to ship a SQL server Express or Developer
edition database with your Visual Studio .Net 2005 application?

Does SQL Server Express need to be installed on the target machines? Or,
can the database file be used as a stand-along databse (like an Access
database)?

Books on SQL Express and VS 2005 Database programming abound (I have 4 of
them) - but these simple ehings do not seem to be covered.

May 30 '06 #3

newscorrespondent

Express must be installed.
The setup you generate with VS2005 can detect and install it if necessary.

May 30 '06 #4

Similar topics

9277

HTTP - basic authentication example.

by: Michael Foord | last post by:

#!/usr/bin/python -u # 15-09-04 # v1.0.0 # auth_example.py # A simple script manually demonstrating basic authentication. # Copyright Michael Foord # Free to use, modify and relicense. # No warranty express or implied for the accuracy, fitness to purpose

Python

1721

Basic questions re threads and cleaning up

by: asfwa | last post by:

I'm new to C++ and I have some basic questions. I have written an app that does some network stuff in a worker thread. The thread function requests something from the server, gets it and creates an object from the server response. Does this thread terminate/stop/die as soon as it completes its last line of code? Or do I have to do something to kill it? I am used to coding Java so I am totally unsure of what I have to do to "clean up"...

C / C++

1273

3 basic questions on asp.net

by: Wiktor Zychla | last post by:

Hello, I am an experienced Win.Forms developer and now I am learning ASP.NET (no ASP background). there are some basic issues I do not understand and cannot find any satisfable answers. 1. my application is configured to use Welcome.aspx as the default page. after the succesful login via Forms authentication (user is redirected to login.aspx) I try to reset the authentication via

ASP.NET

1534

Very Basic VB.Dotnet Deployment Conceptual Questions

by: Andy | last post by:

Hey All, I'm a beginner with VB.Dotnet Deployment and I'm a little confused about some very basic deployment issues . . . I've now created some core assemblies that will be used throughout all of our applications that run on various machines on our local network. I understand that the global assembly cache exists on each machine where the CLR is installed. But don't I want to establish just one global assembly cache on say one of our...

Visual Basic .NET

1463

Basic Database Questions

by: Miro | last post by:

Ok im a newbie to VB, and am having some trouble reading msdn help / or how it all links together. My books are either missing a step / or assume everything is set up correctly. I know about tables and keys but i just cant seem to find a "starting point" in VB.net. 1. Where do I go create a db if i only installed vb.net ? / What do I use 2. Or is there a good tutorial somewhere of what to do. I have 3 books and

Visual Basic .NET

4745

Basic Questions

by: BJMurphy | last post by:

Hi All, I am used to other SQL engines, and have a few basic questions-- 1)If I wanted to conditionally drop a table, does SQL Server have a way to natively do this? Many SQL implementations will allow something like: CREATE OR REPLACE tablename AS SELECT

Microsoft SQL Server

3091

Experience of converting VB6 applications to Visual Basic.net

by: Chris Asaipillai | last post by:

Hi there My compay has a number of Visual Basic 6 applications which are front endeed onto either SQL Server or Microsoft Access databases. Now we are in process of planning to re-write these applications into Visual Basic.Net. My managers main thought is that Visual Basic 6 is (or has!) stopped being supported by Microsoft.

.NET Framework

1520

Basic Mutlithreading Questions

by: JJ | last post by:

I've done a little multi-threading on winform apps some time ago now, so I'm not a complete beginner, but best assume I am for any explanations..: This is an asp.net 2.0 website, using c#: I have a thread whose job is to send several emails (i.e. a long task that mustn't be run by more that one user at a time). It all works fine, but I am concerned about the lifetime of a thread in the case of smtp errors, and how it will work with...

ASP.NET

3574

Converting from an ancient BASIC to new database

by: Randy Reimers | last post by:

(Hope I'm posting this correctly, otherwise - sorry!, don't know what else to do) I wrote a set of programs "many" years ago, running in a type of basic, called "Thoroughbred Basic", a type of business basic. I need to re-write it, bring it kicking and screaming to run on Windows XP. This is for a video rental place, tracks movie and game rentals, customers, employee transactions, reservations, does reports,..... and on. I know some of...

Visual Basic .NET

2509

C# Basic Authentication when redirecting

by: =?Utf-8?B?SGVybWFu?= | last post by:

My environment is as follows: IIS 6.0, Asp.Net 2.0, Windows 2003 Server. I am trying to create a single sign on SSO environment with C# and log into a site that is running Apache Server using basic authentication. Questions: 1. How do I display the response in a new window?

C# / C Sharp

8448

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8871

Problem With Comparison Operator <=> in G++

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...

C / C++

8783

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

8552

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7387

AI Job Threat for Devs

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...

Career Advice

4198

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4369

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2773

transfer the data from one system to another through ip address

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

C# / C Sharp

2011

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP