[Mono-list] Databind to SQLServer

James Berry james@adastra.co.uk
Thu, 22 May 2003 13:06:36 +0100


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]=20
> 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=20
> would be done with the Desktop Engine, which emulates SQL=20
> Server.  However, the Pubs database is widely available, even=20
> for this product.  I have a zipped file which contains=20
> pubs.mdf, pubs.ldf, and a sql script to create the database=20
> from scratch, if you choose that route. It was because it was=20
> too big for the list server, but I will send it to anyone who=20
> 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=20
> 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,=20
> and explained in my report, the Pubs database always comes=20
> with a MS SQL Server install. Its a standard sample db for=20
> reference and testing.  I just used this in my test code and=20
> it requires no setup whatsoever to run my test page, if you=20
> actually test against a MS Sql Server.  Of course you need to=20
> replace SERVER with the real server name and file in the real=20
> 'password'.  So really its easy to just copy my page throw it=20
> 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=20
> 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=20
> does pull=20
> > the data.  Heres the complete aspx page:
>=20
> Instead of sending that page over and over, you could just=20
> file a bug report in http://bugzilla.ximian.com (see also=20
> http://www.go-> mono.com/contributing.html#goodbugreport).
>=20
>=20
> Please, also=20
> 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