• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

Unable to connect to Northwind database

I am trying to connect to Northwind database through an VB.Net application with these settings:
       
        "Server=localhost;" & _
        "DataBase=Northwind;" & _
        "Integrated Security=SSPI"
The SQL sever is running on my machine, but I am still unable to connect. What is the problem?
0
fh2
Asked:
fh2
  • 9
  • 7
1 Solution
 
DotNetLover_BaanCommented:
Connection string:
"Server=localhost;DataBase=Northwind;uid=sa;pwd=";  

**Is "localhost" ur SqlServer name ? If not replace it with the actual SqlServer name.
0
 
Bob LearnedCommented:
What is the Authentication mode for the SQL Server?  Windows or Mixed?  Is this MSDE or Developer Edition?

Bob
0
 
Bob LearnedCommented:
Is there an error when you try to connect?  Is the SQL Server visible and running in the Server Explorer?

Bob
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
fh2Author Commented:
I don'nt know? Where can I look for that?
0
 
fh2Author Commented:
Yes, there is an error message and the SQL Server is visible and running in the Server Explorer.
0
 
Bob LearnedCommented:
If you have MSDE, then it will be very difficult since it doesn't come with any tools, like Enterprise Manager.

PRB: Cannot Connect to MSDE 2000 by Using ADO.NET with SQL Authentication
http://support.microsoft.com/default.aspx?scid=kb;EN-US;321698

Bob
0
 
Bob LearnedCommented:
It would help if you could give us the error message text.

Thanks,
Bob
0
 
fh2Author Commented:
This is the message:
"To run this sample, you must have SQL or MSDE with the Northwind database installed. For instructions on installing MSDE, view readme."
0
 
Bob LearnedCommented:
Now we are getting somewhere.  Do you have MSDE or SQL server installed?

Bob
0
 
Bob LearnedCommented:
Download Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

Bob
0
 
fh2Author Commented:
I have instlled SQL server and I tried to install MSDE by following these steps:

Access to the Northwind database residing in SQL Server or the Microsoft Data Engine (MSDE). To install MSDE, do the following:
1.Open the Start menu, click Programs, click Microsoft .NET Framework SDK, and then click Samples and Quickstart Tutorials.
2. Click Step 1: Install the .NET Framework Samples Database.
3. Open a command window, and CD to [FrameworkSDKInstallRoot]\Samples\Setup. This is typically C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Samples\Setup.
4. Type the following: osql -E -S (local)\NetSDK -i InstNwnd.sql.

I can't do step 3 because I can't CD to a folder with a long file name.
0
 
Bob LearnedCommented:
CD "C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Samples\Setup"

Bob
0
 
fh2Author Commented:
I got this error:
Parameter format not correct - "c:\Program
0
 
Bob LearnedCommented:
What is your OS?

Bob
0
 
Bob LearnedCommented:
BTW, I just got to looking at your profile, and that sure is a lot of B grades.  That doesn't show very much respect for people who are trying to help you.  It doesn't make someone really comfortable in trying to help another quite so easily.

Bob
0
 
fh2Author Commented:
Windows XP Professional Version 2002 SP1.
0
 
fh2Author Commented:
I give B to answers that in-directly help me solve the problem and A to the ones that answer a difficult question and directly solves the problem. BTW, are you a .Net expert or Profile expert?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 9
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now