Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 24th, 2009, 10:06 AM
Authorized User
 
Join Date: Jul 2009
Posts: 20
Thanks: 0
Thanked 1 Time in 1 Post
Default Connect SqlDataSource to SQLServer

Hi there,

I am trying to redeploy my website in ASP.NET which uses a SQLServer DB.

The DB exists on the server but when I try to connect to the SQLServer with a SqlDataSource I get the message that the DB was not found and the Named Pipes-Provider, error: 40. There is no server in the Server name list. I got the server running and TCP / pipes are enabled.

I appreciate your help
 
Old July 25th, 2009, 08:59 PM
Friend of Wrox
 
Join Date: Nov 2007
Posts: 207
Thanks: 2
Thanked 15 Times in 15 Posts
Default hmmm...

Is it on the same server as the web? or is it different? if it's the same you could just make the datasource=localhost and if it's on a different server make sure you have the name spelled correctly or try using the IP of the server (assuming it's static).
__________________
Jason Hall

Follow me on Twitter @jhall2013





Similar Threads
Thread Thread Starter Forum Replies Last Post
sqldatasource imjayakumar ASP.NET 2.0 Professional 3 May 21st, 2007 01:56 PM
sqldatasource imjayakumar ASP.NET 2.0 Professional 0 May 19th, 2007 02:58 AM
how to connect to sqlserver database file bhaveshsanghani BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 May 3rd, 2007 04:44 PM
SQLserver 2000 vs SQLserver 2005 Express cJeffreywang BOOK: Beginning ASP.NET 2.0 and Databases 0 April 22nd, 2007 09:52 AM
Connect Remote SQLServer Database krajdyal ADO.NET 1 December 21st, 2005 02:47 PM





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