SQL Server :: TCP Error When Connecting To SQL Server Via User Control

Feb 4, 2011

We have a MOSS 2007 custom web part based on a user control that queries a database cluster. When the connection to the database is made, we regularly experience the error below and have had to create a work-around in the code to retry the connection. We have 3 environments - development, staging and production; the error only occurs in production. The difference in the production environment is it is a farm with 3 WFEs and a SQL cluster, where development and staging are single machine instances. All are MOSS 2007 & SQL Server 2008. We cannot find what is causing this issue and I'm hoping someone else has experienced a similar problem and knows the cause.

This is the error that occurs frequently when the query is executed:
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at [Our Namespace.OurMethod](String someParam)

More than one method will generate this, but this is typical code, note the retry work-around:
public static DataTable OurMethod(string someParam) {
const string query = "sp_OurStoredProcedure";
var resultsTable = new DataTable();
var connection = new SqlConnection { ConnectionString = OurDatabaseConnection };
var command = new SqlCommand(query, connection) { CommandType = CommandType.StoredProcedure };
var dataAdapter = new SqlDataAdapter(command);
var retry = 5; SqlConnection.ClearPool(connection);
while (retry > 0) { try { command.Parameters.Clear();
command.Parameters.AddWithValue("@someParam", someParam);
connection.Open(); dataAdapter.Fill(resultsTable); retry = -1;
} catch (Exception ex) { retry--; if (retry <= 0) {
LogError("Exception: DataAccess:OurMethod: *RETRIES EXCEEDED* " + ex, "error");
} else { SqlConnection.ClearPool(connection);
LogError("Exception: DataAccess:OurMethod: ATTEMPTS REMAINING " + retry + ". " + ex, "warning");
} } finally { dataAdapter.Dispose(); command.Dispose(); connection.Dispose();
} } return resultsTable; }

View 5 Replies


Similar Messages:

DataSource Controls :: Error While Connecting To SQL Server?

Apr 1, 2010

When ever I try to connect to server through Microsoft sql server management studio express then an error is generated saying that

Cannot connect to .//SQLEXPRESS

Additional Information

A network related or instance specfic error occured while connecting to SQL server. The server not found or not accessible verify that instance name is correct and that SQL server is configured to allow remote connections.(Provider: Named Pipes Provider, error 40-could not open connection to SQL server )(Microsoft SQL server, Error:53)

View 5 Replies

Entity Framework - Connecting To Database In Server Control?

Aug 3, 2010

As a follow on from this question I'm building a custom server control to be placed on a Sharepoint 2010 master page. The idea behind this is that it will display a menu that is dynamically populated from the database. As this is a server control, I'm building it in a dll but I've run into a small snag. As it has to connect to the database, I need to store the connection string somewhere (and have it able to be configured based on target configuration (dev/test/prod). I was intending to the user the Entity Framework as my ORM but i'm confused as to where the connection string is to be stored. In a normal ASP.NET web app it goes in the web.config, but this is a server control in a external DLL.

Where do I store the connection string so that I can just build and deploy the assembly containing the server control.

EDIT:

Before I post a bounty, I have tried using an embedded resource XML file to hold the connection string and while this works, I'm curious as to if this is best practice/a better way?

View 2 Replies

DataSource Controls :: Connecting Sql Server / To Read The Windows User Account  Name And Pass In The Connection

Apr 6, 2010

I would like to do a connection of asp.net page with Sql Server. Here I would like to read the Windows user account name and pass in the connection.The connection should be Windows authentication. IIS server and Sql server are installed in different machine. Here I am able to connect locally, When I am running from server, It takes windows account of Server.

so i can read local account(Where user is accessing the web application) and make windows authentication sql server connection.

View 3 Replies

SQL Server :: Try To Log In To The Server Instance To Get An Error Log In Failed For User Xxx (error 18456)

Sep 12, 2010

I just installed sql server 2005 to my pc and when i try to log in to the server instance i get an error log in failed for user xxx (error 18456).I browse to the server instance and i keep getting the same error even though i chose windows authentication option during the installation.

I restarted the service for the sql server instance (which is running).The only problem i can think about is a problem with permissions but again there should not be any problem there because i logged in as administrator

View 3 Replies

DataSource Controls :: Connecting To SQL Server In Visual Studio 2008 Using Code - Error: 25 - Connection String Is Not Valid

Feb 2, 2010

Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.

Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:

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: SQL Network Interfaces, error: 25 - Connection string is not valid)

However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.

View 2 Replies

DataSource Controls :: Error Accessing SQL Server Db From User Control In SharePoint

Jan 15, 2010

I'm developing an ASP.NET user control in VS2008 that writes to a SQL Server 2005 database. I've published the control to a SharePoint 2007 MOSS page using the SmartPart addon. The control consists of a few text fields and a submit button that writes the contents of the text fields to the database. When I test the control in the Visual Studio debugger, it works fine. When I try to submit data from the SharePoint page, I get the error shown at the end of this post. Last time I saw this, it was a database permissions error, but I've granted my site's default application pool read/write access to my database. Does anyone have any idea what else the problem might be? Also, how can I double-check the credentials that the SharePoint page is using to access the database, since I still suspect that this is a permissions issue?

[ERROR TEXT FOLLOWS]
Server Error in '/' Application.

Object reference not set to an instance of an object.

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.NullReferenceException: Object reference not set to an instance of an object.

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
ConnectionHandler.ClientDataConnect() +103
ClientData.ClientData.Page_Load(Object sender, EventArgs e) +1426
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +24
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +41
System.Web.UI.Control.OnLoad(EventArgs e) +131
System.Web.UI.Control.LoadRecursive() +65
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2427
Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

View 2 Replies

C# - Connecting To A Linux Server Running Myql From A Windows .net Server, Ado.net?

Aug 19, 2010

Can I connect to a ubuntu server, that is running mysql using ado.net or do I need a special driver?

View 2 Replies

Does A Composite Server Control(inc. User Control, Custom Server Control) Normally Encapsulate Css Properties?

Nov 7, 2010

If a composite server control normally encapsulate styling information inside, it is an example of code encapsulation and modularization. However if css properties are included inside the composite control, it is not ideal for code/styling separation and css code re-use principles. Now which consideration should be the main consideration?

View 2 Replies

SQL Server :: Login Error To Connect User "IIS [App Pool User]" To SQL Server

Sep 16, 2010

When I connect to my SQL Server from a ASP.NET application I get a error like Error to connect user 'IIS [App Pool User]' to SQL Server. It's easy to give permitions to that user, but I want the SQL Server to be logged on with the ASP.NET page User Login and not da Application Pool User. It is. if the user DomainUser1 gets logged in. All the SQL Transactions made by DomainUser1.

View 3 Replies

C# - Receive Error 'Unknown Server Tag' With Page.ParseControl On A Custom Server Control

Aug 4, 2010

I'm building a dynamic form using XML and XSLT. Anyway I'm using a custom asp.net control for CKEditor, it's an HTML editor.

When I try to add the controls from the XSLT using Page.ParseControl(<the-string-from-the-xslt-here>), I get a warning saying:

Unknown server tag 'FCKeditor.CKEditor'

And of course, if I remove the control from the XSLT everything is working fine and all the regular asp.net controls like TextBox etc get rendered to the string just fine. Does anyone know what I can do about it?

View 2 Replies

Server Controls In User Control Are Null When User Control Serves As A Base User Control ?

Jun 4, 2010

I don't think I understand fully how ASP.NET does inheritance of controls.I have a user control, ucBase, which has an asp.net label in the ascx file. Code behind references the label and it works fine during run time if the control is not a parent for another user parent.

If I have another user control, ucChild, inheriting from ucBase, the label in ucBase's code is always null. ucChild has no controls in its ascx fileThe server controls (like the label) needs to be declared in the ascx file and not created programmatically.What needs to be done for ucBase to see its own controls when it's a parent user control?

View 1 Replies

User/server Control With Custom List Items / Create A Simple Menu User Control

Feb 18, 2011

I'm attempting to create a simple menu user control just as outlined here.

The attached code results in an "Object reference not set to an instance of an object" error, but I can't figure out why.

<%@ Master Language="VB" CodeFile="MySite.master.vb" Inherits="MySite" %>
<%@ Register src="Controls/Menu.ascx" tagname="Menu" tagprefix="my" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">......

View 1 Replies

SQL Server :: Connection To Sql Server / Error "A Network-related Or Instance-specific Error Occurred While Establishing A Connection To SQL Server

Nov 23, 2010

I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,

I get this 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) "

The connection string that I used in my web.config file is

[Code]....

I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.

View 10 Replies

Custom Server Controls :: Unable To Use A Web User Control Inside Another Web User Control

Mar 10, 2011

I have a web user control that represents a simple message box. It is used to display simple messages like "Item has been deleted", or "The item was saved successfully".

On the other hand, I have another web user control that represents the item in the form of an editable form (I made this a user control because this is used in two different pages). I want to embed an instance of the message box user control inside the editable form. I am writing this right after the @Control directive:

[Code]....

Instead of using @Register directives, I register the user controls in web.config and so far this has worked just fine.

With the above markup, the project compiles, but whenever I try to navigate to a page that contains this construct, I get an HttpParseException exception. Furthermore, Visual Studio states that the tack w7rc9:MessageBox doesn't represent a known control.

What am I doing wrong?

View 2 Replies

Custom Server Controls :: Require Video Tutorial For Composite Server Control And Rendered Server Control?

Aug 20, 2010

according to what i read from web there 3 types of custom server controls

1. composite

2.superclass

3.rendered

i found video tutorial to create and use superclass custom control in your project (extending dropdown control functionality)

i am trying to search video tutorial for other 2 types .

View 1 Replies

User Controls :: Microsoft SQL Server 2008 R2 Error 18456 - Login Failed For User Sa

Nov 21, 2012

Microsoft sql server error 18456 in sql server 2008 r2login failed for user   sasql server was working properlyi just restarted the system and then i started getting the above errorhow do i resolve iti am able to login with windows authentication but not sql authentication....

View 1 Replies

Custom Server Controls :: How To Create A Server Control With A Listbox And Dynamic Control Using Server Control

Oct 12, 2010

I need to create a reusable custom control,which is like a form containing a listbox and some fields.The fields can be either textbox or combobox as needed for different applications,which can be selected on the property of the form onwhich page that i am using it,also i needed to specify the number of fields in that property.And also need place 3 buttons below for edit and delete the selected item in the listbox and a button to save.Data will be binded from the database as needed for different applications.

tell me with code how to create it using asp.net server control in C#.

View 6 Replies

Custom Server Controls :: User Template Control Or Custom Server Control?

Jul 22, 2010

I need to develop control (template or user) which must have subtags with some items.

For example :

<SomeControl runat="server" id="scTest">
<column1>TestColumn1</column1>
<column1>TestColumn1</column1>
<column1>TestColumn1</column1>
</SomeControl>

This control may contain some other web server controls such as GridView.I need explanation of experienced developers, how to do that - take me to the right way

View 3 Replies

Connecting To Sql Server 2008?

Mar 6, 2010

I have developed a web application in asp.net with C# in visual Studio 2005. And i used sql server 2008 as back end. When i run the program, it shows the following error..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)

View 2 Replies

Connecting To Sql-server Db Via Access

Feb 20, 2011

or one of my project, I use Access 2007.I have application written by Access, that use database : Sql-Server 2007.I am using XP for the any company computer.The dsn file is on network, and include connectionString with username + password,ut I want to access the database from any user with automatic authentication (no need for user and password).

View 3 Replies

ASP.NET: Connecting To A Sql Server Database?

Jul 25, 2010

how do i connect visual web developer to sql server express 2008? in the Database Explorer, i right click on Data Connections, click Add Connection..., and in the Data source box i choose Microsoft SQL Server (sqlClient), which i'm guessing doesn't connect me to a database file, but to sql server express itself(?). in the server name box when i click the drop down box, there's nothing there and that's where i get stuck.

View 3 Replies

.net - Connecting To Exchange Server?

Jan 14, 2011

I am using this code to connect to my exchange server using POP3.I am trying to retrieve an inbox of basically emails that have not been read however, i am just getting a bunch of gibberish and its reading an email. modify my code to just read the most recent messages.

Try
tcpClient.Connect(hostName, 110)
Dim networkStream As NetworkStream = tcpClient.GetStream()[code]...

when i use top instead of retr i get this

+OK X-MimeOLE: Produced By Microsoft Exchange V6.5 Received: by xch0p.com id <01CB58CE.A6A4EA@p.com>; Mon, 20 Sep 2010 09:17:07 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CB58CE.81A6A4EA" Content-class: urn:content-classes:message Subject: What we need to do?? Date: Mon, 20 Sep 2010 09:17:07 -0500 Message-ID:

View 3 Replies

VS 2005 - Connecting To SQL Server

Aug 5, 2011

Can you connect to a SQL Server in ASP.NET? If so how?

View 2 Replies

Website Opening From Server Produces Error/The Web Server Does Not Appear To Have FrontPage Server Extensions Installed

Mar 7, 2011

I have a site that is running on a Windows Server 2008 machine with IIS 7.0, when I try to open it with Visual Web Developer 2010, it says the following:

error: unable to open site: ... The Web server does not appear to have FrontPage Server Extensions installed.

Looking on the server Frontpage Extensions 2002 are installed, so what could be wrong?

The thing is, I used to be able to open the project and work on it, etc...

Open Website -> Remote Site -> Enter remote site name -> tries to open & error above!

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved