473,890 Members | 1,370 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Why choose SQL Express over Access?

ljh
Why would you choose SQL Express (which requires an installed application to
work) over the simplicity of an Access database which has no dependencies?

May 30 '06
74 3818
ljh wrote:
Why would you choose SQL Express (which requires an installed
application to work) over the simplicity of an Access database which
has no dependencies?


If you already know the answer, why ask the question?

Furthermore, MS doesn't include the JET engine anymore in the MDAC
installations (if I'm not mistaken), something to consider in your
decision. (which means effectively, that they want to keep people from
using .mdb files as a database for an application which isn't build in
MS Access, as the JET engine is only distributed with Office today (if
I'm not mistaken).

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Jun 1 '06 #51
Hi Sahil,
The only advantage Access gives you is "File based deployment".


You still have to install jet engine though (dll hell, registry, com, you
name it)...
Or did you mean FBD for database files?

BTW, i liked the pig anecdote :-)

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
Jun 1 '06 #52
ljh
I'm not so sure about that.

Isn't the MDAC just a related set of DLLs? In many cases, you can simply
place dependent DLLs in the same directory as your exe and all will run just
fine - no registering amything and no chance that "DLL Hell" (which I don't
believe exists) can getcha.

I may try this out myself on a clean box and see......

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e8******** ******@TK2MSFTN GP04.phx.gbl...
Hi Sahil,
The only advantage Access gives you is "File based deployment".


You still have to install jet engine though (dll hell, registry, com, you
name it)...
Or did you mean FBD for database files?

BTW, i liked the pig anecdote :-)

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Jun 1 '06 #53
pig anecdote?

Re: the jet engine etc. - yeah but most machines have it.

- Sahil Malik
http://www.winsmarts.com
http://blah.winsmarts.com

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e8******** ******@TK2MSFTN GP04.phx.gbl...
Hi Sahil,
The only advantage Access gives you is "File based deployment".


You still have to install jet engine though (dll hell, registry, com, you
name it)...
Or did you mean FBD for database files?

BTW, i liked the pig anecdote :-)

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Jun 1 '06 #54
The latest version of the SQLite ADO.NET 2.0 Provider is 1.0.29.0. I must
really be doing something wrong if nobody knows about it. Maybe I need to
hire a PR guy :)

The SQLite ADO.NET 2.0 provider's VS2005 integration is pretty good (and
better than most other 3rd party databases that integrate into VS2005 -- and
the only one I know of outside MS that lets you design for the Compact
Framework), but its still incomplete. I am working on implementing all the
editors to enable you to actually design tables, indexes, keys, views etc.

Here's a movie I did demo'ing the VS2005 design-time support in the 2.0
provider for SQLite. It's based on a much older version of the program, so
isn't quite as fancy as it is now:

http://sqlite.phxsoftware.com/sqlite.wmv

And do yourself a favor -- hit the main website and read the forums! I have
lots of how-to's, and have a pretty good track record for answering
questions there :)

http://sqlite.phxsoftware.com

Robert Simpson
Programmer at Large


"ljh" <So**@where.els e> wrote in message
news:7e******** ***********@big news3.bellsouth .net...
I was looking at the site () and came across "Version 1.0.14 of the SQLite
.Net Data Provider for ADO.NET 2.0/VS 2005 is out and includes design-time
support. You can now create databases, design queries, and drag-and-drop
tables to create typed datasets within Visual Studio 2005. "

Is this capability still in there? I didn't see any examples of this. If
SQLite is as easy to use as this quote seems to make it (i.e. as easy to
use in the ide as SQL Express) we may just have a winner here.
"JimD" <Ji*@keeliegirl .dyndns.org> wrote in message
news:yu******** *********@torna do.tampabay.rr. com...
JimD wrote:

<snip>

I forgot to mention about the connection string in the example. The
connection string is:

Data Source=database .db;Version=3;N ew=True;Compres s=True;

The New=True token says to create a new database. So every time you run
the test program, you are creating a new database, overwriting the old.
You probably don't want to do that with a real application. So you
would only use the New=True in a connection string when you want to
create a database for the first time. After that, you can either remove
New=True or change it to New=False.
Jim
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
There's no place like 127.0.0.1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
JimD
Central FL, USA, Earth, Sol


Jun 1 '06 #55

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
pig anecdote?
"Bill, it took me a while to realize this, but I think you're wrestling with
a pig. He is enjoying it, and you're getting dirty. "
Re: the jet engine etc. - yeah but most machines have it.


It is enough if one (target) machine might be missing jet. :-)

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
Jun 1 '06 #56
ljh
I think that what you have done thus far is fantastic. Something I probably
never will accomplish myself.

My problem is one of time constraints. I am not a DBA, don't want to be
one. I have to look after 15 small business networks and am embarking on
writing 3 applications and volunteering some time at a local center for
mentally challenged adults. Thats a lot of juggling to do every day.

The ease in which you can add a table in SQL\e (i.e. right click the db and
select Add Table - name it and start doing almost the same thing with the
columns) lends itself more to RAD development (and the juggling that I have
to do) than having to type in the create statements for each table.

I know it sounds minor, but for me it isn't. 2 of the 3 apps have no clear
documentation. Primarily becasue the client wants to develop something "as
we go along". So, (in this particular level of programming hell) the more
RAD the better.

I just like the idea of right click and add. It enables my bad coding
practices....bu t it keeps the clients happy - esp during prototyping.

Does that make designing an app while you code it a good example to follow?
Certainly not! It is atrocious. But, it is my task for one of my larger
clients.

The small size of SQLite is amazing. And the ease of deployment is a dream
come true.

I'll keep playing with it and see what I can come up with......

Thanks for all of your hard work!

ljh

"Robert Simpson" <rm*******@noem ail.noemail> wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
The latest version of the SQLite ADO.NET 2.0 Provider is 1.0.29.0. I must
really be doing something wrong if nobody knows about it. Maybe I need to
hire a PR guy :)

The SQLite ADO.NET 2.0 provider's VS2005 integration is pretty good (and
better than most other 3rd party databases that integrate into VS2005 --
and the only one I know of outside MS that lets you design for the Compact
Framework), but its still incomplete. I am working on implementing all
the editors to enable you to actually design tables, indexes, keys, views
etc.

Here's a movie I did demo'ing the VS2005 design-time support in the 2.0
provider for SQLite. It's based on a much older version of the program,
so isn't quite as fancy as it is now:

http://sqlite.phxsoftware.com/sqlite.wmv

And do yourself a favor -- hit the main website and read the forums! I
have lots of how-to's, and have a pretty good track record for answering
questions there :)

http://sqlite.phxsoftware.com

Robert Simpson
Programmer at Large


"ljh" <So**@where.els e> wrote in message
news:7e******** ***********@big news3.bellsouth .net...
I was looking at the site () and came across "Version 1.0.14 of the SQLite
.Net Data Provider for ADO.NET 2.0/VS 2005 is out and includes design-time
support. You can now create databases, design queries, and drag-and-drop
tables to create typed datasets within Visual Studio 2005. "

Is this capability still in there? I didn't see any examples of this.
If SQLite is as easy to use as this quote seems to make it (i.e. as easy
to use in the ide as SQL Express) we may just have a winner here.
"JimD" <Ji*@keeliegirl .dyndns.org> wrote in message
news:yu******** *********@torna do.tampabay.rr. com...
JimD wrote:

<snip>

I forgot to mention about the connection string in the example. The
connection string is:

Data Source=database .db;Version=3;N ew=True;Compres s=True;

The New=True token says to create a new database. So every time you run
the test program, you are creating a new database, overwriting the old.
You probably don't want to do that with a real application. So you
would only use the New=True in a connection string when you want to
create a database for the first time. After that, you can either remove
New=True or change it to New=False.
Jim
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
There's no place like 127.0.0.1
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
JimD
Central FL, USA, Earth, Sol



Jun 1 '06 #57
steve wrote:
Frank,
Can you point to something that documents your assertion that SQL Express
does not run on XP Home? Runs fine on my XP Home test machine....Have n't
been able to test access across a network to SQL/e on XP Home.
Steve,

I stand corrected. I just looked at the requirements page:
http://www.microsoft.com/sql/edition...s/sysreqs.mspx

and they just mention windows xp. The page must have changed, because
other people complained about it. Here is an article from database
journal when SQL Express came out says winxp pro.
http://www.databasejournal.com/featu...le.php/3492296

I guess they changed it.



"Frank Rizzo" <no**@none.co m> wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..
Sahil Malik [MVP C#] wrote:
The only advantage Access gives you is "File based deployment". And
frankly SQL Anywhere (or was it everywhere - I loose track in all these
name changes) should be a better choice for desktop-ish applications
anyway.

There is one more Access advantage: it'll run on Windows XP Home Edition,
while SQL Express will not (requires XP Pro). So if you are targeting
mom&pop shops or the home market, either do Access or stick to MSDE.

Regards


Jun 1 '06 #58
Especially if that one machine is the CEO's laptop.

SM
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
pig anecdote?


"Bill, it took me a while to realize this, but I think you're wrestling
with
a pig. He is enjoying it, and you're getting dirty. "
Re: the jet engine etc. - yeah but most machines have it.


It is enough if one (target) machine might be missing jet. :-)

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Jun 1 '06 #59
On Thu, 1 Jun 2006 15:25:02 -0400, "Sahil Malik [MVP C#]"
<co************ *****@nospam.co m> wrote:

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%2******* *********@TK2MS FTNGP02.phx.gbl ...

"Sahil Malik [MVP C#]" <co************ *****@nospam.co m> wrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..
Re: the jet engine etc. - yeah but most machines have it.


It is enough if one (target) machine might be missing jet. :-)

Especially if that one machine is the CEO's laptop.


Microsoft used to have an older Access jet engine available for
download. My impression is that they stopped when they incorporated
it into most operating systems. Do you know of any specific
platforms that do not have it?
Jun 1 '06 #60

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

Similar topics

72
3334
by: ljh | last post by:
Why would you choose SQL Express (which requires an installed application to work) over the simplicity of an Access database which has no dependencies?
0
9980
marktang
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...
0
9826
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
10468
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
9641
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...
1
8018
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7172
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();...
0
5855
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...
0
6061
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4276
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.