[Mono-list] Databind to SQLServer

[Adam Chester]

You can indeed have full control over instance names of MSDE. It is as
simple as a one-line configuration file option before running setup.

-adam

-----Original Message-----
From: mono-list-admin@lists.ximian.com
[mailto:mono-list-admin@lists.ximian.com] On Behalf Of Hood, Gavan
Sent: Thursday, 22 May 2003 10:45 PM
To: 'James Berry'; Jones, Larry; mono-list@lists.ximian.com
Subject: RE: [Mono-list] Databind to SQLServer


I have been aware of a number of bugs and problems with MSDE over the
years.... And differences in functionality such as not being able to
have control over instance names which screwed up SQL server apps ...

Your comments are quite correct but I am wondering if these bugs have
changed.

Can you let me know your comments please.

Gavan

-----Original Message-----
From: James Berry [mailto:james@adastra.co.uk]=20
Sent: Thursday, May 22, 2003 8:07 AM
To: Jones, Larry; mono-list@lists.ximian.com
Subject: RE: [Mono-list] Databind to SQLServer


MSDE does not emulate Sql Server.  It is SQL Server.  Just a cut down,
free version of SQL Server.  There are database size limits, but you're
unlikely to reach these - the main disadvantage is it doesn't come with
Enterprise Manager or Query Analyser, but there are lots of third party
tools which replicate this funcitonality (including vs.net itself!)

MSDE installs into the same directories as SQL Server - you can even
upgrade from MSDE to Sql Server just by installing over the top.

I know this is (slightly) off-topic, but it's quite important because
MSDE is quite widely used, and is likely to become even more so because
it is just so good for it's price.

Best wishes
James


> -----Original Message-----
> From: Jones, Larry [mailto:LJones@Lithonia.com]
> Sent: 21 May 2003 18:41
> To: 'mono-list@lists.ximian.com'
> Subject: RE: [Mono-list] Databind to SQLServer
>=20
>=20
> adam,
>=20
> It never occurred to me that serious testing of MS Sql Server would be

> done with the Desktop Engine, which emulates SQL Server.  However, the

> Pubs database is widely available, even for this product.  I have a=20
> zipped file which contains pubs.mdf, pubs.ldf, and a sql script to=20
> create the database from scratch, if you choose that route. It was=20
> because it was too big for the list server, but I will send it to=20
> anyone who e-mails me.
>=20
> Larry Jones
> Hydrel/Lithonia Lighting
>=20
>=20
> -----Original Message-----
> From: Adam Chester [mailto:achester@bigpond.com]
> Sent: Tuesday, May 20, 2003 8:37 PM
> To: 'Jones, Larry'; mono-list@lists.ximian.com
> Subject: RE: [Mono-list] Databind to SQLServer
>=20
>=20
> Default install of MSDE, which many many people use, does not have the

> 'pubs' database.
>=20
> -adam
>=20
> -----Original Message-----
> From: mono-list-admin@lists.ximian.com=20
> [mailto:mono-list-admin@lists.ximian.com] On Behalf Of Jones, Larry
> Sent: Wednesday, 21 May 2003 9:30 AM
> To: 'mono-list@lists.ximian.com'
> Subject: RE: [Mono-list] Databind to SQLServer
>=20
>=20
> Gonzalo,
>=20
> OK, I have posted it to Bugzilla.  As I have mention earlier, and=20
> explained in my report, the Pubs database always comes with a MS SQL=20
> Server install. Its a standard sample db for reference and testing.  I

> just used this in my test code and it requires no setup whatsoever to=20
> run my test page, if you actually test against a MS Sql Server.  Of=20
> course you need to replace SERVER with the real server name and file=20
> in the real 'password'.  So really its easy to just copy my page throw

> it in a file and test it.
>=20
> Larry Jones
> Hydrel/Lithonia Lighting
>=20
>=20
> -----Original Message-----
> From: Gonzalo Paniagua Javier [mailto:gonzalo@ximian.com]
> Sent: Tuesday, May 20, 2003 8:09 AM
> To: 'mono-list@lists.ximian.com'
> Subject: RE: [Mono-list] Databind to SQLServer
>=20
>=20
> El vie, 16 de 05 de 2003 a las 08:38, Jones, Larry escribi=F3:
> > I have done so many different versions of this I get
> confused.  I had:
>=20
> > <%@ Import Namespace=3D"System.Data.SqlClient" %>
> >=20
> > and I had
> >=20
> > <%@ Import Namespace=3D"System.Data" %>
> >=20
> > at one point.  (Seems like in the previous release this worked,...)
> > So, I added it back in, and now I don't get any data back.  Its=20
> > essentially the same exact code as in my C# program, which
> does pull
> > the data.  Heres the complete aspx page:
>=20
> Instead of sending that page over and over, you could just file a bug=20
> report in http://bugzilla.ximian.com (see also http://www.go->=20
> mono.com/contributing.html#goodbugreport).
>=20
>=20
> Please, also
> attach the SQL needed to create the database and its tables.
>=20
> Thanks in advance.
>=20
> -Gonzalo
>=20
>=20
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com=20
> http://lists.ximian.com/mailman/listinfo/mono-> list
>=20
> _______________________________________________
>=20
> Mono-list maillist  -  Mono-list@lists.ximian.com=20
> http://lists.ximian.com/mailman/listinfo/mono-> list
>=20
> _______________________________________________
>=20
> Mono-list maillist  -  Mono-list@lists.ximian.com=20
> http://lists.ximian.com/mailman/listinfo/mono-> list
>=20
_______________________________________________
Mono-list maillist  -  Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________
Mono-list maillist  -  Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list