Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > BOOK: Professional C#, 2nd and 3rd Editions
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional C#, 2nd and 3rd Editions
This is the forum to discuss the Wrox book Professional C#, 3rd Edition by Simon Robinson, Christian Nagel, Karli Watson, Jay Glynn, Morgan Skinner, Bill Evjen; ISBN: 9780764557590
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional C#, 2nd and 3rd Editions section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 11th, 2005, 10:18 PM
Registered User
 
Join Date: Apr 2005
Location: Toronto, , Canada.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to Northwind - HELP !!!

OK, I have installed MSDE. I used a very plain installation:

SETUP SAPWD="MySysAdminPW123"

My computer is part of a larger network but the SQL installation was local and will only be used locally. The "Services" listing under "Administrative Tools" (Windows XP-Pro) says that the service name is MSSQLSERVER. Fine. The little SQL Service Manager window says that the name of my server is JIMS-MOBILE. That is the name of my laptop on the network. I don't know why my SQL Server inherited that name but I don't care. I just want to get this working.

I want to connect to the Northwind database so that I can get on with the 2nd Edition book. Contrary to the claim in this book, installing .NET SDK did NOT install SQL server. It did not even install the Northwind database. I have Northwind because I have MS-Access.

So, I put Northwind.mdb into a directory called "C:\DataSets".

My understanding is that I must first set up a connection to this database file through SQL. Here come the questions:

Should this be a User DSN, System DSN, File DSN? What server name should I use? The drop down box offers 2 choices: "(local)" or "JIMS-MOBILE".

Win NT Authentication or SQL Server Authentication?

etc, etc, etc...

This 2nd edition book makes WAY too many assumptions about what the reader already knows about databases. I have tried every possible permutation of connection source string imaginable and all I get is 15 seconds of hang-time when it reaches the line:

conn.open() // On page 523.

Then I get an exception with unintelligable gibberish.

I just want to get on with this book which I have actually enjoyed up until now but I am getting ready to give up in abject dispare...

Thank you in advance to anybody who tries to help.
Eb


  #2 (permalink)  
Old July 31st, 2005, 03:50 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Eberly, did you ever get past this section? Just got here. Need to start figuring this out. .Net SDK 1.1 didnt install this for me, that I can see. Or if it did, need to figure this out.

  #3 (permalink)  
Old July 31st, 2005, 09:30 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Back from my bike ride. OK, looks like first step is to download MSDE 2000 Release A from Microsoft website.

  #4 (permalink)  
Old August 1st, 2005, 07:55 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

After dowloading MSDE2000A.exe, run it which extracts the MSDE 2000 setup files to C:\MSDERelA by default.

  #5 (permalink)  
Old August 1st, 2005, 07:56 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

from MS website:

open an MS-DOS command prompt and change to the directory where you extracted the files. MSDE extracts to C:\MSDERelA by default. Run the following command to set up MSDE for the .NET Framework SDK QuickStart tutorials. Replace with the systems administrator's password that you would like to use.

Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD>


  #6 (permalink)  
Old August 1st, 2005, 07:58 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Next go back to Microsoft website and search for the Northwind sample database and download it.

  #7 (permalink)  
Old August 1st, 2005, 08:00 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Run the install for the sample database which copies everything to a folder

c:\SQL Server 2000 Sample Databases

  #8 (permalink)  
Old August 2nd, 2005, 12:03 AM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Problem is now when I try and connect the database to the service it always says the service is not running. Yet when I goto control panel and check it says it is running.

  #9 (permalink)  
Old August 2nd, 2005, 12:06 AM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Tried runing the setup for MSDE several times, in different ways using what it said on MS site. Nothing worked.

So then I installed not specifying the INSTANCENAME and just let it use the default instance. This worked.

So tomorrow I am going to delete the other 2 instances I have running and get back to having one instance of MSDE, which is the default instance.

Then I will try and connect the database again. Report back tomorrow

  #10 (permalink)  
Old August 9th, 2005, 07:40 PM
Authorized User
 
Join Date: Jul 2005
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well so much for tomorrow. gone in a little vacation for a week.

Got the other 2 instances deleted. So only one instance of MSDE running and that is a default instance.

Then I was able to run the tool to connect the sample database to the server. This seemed to work w/o error. Need to do a little more checking. Instructions for connecting an existing DB are in the ReadMe_SQL2000SampleDbScripts.htm file in the folder where the sample database was installed.

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
northwind database terkilsen BOOK: Professional ASP.NET 2.0 and Special Edition; ISBN: 978-0-7645-7610-2; ISBN: 978-0-470-04178-9 2 April 3rd, 2006 08:55 AM
can't connect to Northwind baker_eliz C# 2 December 5th, 2004 06:29 PM
Northwind database iem BOOK: Professional Crystal Reports for VS.NET 8 August 1st, 2004 11:30 PM
connecting to Northwind in server explorer ssrs.netuser ASP.NET 1.0 and 1.1 Basics 3 November 16th, 2003 01:53 PM



All times are GMT -4. The time now is 04:13 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.