The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

import-bot (20211) [Avatar] Offline
#1
[Originally posted by chriskeith]

I've gone through all the examples up to page 81, but can't seem to find a
version of SQL Server on my machine (so I'm stuck just reading rather than
executing). Doesn't one come with the .NET development environment?
import-bot (20211) [Avatar] Offline
#2
Re: Getting a version of SQL Server?
[Originally posted by sjobak]

Just yesterday I also had problems trying to succeed with the pubscount
example, because of my lack of experience with all that SQL stuff. The Pubs
database that is used in the examples comes with the QuickStart tutorials
provided by Microsoft, so you need to install this database. Here's how:

First download and install MSDE from

http://msdn.microsoft.com/netframework/downloads/sdkmsde/default.aspx

Details on how to install the Pubs database can be found in

Csmilierogram FilesMicrosoft Visual Studio .NET
2003SDKv1.1SamplesSetuphtmlConfigDetails.htm

Hope this helps,

Peter
import-bot (20211) [Avatar] Offline
#3
Re: Getting a version of SQL Server?
[Originally posted by sjobak]

> Csmilierogram FilesMicrosoft Visual Studio .NET
> 2003SDKv1.1SamplesSetuphtmlConfigDetails.htm

Where did all the backslashes go? Ofcourse it should be:

C:/Program Files/Microsoft Visual Studio .NET
2003/SDK/v1.1/Samples/Setup/html/ConfigDetails.htm
import-bot (20211) [Avatar] Offline
#4
Re: Getting a version of SQL Server?
[Originally posted by pupczak]

> I've gone through all the examples up to page 81, but can't seem to find a
> version of SQL Server on my machine (so I'm stuck just reading rather than
> executing). Doesn't one come with the .NET development environment?

check out mySQL.org -- a scaled-down full featured SQL server for the "right
price" is available; we use it at work and I'm running it on my Win2k Pro
laptop (mySQL v2.23.x).
You have to replace the SQL namespace with ODBC, which also means setting up a
DSN ... so here's where to start:
1. download mySQL and do a little reading on it (it's all fairly painless)
2. grap an ODBC driver from mySQL and install it along with the DB
3. look for a nifty freeware but discontinued tool called "sqlFront" -- it's a
nice DB manager well fit for mySQL; download that and install it.
4. use the ODBC namespace instead of the SQL namespace in the .NET examples;
the classes are exactly the same.

I've also tried, but had no luck whatsover getting the OLEDB corner of that
area in .NET working with an available OLEDB driver for mySQL; the
installation goes well, it connects, but it fails on any actual access. Not so
with the ODBC stuff, it's working quite well.

Good luck!
cheers,
-PeteU.
import-bot (20211) [Avatar] Offline
#5
Re: Getting a version of SQL Server?
[Originally posted by chriskeith]

Peter Jakobs, thanks - it works fine. PeteU, thanks for the tip. I'll keep
it in my back pocket for later...

best regards,
Chris Keith
import-bot (20211) [Avatar] Offline
#6
Re: Getting a version of SQL Server?
[Originally posted by chriskeith]

Thanks for your suggestions, guys. I'll dig into them soon.