Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET 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 August 29th, 2007, 04:36 AM
Registered User
 
Join Date: Aug 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default 2 DB_related Qs about VWD & SQLExpress

Dear sirs,

I'm developing a web form that gathers information from users. Using Visual Web Developer (V.W.D) and S.S.E, I encountered two problems.
Guide me please:

1. I can not add SqlCommand and SqlConnection .NET Framework components, to my toolbox. These are neutral to checking/unchecking their checkboxes in the "choose toolbox items" window. Other tools (non-System.Data. SqlClient components) have no problem. What is the matter?

2. When I try to insert data to the database trough internet explorer (web form in Cassini), an error occurs. I set up all SSE features (Database Services & Client Components) and I changed the SSE default setting (Enabling TCP/IP and Named pipes + Restarting the service). But it still shows this:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Source Error:
Line 27: objcommand.Parameters("@se").Value = RadioButtonList3.SelectedItem.Value
Line 28: objcommand.Parameters("@ch").Value = RadioButtonList4.SelectedItem.Value
Line 29: objconnection.Open()
Line 30: objcommand.ExecuteNonQuery()
Line 31: objconnection.Close()

Thanks a lot for your guidance





Similar Threads
Thread Thread Starter Forum Replies Last Post
Differences Between VWD Express & Standard SomeoneKnows BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 August 12th, 2007 09:58 PM
Qs! asadullah Java Basics 1 April 16th, 2007 11:35 PM
SQL Server error with VWD Expres & IIS bradnerdhss BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 January 30th, 2006 06:09 AM
Chapter 1: Building an ASP.NET Website Qs & As groupmatch BOOK: ASP.NET Website Programming Problem-Design-Solution 4 August 27th, 2004 08:57 AM





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