Why choose SQL Express over Access?

[ljh]

Re: Why choose SQL Express over Access?

"INETA Speaker" - at least you're unbiased.


"William (Bill) Vaughn" <billvaRemoveTh is@nwlink.com> wrote in message
news:OmWkZkHhGH A.1324@TK2MSFTN GP04.phx.gbl...[color=blue]
> Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
> It's not designed to do so but SQL Express (still free) is.
> Microsoft has done more for small business than any company I know. It now
> offers three versions of its database technology for free. SQL Everywhere,
> SQL Express and SQL Express Advanced Services that includes the Reporting
> Services engine as well as Full Text Search.
>
> If you just want to bash Microsoft, find some other forum.
>
> --
> _______________ _______________ ______
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> _______________ _______________ ____
>
> "ljh" <Some@where.els e> wrote in message
> news:_J4fg.6648 7$MM6.19820@big news3.bellsouth .net...[color=green]
>> Awesome!
>>
>> It doesn't look like they'll let us use it to power webservices under IIS
>> though.
>>
>> That would suck. Allowing its use under IIS would make hosted web
>> development so much easier!
>>
>> It would let small companies with big ideas give those ideas a shot at
>> succeeding without spending several thousand dollars for SQL Server.
>>
>> But, I don't think MS is all that interested in helping small businesses
>> grow. And, that's too bad. Doing so would actually fatten the bottom
>> line at MS as the little businesses need more MS licenses and maybe a
>> "grown up" version of SQL Server.
>>
>> If they did, who knows, it might even unseat MySQL as the web db king.
>>
>> Thanks for the great link!
>>
>>
>>
>> "William Stacey [MVP]" <william.stacey @gmail.com> wrote in message
>> news:Odp%23lzDh GHA.3376@TK2MSF TNGP03.phx.gbl. ..[color=darkred]
>>> Another option for you may be SQL Everywhere. I think will be released
>>> this
>>> summer. 1.4mb with 7 dlls.
>>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>>
>>> --
>>> William Stacey [MVP]
>>>
>>> "ljh" <Some@where.els e> wrote in message
>>> news:Dm2fg.6618 8$MM6.13884@big news3.bellsouth .net...
>>> |I mean that you can use Access databases simply by including the .mdb
>>> files
>>> | with your application, whereas using SQL Server Express requires that
>>> you
>>> | install SQL Server Express and have it running in the backgound.
>>> |
>>> | In the event that I use SQL Server Express and need to redistribute it
>>> with
>>> | my app, is there a silent install available?
>>> |
>>> | <james.curran@g mail.com> wrote in message
>>> | news:1149020977 .932902.220830@ u72g2000cwu.goo glegroups.com.. .
>>> | > Well, I'm not sure what you mean by "requires an installed
>>> application
>>> | > to work". I just downloaded it, ran the setup & it worked. And,
>>> since
>>> | > your reluctance to do that is the *ONLY* requirement you specify for
>>> | > your database needs, it's really hard to answer your question.
>>> | >
>>> | > So, the advantages of SQLExpress over Access, as I see them.
>>> | > 1) It's free.
>>> | > 2) It's directly compatible with Sql Server.
>>> | >
>>> |
>>> |
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]

[ljh]

Re: Why choose SQL Express over Access?

The connector for VS 2005 (.Net 2.0) makes connecting to the SQLite db a
snap.

But, it lacks any means of database manipulation (i.e. adding/removing
tables or columns or anything) from within the IDE.

So, ease of use is definitely not up there with SQL Express.


"ljh" <Some@where.els e> wrote in message
news:Ue9fg.6701 3$MM6.27054@big news3.bellsouth .net...[color=blue]
> oops! forgot the link to the page where I saw the quote......
>
> http://sourceforge.net/forum/forum.php?forum_id=489095
>
>
>
> "ljh" <Some@where.els e> wrote in message
> news:7e9fg.6701 2$MM6.65439@big news3.bellsouth .net...[color=green]
>>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" <Jim@keeliegirl .dyndns.org> wrote in message
>> news:yu8fg.8864 $eQ4.3616@torna do.tampabay.rr. com...[color=darkred]
>>> 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[/color]
>>
>>[/color]
>
>[/color]

[Peter Bromberg [C# MVP]]

Re: Why choose SQL Express over Access?

I use the SQLiteQA application, which does a very nice job and acts much like
Query Analyzer.

A copy is included in the download for this article:

http://www.eggheadcafe.com/articles/20051119.asp

Peter

--
Co-founder, Eggheadcafe.com developer portal:

http://www.eggheadcafe.com

UnBlog:

http://petesbloggerama.blogspot.com

"ljh" wrote:
[color=blue]
> The connector for VS 2005 (.Net 2.0) makes connecting to the SQLite db a
> snap.
>
> But, it lacks any means of database manipulation (i.e. adding/removing
> tables or columns or anything) from within the IDE.
>
> So, ease of use is definitely not up there with SQL Express.
>
>
> "ljh" <Some@where.els e> wrote in message
> news:Ue9fg.6701 3$MM6.27054@big news3.bellsouth .net...[color=green]
> > oops! forgot the link to the page where I saw the quote......
> >
> > http://sourceforge.net/forum/forum.php?forum_id=489095
> >
> >
> >
> > "ljh" <Some@where.els e> wrote in message
> > news:7e9fg.6701 2$MM6.65439@big news3.bellsouth .net...[color=darkred]
> >>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" <Jim@keeliegirl .dyndns.org> wrote in message
> >> news:yu8fg.8864 $eQ4.3616@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
> >>
> >>[/color]
> >
> >[/color]
>
>
>[/color]

[Cowboy \(Gregory A. Beamer\)]

Re: Why choose SQL Express over Access?

Let's see:

Ability to do asynch apps (Service Broker)
Server model instead of file system model
Complete support for stored procedures
Full SQL Server security model
Ability to run queries as another user, completely isolating the database
from the user
Better support for types in SQL Server than Access (in .NET)
Ability to schedule backups within the engine
Support for more types than Access
Ability to use XML as a datatype with querying capabilities

Is that enough, or should I go on?

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"ljh" <Some@where.els e> wrote in message
news:kP1fg.6618 4$MM6.44395@big news3.bellsouth .net...[color=blue]
> Why would you choose SQL Express (which requires an installed application
> to work) over the simplicity of an Access database which has no
> dependencies?
>
>
>[/color]

[Sahil Malik [MVP C#]]

Re: Why choose SQL Express over Access?

> The fact that Micrsoft added code to SQL Everywhere to PREVENT it from[color=blue]
> being used in an IIS process sucks! What about that don't you get?[/color]

First of all "CALM DOWN".
[color=blue]
> The fact that you can't control SQL Express (due to the fact that you
> usually don't control the HOSTED servers) and that you could get more data
> into SQL Everywhere (or SQLite for that matter) simply by using the
> available disk space than you do with most hosted website's db plans
> (which will include hosted SQL Express servers) sucks![/color]

Moving SQL Express to SQL Server is a peice of cake. I don't see what the
big unsolvable problem here is.

- Sahil Malik [MVP]

http://blah.winsmarts.com

"ljh" <Some@where.els e> wrote in message
news:ogbfg.1420 $EX2.833@bignew s5.bellsouth.ne t...[color=blue]
> The fact that you can't control SQL Express (due to the fact that you
> usually don't control the HOSTED servers) and that you could get more data
> into SQL Everywhere (or SQLite for that matter) simply by using the
> available disk space than you do with most hosted website's db plans
> (which will include hosted SQL Express servers) sucks!
>
> The fact that MS has an edition of Mobile SQL that they are making
> available for everything except IIS use sucks!
>
> The fact that Micrsoft added code to SQL Everywhere to PREVENT it from
> being used in an IIS process sucks! What about that don't you get?
>
> Microsoft again makes a valiant run downfield with the ball.....only to
> stop and sit on the 1 yard line.
>
>
> "Sahil Malik [MVP C#]" <contactmethrum yblog@nospam.co m> wrote in message
> news:OrGZK8GhGH A.4080@TK2MSFTN GP03.phx.gbl...[color=green]
>> Okay .. why does SQL express suck? It doesn't suck .. !!! It runs on a
>> full fledged SQL engine, sure deployment is a pain, but migrating to a
>> fullblown SQL Server is relatively painless.
>>
>>
>> Also, can you elaborate -
>>[color=darkred]
>>>>| Got confirmation from MS that they're deliberately breaking
>>>>compatabili ty
>>>> | with SQL\e running under IIS - they call it "soft-blocking".[/color]
>>
>>
>> ?
>>
>> - Sahil Malik
>> http://www.winsmarts.com
>> http://blah.winsmarts.com
>>
>>
>>
>>
>> "ljh" <Some@where.els e> wrote in message
>> news:mo7fg.6688 3$MM6.52917@big news3.bellsouth .net...[color=darkred]
>>>
>>> "William Stacey [MVP]" <william.stacey @gmail.com> wrote in message
>>> news:eE$gLoFhGH A.3924@TK2MSFTN GP03.phx.gbl...
>>>>| Got confirmation from MS that they're deliberately breaking
>>>>compatabili ty
>>>> | with SQL\e running under IIS - they call it "soft-blocking".
>>>>
>>>> Not sure how they would do that other then via license. I mean a sql
>>>> query
>>>> is not going to look any different coming from asp.net page or from
>>>> your own
>>>> host?
>>>
>>> Not sure.....that's the word I got back from Steve Lasker when I emailed
>>> him earlier today.
>>>
>>>>
>>>> | Sounds all fluffy and sweet....but what it means is that you won't be
>>>> able
>>>> | to use SQL\e to easily deploy webservices (actually you can;t use it
>>>> to
>>>> | deploy them at all - easy or not).
>>>>
>>>> Again, I think you should at least be able to use SQL Express and it is
>>>> free. IMHO, that product is a sweet and generous gift from MS.
>>>
>>> It is....for machines where you can install anything you want. For
>>> ASP.Net hosted webservers, it sucks.
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]

[Mike Lowery]

Re: Why choose SQL Express over Access?

http://msdn.microsoft.com/library/en...seoverview.asp

"ljh" <Some@where.els e> wrote in message
news:kP1fg.6618 4$MM6.44395@big news3.bellsouth .net...[color=blue]
> Why would you choose SQL Express (which requires an installed application to
> work) over the simplicity of an Access database which has no dependencies?
>
>
>[/color]

[ljh]

Re: Why choose SQL Express over Access?

Just curious......ca n you tell me a situation where using XML as a datatype
would come into play in a database application?

Why would you store XML in its native format instead of breaking it down
into its component fields for storage and seaarch?


"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld @comcast.netNoS pamM> wrote in
message news:O6q4onKhGH A.4144@TK2MSFTN GP02.phx.gbl...[color=blue]
> Let's see:
>
> Ability to do asynch apps (Service Broker)
> Server model instead of file system model
> Complete support for stored procedures
> Full SQL Server security model
> Ability to run queries as another user, completely isolating the database
> from the user
> Better support for types in SQL Server than Access (in .NET)
> Ability to schedule backups within the engine
> Support for more types than Access
> Ability to use XML as a datatype with querying capabilities
>
> Is that enough, or should I go on?
>
> --
> Gregory A. Beamer
>
> *************** *************** *************** ****
> Think Outside the Box!
> *************** *************** *************** ****
> "ljh" <Some@where.els e> wrote in message
> news:kP1fg.6618 4$MM6.44395@big news3.bellsouth .net...[color=green]
>> Why would you choose SQL Express (which requires an installed application
>> to work) over the simplicity of an Access database which has no
>> dependencies?
>>
>>
>>[/color]
>
>[/color]

[Jos Roijakkers]

Re: Why choose SQL Express over Access?

> Sahil Malik [MVP C#] wrote:[color=blue]
>
> 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
>[/color]

This is not true. SQL Express runs under XP Home as well (at least it does
on my machine). However, it does not support remote connections by default.

[William \(Bill\) Vaughn]

Re: Why choose SQL Express over Access?

Thanks Sahil. I thought it did but did not have a rig here to test it with.
Of course even the home system could host SQL Server as a service if you
throw the right switches.

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker

https://www.betav.com/blog/billva

https://www.betav.com

Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
_______________ _______________ ____

"Jos Roijakkers" <j.roijakkers@q red-it.nl> wrote in message
news:5d4a1f3de9 7e8c852fad9beee 28@news.microso ft.com...[color=blue][color=green]
>> Sahil Malik [MVP C#] wrote:
>>
>> 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
>>[/color]
>
> This is not true. SQL Express runs under XP Home as well (at least it does
> on my machine). However, it does not support remote connections by
> default.
>
>[/color]

[_DD]

Re: Why choose SQL Express over Access?

On Tue, 30 May 2006 15:49:50 -0700, Frank Rizzo <none@none.co m> wrote:
[color=blue]
>Sahil Malik [MVP C#] wrote:[color=green]
>> 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.[/color]
>
>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.[/color]

There are lots of places where an app that normally runs on high-end
XP Pro machines would have to run on XP Home as well. Does this mean
that applications must fit the common denominator: MSDE? I didn't
think MSDE was still supported.

And what about XP Media Center? I'd love to find out about future
plans to adapt to MC and Home editions, assuming there is no way to
target them now.

[steve]

Re: Why choose SQL Express over Access?

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.


"Frank Rizzo" <none@none.co m> wrote in message
news:%23j9fctDh GHA.4284@TK2MSF TNGP05.phx.gbl. ..[color=blue]
> Sahil Malik [MVP C#] wrote:[color=green]
>> 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.[/color]
>
> 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[/color]

[Sahil Malik [MVP C#]]

Re: Why choose SQL Express over Access?

Well, both INETA speakers and MVPs are unbiased.

I'm an INETA speaker and MVP myself, and nearly don't have the same pedigree
as Bill Vaughn, but I must agree with his views on Microsoft.

- Sahil Malik

http://www.winsmarts.com

http://blah.winsmarts.com

"ljh" <Some@where.els e> wrote in message
news:aibfg.1442 $EX2.652@bignew s5.bellsouth.ne t...[color=blue]
> "INETA Speaker" - at least you're unbiased.
>
>
> "William (Bill) Vaughn" <billvaRemoveTh is@nwlink.com> wrote in message
> news:OmWkZkHhGH A.1324@TK2MSFTN GP04.phx.gbl...[color=green]
>> Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
>> It's not designed to do so but SQL Express (still free) is.
>> Microsoft has done more for small business than any company I know. It
>> now offers three versions of its database technology for free. SQL
>> Everywhere, SQL Express and SQL Express Advanced Services that includes
>> the Reporting Services engine as well as Full Text Search.
>>
>> If you just want to bash Microsoft, find some other forum.
>>
>> --
>> _______________ _______________ ______
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> _______________ _______________ ____
>>
>> "ljh" <Some@where.els e> wrote in message
>> news:_J4fg.6648 7$MM6.19820@big news3.bellsouth .net...[color=darkred]
>>> Awesome!
>>>
>>> It doesn't look like they'll let us use it to power webservices under
>>> IIS though.
>>>
>>> That would suck. Allowing its use under IIS would make hosted web
>>> development so much easier!
>>>
>>> It would let small companies with big ideas give those ideas a shot at
>>> succeeding without spending several thousand dollars for SQL Server.
>>>
>>> But, I don't think MS is all that interested in helping small businesses
>>> grow. And, that's too bad. Doing so would actually fatten the bottom
>>> line at MS as the little businesses need more MS licenses and maybe a
>>> "grown up" version of SQL Server.
>>>
>>> If they did, who knows, it might even unseat MySQL as the web db king.
>>>
>>> Thanks for the great link!
>>>
>>>
>>>
>>> "William Stacey [MVP]" <william.stacey @gmail.com> wrote in message
>>> news:Odp%23lzDh GHA.3376@TK2MSF TNGP03.phx.gbl. ..
>>>> Another option for you may be SQL Everywhere. I think will be released
>>>> this
>>>> summer. 1.4mb with 7 dlls.
>>>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>>>
>>>> --
>>>> William Stacey [MVP]
>>>>
>>>> "ljh" <Some@where.els e> wrote in message
>>>> news:Dm2fg.6618 8$MM6.13884@big news3.bellsouth .net...
>>>> |I mean that you can use Access databases simply by including the .mdb
>>>> files
>>>> | with your application, whereas using SQL Server Express requires that
>>>> you
>>>> | install SQL Server Express and have it running in the backgound.
>>>> |
>>>> | In the event that I use SQL Server Express and need to redistribute
>>>> it
>>>> with
>>>> | my app, is there a silent install available?
>>>> |
>>>> | <james.curran@g mail.com> wrote in message
>>>> | news:1149020977 .932902.220830@ u72g2000cwu.goo glegroups.com.. .
>>>> | > Well, I'm not sure what you mean by "requires an installed
>>>> application
>>>> | > to work". I just downloaded it, ran the setup & it worked. And,
>>>> since
>>>> | > your reluctance to do that is the *ONLY* requirement you specify
>>>> for
>>>> | > your database needs, it's really hard to answer your question.
>>>> | >
>>>> | > So, the advantages of SQLExpress over Access, as I see them.
>>>> | > 1) It's free.
>>>> | > 2) It's directly compatible with Sql Server.
>>>> | >
>>>> |
>>>> |
>>>>
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]

[ljh]

Re: Why choose SQL Express over Access?

Of course you must....

"Sahil Malik [MVP C#]" <contactmethrum yblog@nospam.co m> wrote in message
news:u3xKRLRhGH A.1264@TK2MSFTN GP05.phx.gbl...[color=blue]
> Well, both INETA speakers and MVPs are unbiased.
>
> I'm an INETA speaker and MVP myself, and nearly don't have the same
> pedigree as Bill Vaughn, but I must agree with his views on Microsoft.
>
> - Sahil Malik
> http://www.winsmarts.com
> http://blah.winsmarts.com
>
>
>
> "ljh" <Some@where.els e> wrote in message
> news:aibfg.1442 $EX2.652@bignew s5.bellsouth.ne t...[color=green]
>> "INETA Speaker" - at least you're unbiased.
>>
>>
>> "William (Bill) Vaughn" <billvaRemoveTh is@nwlink.com> wrote in message
>> news:OmWkZkHhGH A.1324@TK2MSFTN GP04.phx.gbl...[color=darkred]
>>> Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
>>> It's not designed to do so but SQL Express (still free) is.
>>> Microsoft has done more for small business than any company I know. It
>>> now offers three versions of its database technology for free. SQL
>>> Everywhere, SQL Express and SQL Express Advanced Services that includes
>>> the Reporting Services engine as well as Full Text Search.
>>>
>>> If you just want to bash Microsoft, find some other forum.
>>>
>>> --
>>> _______________ _______________ ______
>>> William (Bill) Vaughn
>>> Author, Mentor, Consultant
>>> Microsoft MVP
>>> INETA Speaker
>>> www.betav.com/blog/billva
>>> www.betav.com
>>> Please reply only to the newsgroup so that others can benefit.
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>> _______________ _______________ ____
>>>
>>> "ljh" <Some@where.els e> wrote in message
>>> news:_J4fg.6648 7$MM6.19820@big news3.bellsouth .net...
>>>> Awesome!
>>>>
>>>> It doesn't look like they'll let us use it to power webservices under
>>>> IIS though.
>>>>
>>>> That would suck. Allowing its use under IIS would make hosted web
>>>> development so much easier!
>>>>
>>>> It would let small companies with big ideas give those ideas a shot at
>>>> succeeding without spending several thousand dollars for SQL Server.
>>>>
>>>> But, I don't think MS is all that interested in helping small
>>>> businesses grow. And, that's too bad. Doing so would actually fatten
>>>> the bottom line at MS as the little businesses need more MS licenses
>>>> and maybe a "grown up" version of SQL Server.
>>>>
>>>> If they did, who knows, it might even unseat MySQL as the web db king.
>>>>
>>>> Thanks for the great link!
>>>>
>>>>
>>>>
>>>> "William Stacey [MVP]" <william.stacey @gmail.com> wrote in message
>>>> news:Odp%23lzDh GHA.3376@TK2MSF TNGP03.phx.gbl. ..
>>>>> Another option for you may be SQL Everywhere. I think will be
>>>>> released this
>>>>> summer. 1.4mb with 7 dlls.
>>>>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>>>>
>>>>> --
>>>>> William Stacey [MVP]
>>>>>
>>>>> "ljh" <Some@where.els e> wrote in message
>>>>> news:Dm2fg.6618 8$MM6.13884@big news3.bellsouth .net...
>>>>> |I mean that you can use Access databases simply by including the .mdb
>>>>> files
>>>>> | with your application, whereas using SQL Server Express requires
>>>>> that you
>>>>> | install SQL Server Express and have it running in the backgound.
>>>>> |
>>>>> | In the event that I use SQL Server Express and need to redistribute
>>>>> it
>>>>> with
>>>>> | my app, is there a silent install available?
>>>>> |
>>>>> | <james.curran@g mail.com> wrote in message
>>>>> | news:1149020977 .932902.220830@ u72g2000cwu.goo glegroups.com.. .
>>>>> | > Well, I'm not sure what you mean by "requires an installed
>>>>> application
>>>>> | > to work". I just downloaded it, ran the setup & it worked. And,
>>>>> since
>>>>> | > your reluctance to do that is the *ONLY* requirement you specify
>>>>> for
>>>>> | > your database needs, it's really hard to answer your question.
>>>>> | >
>>>>> | > So, the advantages of SQLExpress over Access, as I see them.
>>>>> | > 1) It's free.
>>>>> | > 2) It's directly compatible with Sql Server.
>>>>> | >
>>>>> |
>>>>> |
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]

[Sahil Malik [MVP C#]]

Re: Why choose SQL Express over Access?

SQL Express will run on XP Media center.


--

- Sahil Malik

http://www.winsmarts.com

http://blah.winsmarts.com

"_DD" <_@nospam.com > wrote in message
news:octr72ll2s t47a5ocsnrohkfe pa60karu4@4ax.c om...[color=blue]
> On Tue, 30 May 2006 15:49:50 -0700, Frank Rizzo <none@none.co m> wrote:
>[color=green]
>>Sahil Malik [MVP C#] wrote:[color=darkred]
>>> 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.[/color]
>>
>>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.[/color]
>
> There are lots of places where an app that normally runs on high-end
> XP Pro machines would have to run on XP Home as well. Does this mean
> that applications must fit the common denominator: MSDE? I didn't
> think MSDE was still supported.
>
> And what about XP Media Center? I'd love to find out about future
> plans to adapt to MC and Home editions, assuming there is no way to
> target them now.
>[/color]

[William \(Bill\) Vaughn]

Re: Why choose SQL Express over Access?

Excuse me? Are you accusing us of something? I would make pretty sure you're
on solid ground before impugning our honesty in a public forum. If you
really knew me, if you really understood where I have stood for the last 20
years, you would not be saying anything about how I coddle Microsoft or show
bias toward their products. From time to time I have been highly critical of
Microsoft--even as an employee (for 14 years). Microsoft has not always
liked to hear what I have said, but they have listened--just as they listen
to every one with any credibility at all. I for one have just finished my
11th book on this subject and yes, this book like all the others talks about
what works and what does not.

Do you think you fall into that category?

--
_______________ _______________ ______
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker

https://www.betav.com/blog/billva

https://www.betav.com

Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
_______________ _______________ ____

"ljh" <Some@where.els e> wrote in message
news:3Cqfg.4977 $8e2.2263@bigne ws1.bellsouth.n et...[color=blue]
> Of course you must....
>
> "Sahil Malik [MVP C#]" <contactmethrum yblog@nospam.co m> wrote in message
> news:u3xKRLRhGH A.1264@TK2MSFTN GP05.phx.gbl...[color=green]
>> Well, both INETA speakers and MVPs are unbiased.
>>
>> I'm an INETA speaker and MVP myself, and nearly don't have the same
>> pedigree as Bill Vaughn, but I must agree with his views on Microsoft.
>>
>> - Sahil Malik
>> http://www.winsmarts.com
>> http://blah.winsmarts.com
>>
>>
>>
>> "ljh" <Some@where.els e> wrote in message
>> news:aibfg.1442 $EX2.652@bignew s5.bellsouth.ne t...[color=darkred]
>>> "INETA Speaker" - at least you're unbiased.
>>>
>>>
>>> "William (Bill) Vaughn" <billvaRemoveTh is@nwlink.com> wrote in message
>>> news:OmWkZkHhGH A.1324@TK2MSFTN GP04.phx.gbl...
>>>> Ah SQL Express can be used with an IIS web site. SQL Everywhere cannot.
>>>> It's not designed to do so but SQL Express (still free) is.
>>>> Microsoft has done more for small business than any company I know. It
>>>> now offers three versions of its database technology for free. SQL
>>>> Everywhere, SQL Express and SQL Express Advanced Services that includes
>>>> the Reporting Services engine as well as Full Text Search.
>>>>
>>>> If you just want to bash Microsoft, find some other forum.
>>>>
>>>> --
>>>> _______________ _______________ ______
>>>> William (Bill) Vaughn
>>>> Author, Mentor, Consultant
>>>> Microsoft MVP
>>>> INETA Speaker
>>>> www.betav.com/blog/billva
>>>> www.betav.com
>>>> Please reply only to the newsgroup so that others can benefit.
>>>> This posting is provided "AS IS" with no warranties, and confers no
>>>> rights.
>>>> _______________ _______________ ____
>>>>
>>>> "ljh" <Some@where.els e> wrote in message
>>>> news:_J4fg.6648 7$MM6.19820@big news3.bellsouth .net...
>>>>> Awesome!
>>>>>
>>>>> It doesn't look like they'll let us use it to power webservices under
>>>>> IIS though.
>>>>>
>>>>> That would suck. Allowing its use under IIS would make hosted web
>>>>> development so much easier!
>>>>>
>>>>> It would let small companies with big ideas give those ideas a shot at
>>>>> succeeding without spending several thousand dollars for SQL Server.
>>>>>
>>>>> But, I don't think MS is all that interested in helping small
>>>>> businesses grow. And, that's too bad. Doing so would actually fatten
>>>>> the bottom line at MS as the little businesses need more MS licenses
>>>>> and maybe a "grown up" version of SQL Server.
>>>>>
>>>>> If they did, who knows, it might even unseat MySQL as the web db king.
>>>>>
>>>>> Thanks for the great link!
>>>>>
>>>>>
>>>>>
>>>>> "William Stacey [MVP]" <william.stacey @gmail.com> wrote in message
>>>>> news:Odp%23lzDh GHA.3376@TK2MSF TNGP03.phx.gbl. ..
>>>>>> Another option for you may be SQL Everywhere. I think will be
>>>>>> released this
>>>>>> summer. 1.4mb with 7 dlls.
>>>>>> http://blogs.msdn.com/stevelasker/ar...whereInfo.aspx
>>>>>>
>>>>>> --
>>>>>> William Stacey [MVP]
>>>>>>
>>>>>> "ljh" <Some@where.els e> wrote in message
>>>>>> news:Dm2fg.6618 8$MM6.13884@big news3.bellsouth .net...
>>>>>> |I mean that you can use Access databases simply by including the
>>>>>> .mdb files
>>>>>> | with your application, whereas using SQL Server Express requires
>>>>>> that you
>>>>>> | install SQL Server Express and have it running in the backgound.
>>>>>> |
>>>>>> | In the event that I use SQL Server Express and need to redistribute
>>>>>> it
>>>>>> with
>>>>>> | my app, is there a silent install available?
>>>>>> |
>>>>>> | <james.curran@g mail.com> wrote in message
>>>>>> | news:1149020977 .932902.220830@ u72g2000cwu.goo glegroups.com.. .
>>>>>> | > Well, I'm not sure what you mean by "requires an installed
>>>>>> application
>>>>>> | > to work". I just downloaded it, ran the setup & it worked. And,
>>>>>> since
>>>>>> | > your reluctance to do that is the *ONLY* requirement you specify
>>>>>> for
>>>>>> | > your database needs, it's really hard to answer your question.
>>>>>> | >
>>>>>> | > So, the advantages of SQLExpress over Access, as I see them.
>>>>>> | > 1) It's free.
>>>>>> | > 2) It's directly compatible with Sql Server.
>>>>>> | >
>>>>>> |
>>>>>> |
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]