[Mono-list] Databind to SQLServer

Thu, 22 May 2003 17:17:02 -0700

Dear James,

I am not sure what your misunderstanding is but MSDE is a desktop engine,
similar to the jet engine used for MS Access.  It is embedded in your
program.  There is a big difference between that and a Server which runs on
its own and handles requests from multiple sources.  I suggest you read it
from the horses mouth:
http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp.

I agree that it is a useful product and has advantages such as being able to
embed the database engine in the distribution of the product, but it is a
long shot away from full blown Sql Server, and my point originally was that
a product promoted as working on Sql Server should be tested on it.

But don't get me wrong, I have nothing whatsoever against using MSDE, if it
fits your needs, and who can argue with the price.

Larry Jones
Hydrel/Lithonia Lighting

-----Original Message-----
From: James Berry [mailto:james@adastra.co.uk]
Sent: Thursday, May 22, 2003 5: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
> 
> 
> adam,
> 
> 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 zipped file which contains 
> pubs.mdf, pubs.ldf, and a sql script to create the database 
> from scratch, if you choose that route. It was because it was 
> too big for the list server, but I will send it to anyone who 
> e-mails me.
> 
> Larry Jones
> Hydrel/Lithonia Lighting
> 
> 
> -----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
> 
> 
> Default install of MSDE, which many many people use, does not 
> have the 'pubs' database.
> 
> -adam
> 
> -----Original Message-----
> From: mono-list-admin@lists.ximian.com 
> [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
> 
> 
> Gonzalo,
> 
> OK, I have posted it to Bugzilla.  As I have mention earlier, 
> and explained in my report, the Pubs database always comes 
> with a MS SQL 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 run my test page, if you 
> actually test against a MS Sql Server.  Of course you need to 
> replace SERVER with the real server name and file in the real 
> 'password'.  So really its easy to just copy my page throw it 
> in a file and test it.
> 
> Larry Jones
> Hydrel/Lithonia Lighting
> 
> 
> -----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
> 
> 
> El vie, 16 de 05 de 2003 a las 08:38, Jones, Larry escribió:
> > I have done so many different versions of this I get 
> confused.  I had:
> 
> > <%@ Import Namespace="System.Data.SqlClient" %>
> > 
> > and I had
> > 
> > <%@ Import Namespace="System.Data" %>
> > 
> > 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 
> > essentially the same exact code as in my C# program, which 
> does pull 
> > the data.  Heres the complete aspx page:
> 
> Instead of sending that page over and over, you could just 
> file a bug report in http://bugzilla.ximian.com (see also 
> http://www.go-> mono.com/contributing.html#goodbugreport).
> 
> 
> Please, also 
> attach the SQL needed to create the database and its tables.
> 
> Thanks in advance.
> 
> -Gonzalo
> 
> 
> _______________________________________________
> 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
> 
> _______________________________________________
> 
> Mono-list maillist  -  Mono-list@lists.ximian.com 
> http://lists.ximian.com/mailman/listinfo/mono-> list
> 