February 2008
Intermediate to advanced
428 pages
8h 52m
English
Content preview from ASP.NET 3.5 For Dummies®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
6.1. Connecting to SQL Server Express
Data connections are easy on days when your biorhythms are running high. Fortunately, after you get a connection working, you can set it and forget it.
6.1.1. Checking whether SQLExpress is running
This section assumes that you installed SQL Server 2005 Express (SQLExpress) on your workstation. Installation is covered in Chapter 2.
Before you try connecting to SQL Server Express it helps to know whether the SQL software is running. Follow these steps to use a command line utility to check your system for a running instance of SQL Express:
Open a command prompt:
If you're using Windows XP, choose Start
Run; enter cmd and press Enter.If you're using Windows Vista, choose Start, enter cmd in the search box, and press Ctrl+Shift+Enter.
At the command prompt, type the following command:
sqlcmd -S(local)\SQLExpress
Press Enter.
If SQLExpress is running, the program responds with a prompt that looks like
1>
If SQLExpress isn't running, the program reports a connection error and quits.
Type exit and press Enter to exit the sqlcmd utility and then type exit and press Enter again to close the command line utility.
If SQLExpress shows no sign of life, rerun the VWD installer to repair it. If you know SQLExpress is installed but hasn't started, try the following command from the command prompt:
net start "SQL Server (SQLExpress)"
|
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.