Wrox Programmer Forums
|
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio 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 December 10th, 2009, 07:11 PM
Authorized User
 
Join Date: Jul 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to brettdavis4
Default I keep getting db connection errors

I've downloaded the code in chapter 12 and I tried to set it up, but I keep running into a problem. I keep getting a database connection error. I've updated the connection string in the web.config, app.config, and in the setting sections. Are there are there any other locations that I am missing?
 
Old December 11th, 2009, 02:44 AM
Registered User
 
Join Date: Dec 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Just check the adderss

Hi,

When u gettin this kind of connection error , please do check the connection address of the database you using.
 
Old December 11th, 2009, 11:28 AM
Authorized User
 
Join Date: Jul 2003
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to brettdavis4
Default

Here is my connectionstring:
Data Source=machinename;Initial Catalog=HRPaidTimeOff;Integrated Security=True
(I've replaced the name of my computer with machinename)

When I test the connection string in Visual Studio it says it is fine.

I am still getting the following error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Any suggestions?

 
Old December 14th, 2009, 11:59 PM
Wrox Author
 
Join Date: Jan 2009
Posts: 73
Thanks: 0
Thanked 7 Times in 7 Posts
Default

do you have annoymous access turned off and integrated windows authentication turned on in the virtual directory?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access db/ Common Dialog/ errors in code azkabancells VB Databases Basics 1 May 25th, 2005 10:34 AM
Multiple-step OLE DB operation generated errors. rameshkumarm SQL Server DTS 1 August 28th, 2004 09:28 AM
DTS Scheduled Jobs Errors in DB (Misc) Walden SQL Server DTS 1 March 9th, 2004 08:13 AM
DTS Scheduled Jobs Errors in DB Walden SQL Server DTS 1 March 8th, 2004 11:55 AM
Errors Errors DB Errors Ljhopkins VS.NET 2002/2003 0 July 15th, 2003 12:42 PM





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