[Mono-list] Databind to SQLServer

[James Berry]

Hi Gavan,

The latest MSDE is just a cut down Sql Server 2000, and handles instance =
names no problem.  The biggest difference in functionality is not =
facilitating linked servers.

Best wishes
James


> -----Original Message-----
> From: Hood, Gavan [mailto:gwhood@software.rockwell.com]=20
> Sent: 22 May 2003 13:45
> To: James Berry; Jones, Larry; mono-list@lists.ximian.com
> Subject: RE: [Mono-list] Databind to SQLServer
>=20
>=20
> I have been aware of a number of bugs and problems with MSDE=20
> over the years.... And differences in functionality such as=20
> not being able to have control over instance names which=20
> screwed up SQL server apps ...
>=20
> Your comments are quite correct but I am wondering if these=20
> bugs have changed.
>=20
> Can you let me know your comments please.
>=20
> Gavan
>=20
> -----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
>=20
>=20
> MSDE does not emulate Sql Server.  It is SQL Server.  Just a=20
> cut down, free version of SQL Server.  There are database=20
> size limits, but you're unlikely to reach these - the main=20
> disadvantage is it doesn't come with Enterprise Manager or=20
> Query Analyser, but there are lots of third party tools which=20
> replicate this funcitonality (including vs.net itself!)
>=20
> MSDE installs into the same directories as SQL Server - you=20
> can even upgrade from MSDE to Sql Server just by installing=20
> over the top.
>=20
> I know this is (slightly) off-topic, but it's quite important=20
> because MSDE is quite widely used, and is likely to become=20
> even more so because it is just so good for it's price.
>=20
> Best wishes
> James
>=20
>=20
> > -----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=20
> Server would be=20
> > done with the Desktop Engine, which emulates SQL Server. =20
> However, the=20
> > 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=20
> not have the=20
> > '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=20
> a MS SQL=20
> > Server install. Its a standard sample db for reference and=20
> testing.  I=20
> > just used this in my test code and it requires no setup=20
> 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=20
> and file=20
> > in the real 'password'.  So really its easy to just copy my=20
> page throw=20
> > 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=20
> 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=20
> 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=20
> http://lists.ximian.com/mailman/listinfo/mono-> list
>=20