[Mono-list] Databind to SQLServer

[Jones, Larry]

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=F3:
> I have done so many different versions of this I get confused.  I =
had:

> <%@ 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,...) =20
> 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=20
> 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