473,382 Members | 1,426 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

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
3 1182
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
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.else> wrote in message
news:q%******************@bignews8.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
Express must be installed.
The setup you generate with VS2005 can detect and install it if necessary.
May 30 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
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. #...
7
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...
1
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...
0
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...
3
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...
6
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...
4
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...
3
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...
28
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...
0
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.