MSDE and C#

[Diogo Alves - Software Developer]

hi there

I am developing a software that needs a database to be shared, I've heard
about MSDE, can someone tell me if

* There is a newer version than MSDE 2000?
* It's possible to use MSDE with C#.Net?
* I would like a tutorial or something about deploying MSDE with my
application.

I hope to have some feedback, and thanks in advance

[Norman Yuan]

Re: MSDE and C#


"Diogo Alves - Software Developer"
<DiogoAlvesSoft wareDeveloper@d iscussions.micr osoft.com> wrote in message
news:E6B21935-F3DF-45DD-AAFE-E8CA857132DA@mi crosoft.com...[color=blue]
> hi there
>
> I am developing a software that needs a database to be shared, I've heard
> about MSDE, can someone tell me if
>
> * There is a newer version than MSDE 2000?[/color]

SQL2005 Express beta (Free down load, for now), will be formally release
this November(still free then?)
[color=blue]
> * It's possible to use MSDE with C#.Net?[/color]

Yes.
[color=blue]
> * I would like a tutorial or something about deploying MSDE with my
> application.[/color]

Almost all tutorials/examples on SQL Server apply to MSDE. MSDE is SQL
Server, except for lack of user-friendly management tool and some capacity
limitation. Search ketword "MSDE" on the web or MS Knowledge base. you'll be
overwhelmed.
[color=blue]
>
> I hope to have some feedback, and thanks in advance[/color]

[Cor Ligthert [MVP]]

Re: MSDE and C#

Diogo,

There comes a new version of MSDE, SQL server Express.

Some people tell that it will be free. I am not so sure of it because for
all Express products is planed a price from about $50

Both are easy to use with C#

One of the important points will be that the newer version will be easier to
deploy, which tells for me something about MSDE. It is difficult to deploy
if the computer has (uses) no strong passwords, however all deployments help
in English I have seen on MSDN or in the help file expects that the computer
is used with a strong password. (The Dutch does not and I think that they
have a good reason for that).

If you have passed the point of the strong password it is very easy to
install, however there is no administrator tool with it, for that you have
to use Visual Studio or a third party tool which are easy to find on
Internet.

It is easy to build by yourself as well by the way using C#.

:-)

I hope this helps,

Cor

[Diogo Alves - Software Developer]

Re: MSDE and C#

Ok, the problem is that I have a software that has 2 ways of install, one is
server and another is client, so I want to know how to do a setup with
that....in order to instal the database without giving any troubles to the
final user.

About the SQL2005 Express, I want a free distributable database ;), so I
guess I will have to wait till then :D

Thanks a lot
"Norman Yuan" wrote:
[color=blue]
>
> "Diogo Alves - Software Developer"
> <DiogoAlvesSoft wareDeveloper@d iscussions.micr osoft.com> wrote in message
> news:E6B21935-F3DF-45DD-AAFE-E8CA857132DA@mi crosoft.com...[color=green]
> > hi there
> >
> > I am developing a software that needs a database to be shared, I've heard
> > about MSDE, can someone tell me if
> >
> > * There is a newer version than MSDE 2000?[/color]
>
> SQL2005 Express beta (Free down load, for now), will be formally release
> this November(still free then?)
>[color=green]
> > * It's possible to use MSDE with C#.Net?[/color]
>
> Yes.
>[color=green]
> > * I would like a tutorial or something about deploying MSDE with my
> > application.[/color]
>
> Almost all tutorials/examples on SQL Server apply to MSDE. MSDE is SQL
> Server, except for lack of user-friendly management tool and some capacity
> limitation. Search ketword "MSDE" on the web or MS Knowledge base. you'll be
> overwhelmed.
>[color=green]
> >
> > I hope to have some feedback, and thanks in advance[/color]
>
>
>[/color]

[Edwin E. Smith]

Re: MSDE and C#


"Norman Yuan" <NotReal@NotRea l.not> wrote in message
news:ecahfiApFH A.3036@TK2MSFTN GP14.phx.gbl...[color=blue]
>
> "Diogo Alves - Software Developer"
> <DiogoAlvesSoft wareDeveloper@d iscussions.micr osoft.com> wrote in message
> news:E6B21935-F3DF-45DD-AAFE-E8CA857132DA@mi crosoft.com...[color=green]
>> hi there
>>
>> I am developing a software that needs a database to be shared, I've heard
>> about MSDE, can someone tell me if
>>
>> * There is a newer version than MSDE 2000?[/color]
>
> SQL2005 Express beta (Free down load, for now), will be formally release
> this November(still free then?)
>[color=green]
>> * It's possible to use MSDE with C#.Net?[/color]
>
> Yes.
>[color=green]
>> * I would like a tutorial or something about deploying MSDE with my
>> application.[/color]
>
> Almost all tutorials/examples on SQL Server apply to MSDE. MSDE is SQL
> Server, except for lack of user-friendly management tool and some capacity
> limitation. Search ketword "MSDE" on the web or MS Knowledge base. you'll
> be
> overwhelmed.
>[color=green]
>>
>> I hope to have some feedback, and thanks in advance[/color]
>
>[/color]

The Enterprise Manager for SQL Server 2000 works fine with MSDE. I don't
know what the license says but I installed the Client tools from my SQL2K CD
without the SQL server so I could use Enterprise MGR with MSDE.

The Server Explorer in the VS IDE works very well also.

Edwin

[Norman Yuan]

Re: MSDE and C#

I believe you are not allowed to use Enterprise Manager with MSDE, unless
you have lisenced SQL Server on the same computer (or LAN?).

"Edwin E. Smith" <edwin@freehold consulting.com> wrote in message
news:ePW#27CpFH A.1464@TK2MSFTN GP14.phx.gbl...[color=blue]
>
> "Norman Yuan" <NotReal@NotRea l.not> wrote in message
> news:ecahfiApFH A.3036@TK2MSFTN GP14.phx.gbl...[color=green]
> >
> > "Diogo Alves - Software Developer"
> > <DiogoAlvesSoft wareDeveloper@d iscussions.micr osoft.com> wrote in message
> > news:E6B21935-F3DF-45DD-AAFE-E8CA857132DA@mi crosoft.com...[color=darkred]
> >> hi there
> >>
> >> I am developing a software that needs a database to be shared, I've[/color][/color][/color]
heard[color=blue][color=green][color=darkred]
> >> about MSDE, can someone tell me if
> >>
> >> * There is a newer version than MSDE 2000?[/color]
> >
> > SQL2005 Express beta (Free down load, for now), will be formally release
> > this November(still free then?)
> >[color=darkred]
> >> * It's possible to use MSDE with C#.Net?[/color]
> >
> > Yes.
> >[color=darkred]
> >> * I would like a tutorial or something about deploying MSDE with my
> >> application.[/color]
> >
> > Almost all tutorials/examples on SQL Server apply to MSDE. MSDE is SQL
> > Server, except for lack of user-friendly management tool and some[/color][/color]
capacity[color=blue][color=green]
> > limitation. Search ketword "MSDE" on the web or MS Knowledge base.[/color][/color]
you'll[color=blue][color=green]
> > be
> > overwhelmed.
> >[color=darkred]
> >>
> >> I hope to have some feedback, and thanks in advance[/color]
> >
> >[/color]
>
> The Enterprise Manager for SQL Server 2000 works fine with MSDE. I don't
> know what the license says but I installed the Client tools from my SQL2K[/color]
CD[color=blue]
> without the SQL server so I could use Enterprise MGR with MSDE.
>
> The Server Explorer in the VS IDE works very well also.
>
> Edwin
>
>[/color]

[Edwin E. Smith]

Re: MSDE and C#

I have SBS2003 which includes SQL2K. AFAIK I'm OK to use it.

"Norman Yuan" <NotReal@NotRea l.not> wrote in message
news:OKsrmEDpFH A.2904@tk2msftn gp13.phx.gbl...[color=blue]
>I believe you are not allowed to use Enterprise Manager with MSDE, unless
> you have lisenced SQL Server on the same computer (or LAN?).
>
> "Edwin E. Smith" <edwin@freehold consulting.com> wrote in message
> news:ePW#27CpFH A.1464@TK2MSFTN GP14.phx.gbl...[color=green]
>>
>> "Norman Yuan" <NotReal@NotRea l.not> wrote in message
>> news:ecahfiApFH A.3036@TK2MSFTN GP14.phx.gbl...[color=darkred]
>> >
>> > "Diogo Alves - Software Developer"
>> > <DiogoAlvesSoft wareDeveloper@d iscussions.micr osoft.com> wrote in
>> > message
>> > news:E6B21935-F3DF-45DD-AAFE-E8CA857132DA@mi crosoft.com...
>> >> hi there
>> >>
>> >> I am developing a software that needs a database to be shared, I've[/color][/color]
> heard[color=green][color=darkred]
>> >> about MSDE, can someone tell me if
>> >>
>> >> * There is a newer version than MSDE 2000?
>> >
>> > SQL2005 Express beta (Free down load, for now), will be formally
>> > release
>> > this November(still free then?)
>> >
>> >> * It's possible to use MSDE with C#.Net?
>> >
>> > Yes.
>> >
>> >> * I would like a tutorial or something about deploying MSDE with
>> >> my
>> >> application.
>> >
>> > Almost all tutorials/examples on SQL Server apply to MSDE. MSDE is SQL
>> > Server, except for lack of user-friendly management tool and some[/color][/color]
> capacity[color=green][color=darkred]
>> > limitation. Search ketword "MSDE" on the web or MS Knowledge base.[/color][/color]
> you'll[color=green][color=darkred]
>> > be
>> > overwhelmed.
>> >
>> >>
>> >> I hope to have some feedback, and thanks in advance
>> >
>> >[/color]
>>
>> The Enterprise Manager for SQL Server 2000 works fine with MSDE. I don't
>> know what the license says but I installed the Client tools from my SQL2K[/color]
> CD[color=green]
>> without the SQL server so I could use Enterprise MGR with MSDE.
>>
>> The Server Explorer in the VS IDE works very well also.
>>
>> Edwin
>>
>>[/color]
>
>[/color]

[Diogo Alves - Software Developer]

Re: MSDE and C#

ok, for what I read so far, it's free and it will always be, in the oficial
site, they say that it's free, having a EULA similar to the MSDE, and it
would not be fair if they are getting money from a limited database if we can
have mysql almost for free! and it is much better if we compare the
quality-price against the sql server

anyway...I just need to twest it and check for myself how to deploy....
thanks for everything´


"Cor Ligthert [MVP]" wrote:
[color=blue]
> Diogo,
>
> There comes a new version of MSDE, SQL server Express.
>
> Some people tell that it will be free. I am not so sure of it because for
> all Express products is planed a price from about $50
>
> Both are easy to use with C#
>
> One of the important points will be that the newer version will be easier to
> deploy, which tells for me something about MSDE. It is difficult to deploy
> if the computer has (uses) no strong passwords, however all deployments help
> in English I have seen on MSDN or in the help file expects that the computer
> is used with a strong password. (The Dutch does not and I think that they
> have a good reason for that).
>
> If you have passed the point of the strong password it is very easy to
> install, however there is no administrator tool with it, for that you have
> to use Visual Studio or a third party tool which are easy to find on
> Internet.
>
> It is easy to build by yourself as well by the way using C#.
>
> :-)
>
> I hope this helps,
>
> Cor
>
>
>
>[/color]