Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Microsoft SQL Server 2012 Programming
This is the forum to discuss the Wrox book Beginning Microsoft SQL Server 2012 Programming Paul Atkinson, Robert Vieira ; ISBN: 978-1-1181-0228-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Microsoft SQL Server 2012 Programming 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
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 26th, 2013, 12:58 PM
Authorized User
Points: 41, Level: 1
Points: 41, Level: 1 Points: 41, Level: 1 Points: 41, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2013
Location: Great Wet Northwest
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQLCMD, pg 405/406

Ok gang, looking at page 405/406 of the book (i.e. SQLCMD)
Tried the code on page 406 (since I'm using Windows authentication, blank password) and I get:

"Sqlcmd: Error: Microsoft SQL Server Native Client 11.0: Named Pipes Provider: Could not open a connection to SQL Server [2].."

along with Login timeout expired & A network-related or i....

Tried it will my user name and/or password anyway, same results

Ideas?.....sidejack
Reply With Quote
  #2 (permalink)  
Old April 29th, 2013, 04:36 PM
Authorized User
Points: 41, Level: 1
Points: 41, Level: 1 Points: 41, Level: 1 Points: 41, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2013
Location: Great Wet Northwest
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Talking Solved!

I can't take all the credit; I have a student smarter than I.

To run SQLCMD in the command line, one first needs to connect to the server, which in the example below is ORACLE-PC\SQLEXPRESS (case sensitive)

C:\SQLCMD -S ORACLE-PC\SQLEXPRESS <ENTER>
1>

At the 1> prompt, connect to the database (example uses Master) followed by GO

1>USE Master
2>GO
Changed database to 'Master'.
1>

Now one is ready to enter SELECT statements (use GO to execute)
Reply With Quote
Reply


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
Chapter 12, page 406 lansingmike BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 8 May 18th, 2011 03:58 PM
Ch12 pg 406-407 (Try it Out)access db within VWD martycom BOOK: Beginning ASP.NET 4 : in C# and VB 6 August 24th, 2010 04:37 PM
HTTP 405 error treasacrowe Classic ASP Basics 5 October 21st, 2004 03:43 AM
status 405: Method not found viges VB.NET 2002/2003 Basics 1 May 18th, 2004 12:53 PM



All times are GMT -4. The time now is 11:50 AM.


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