A transport-level error has occurred when sending the request to the server

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Setting provider specific value - flushing MSAccess I have searched far too long for an answer to this riddle...and I know it's probably right in front of me. I have found articles using older versions of ADO that set Jet specific properties on the ADO connection object. In ADO.NET 2.0 the Connection does not have a Properties collection where I can set a key/value setting that is specific to the provider. Where is the equivalent in ADO.NET 2? Specifically I am trying what the articles call the "Jet OLEDB:Flush Transaction Timeout" as a way to disable the asynchronous "lazy write" that the Jet engine does by default. Kudos in advance to anyone that knows the answer. Dennis Tag: A transport-level error has occurred when sending the request to the server Tag: 136740
  - 2
    - SqlDataSource with multiple data tables I'm attempting to work with SqlDataSource to pull values from a database and populate a form, which by itself is no problem. However, I'm trying to visualize how to also iterate through values on a joined table. My situation is that there is a form representing a Rule filled out mostly from values contained in one table, but that form also contains a ListBox that allows multiple selection which represents the locations this rule applies to. The rule can be applied to any, all or zero locations. I'd like to set this up such that when a Rule is retrieved, the Locations are retrieved in the same query (I know I can accomplish this with 2 separate SqlDataSources), and all values are populated at once. The problem I have is that a JOIN seems to just repeat the form data across all rows, when I really only need the Location ID. If I execute two SELECT statements within a single SqlDataSource without any relationships defined with the query, can I access both the returned tables and create those relationships in the code? I don't need the SqlDataSource's INSERT, UPDATE or DELETE commands for this function, as the work required for those is a bit more than can be handled automatically. But I would like to get this part working with minimal trips to the database, since it just seems unnecessary to execute these two queries independently. What is the best option for doing this? Revert back to DataSet's ability to store and retrieve multiple tables and the ability to create DataRelations? Thanks very much for your time. Simon Cartin Tag: A transport-level error has occurred when sending the request to the server Tag: 136727
  - 3
    - Call SqlCommand.ExecuteReader inside another SqlCommand.ExecuteRea Hi; I need to call SqlCommand.ExecuteReader and then inside a while (reader.Read()) I need to call another SqlCommand.ExecuteReader. I need to do this because I have a FK:PK relationship and based on the FK read, then read the row in that related table - if the FK is not null. How can I do this? -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm Tag: A transport-level error has occurred when sending the request to the server Tag: 136726
  - 4
    - VB Executable Finding Access Database When Shipped I've seen several posts in the archives regarding making your VB .NET application have a relative path connection string to an Access DB, but do not see a definite resolution to the matter. Here's what I'm trying to resolve: My VB 2003 .NET application connects and works just fine with an Access database located at c:\data.mdb. Now, I use a wizard for making an installer for my application and it places the data.mdb file in the installation directory without any problems. However, I'm always going to have a runtime error unless the data.mdb file is at c:\. I have to believe this issue has come up before and a pro can easily shed some light on how I can perhaps use a relative path in my connection string rather than an absolute. I sure appreciate the help. -Dan Tag: A transport-level error has occurred when sending the request to the server Tag: 136719
  - 5
    - New Dot Net discussion forum Hi all Thanks to all of you for a good response on my site www.xcessdotnet.com/dotnetforum last 10 days there has been 12 new members and 45 new posts.. I wanted to contribute something to the dot net community and for this I set up this forum.. I welcome your suggestions and contribution to make my efforts successfull Regards Chris Tag: A transport-level error has occurred when sending the request to the server Tag: 136702
  - 6
    - Get deleted rows from a datatable Hi all, I've a DataTable, and from my UI a such user deletes one or more rows from it, I wish to get the deleted rows from the DataTable. I have to perform a loop trough the deleted rows and invoke the Row.Accept changes method, but if I try something like this: dim rX as DataRow For Each rX in MyTable.Rows If rX.RowState=RowState.Deleted Then rX.AcceptChanges End If Next I get an execption: the collection is changed. When I invoke rX.AccepChanges method of a deleted rows, the row is removed from the .Rows collection of the datatable and the loop I'm performing fails. Tag: A transport-level error has occurred when sending the request to the server Tag: 136697
  - 7
    - Transaction Hi, I am using transaction object with this code: connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; // Start a local transaction. transaction = connection.BeginTransaction("SampleTransaction"); // Must assign both transaction object and connection // to Command object for a pending local transaction command.Connection = connection; command.Transaction = transaction; // CallMehtod1( command); //- executing query 1 with command.ExecuteNonQuery(); // CallMehtod 2(command);//- executing query 2 with command.ExecuteNonQuery(); transaction.Commit(); My question is it possible to execute different queries with different method calls , and after commit the transaction like in the sample, rather than execute the queries in the same method within the transaction, will this transaction work well ? Leeor Tag: A transport-level error has occurred when sending the request to the server Tag: 136692
  - 8
    - Convert Big5/GB code into iso-8859-1 into database through ADO.Net i am writing a function that can convert Big5/GB code into iso-8859-1 into database through ADO.Net in c# My database SQL server2005 if i write that string Value =3D Encoding.GetEncoding("iso-8859-1").GetString(Encoding.GetEncoding("big5").G= etBytes("=A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1=B3=F8=A7i")); =A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1=B3=F8=A7i <~ is the chinese input stri= ng in my db, i use the NJStar, i can see what the chinese input string i type but when i want to convert the gb to iso-8859-1 string Value =3D Encoding.GetEncoding("iso-8859-1").GetString(Encoding.GetEncoding("gb2312")= .GetBytes("=A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1=B3=F8=A7i")); some character cannot display out.. i donno why? can anyone help me? thx in addition, i try to convert the big5 to iso-8859-1 and then convert it back to big5, for english string, i can see write i type before, but for chinese, i cannot see what i type: File.WriteAllBytes(@"C:\abcde.html", Encoding.Convert(Encoding.GetEncoding("iso-8859-1"), Encoding.GetEncoding("big5"), Encoding.Convert(Encoding.GetEncoding("big5"), Encoding.GetEncoding("iso-8859-1"), Encoding.GetEncoding("big5").GetBytes("=A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1= =B3=F8=A7iabc")))); if anyone have any suggestion, i will very thx for u Tag: A transport-level error has occurred when sending the request to the server Tag: 136691
  - 9
    - Connection state open even without a server or database? I test for a connection when I load a particular form, so as to prevent other more ghastly exceptions further into the logic. However, I've noticed that even with NO viable connection string, the connection object state shows open. Anyone see something I'm overlooking here? Here is the code: Dim strSQLServer As New SqlConnection(strConn) strSQLServer.Open() Debug.WriteLine(strConn.ToString()) Debug.WriteLine(strSQLServer.State.ToString()) Here is the output: data source=;initial catalog=;integrated security=SSPI; Open Tag: A transport-level error has occurred when sending the request to the server Tag: 136682
  - 10
    - DataTable/DataSet extention Hi, Im using the VisualStudio 2005 designer to create typedDataSet (drag & drop from the service explorer). All the DataTables in the generated code inherit from System.Data.DataTable, I would like the dataTables to inherit from MyDataTable (a custom DataTable) instead. How can I do that without manually editing the generated code? Tag: A transport-level error has occurred when sending the request to the server Tag: 136662
  - 11
    - Using ExecuteScalar on ,Net Framework 1.1 This is a multi-part message in MIME format. ------=_NextPart_000_00C5_01C73ED8.A6B50E10 Content-Type: text/plain; charset="iso-8859-8-i" Content-Transfer-Encoding: quoted-printable I am using ExecuteScalar, executing a stored procedure with two = commands: the first command is Select command,=20 and the second is Insert. Because of the Select command , The ExecuteScalar do not return an error = in case of the Insert(second command -see the stored pro. sample in the = bottom) failure. the stored procedure: CREATE PROCEDURE dbo.usp_UpdateOnline @Id as bigint, @source_file as nvarchar(50), AS declare @IsUpdate as int EXEC @IsUpdate =3D mysp_IsIDExist @Id SELECT @IsUpdate --From this point no error is returned to Execue Scalar INSERT=20 INTO online.dbo.T_all (Id, source_file , ) VALUES ( @Id ,@source_file ) GO please help Leeor ------=_NextPart_000_00C5_01C73ED8.A6B50E10 Content-Type: text/html; charset="iso-8859-8-i" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML dir=3Drtl><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-8-i"> <META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY dir=3Dltr> <DIV><FONT face=3DArial size=3D2>I am using ExecuteScalar, executing a = stored=20 procedure with two commands:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>the first command is = <STRONG>Select</STRONG>=20 command, </FONT></DIV> <DIV><FONT face=3DArial size=3D2>and the second is=20 <STRONG>Insert</STRONG>.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Because of = the <STRONG>Select</STRONG> command=20 , The ExecuteScalar do not return an error in case of the=20 <STRONG>Insert(second command -see the stored pro. sample in the=20 bottom)</STRONG> failure.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>the stored procedure:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>CREATE PROCEDURE =20 dbo.usp_UpdateOnline</FONT></DIV> <DIV><FONT face=3DArial size=3D2>@Id as bigint,<BR>@source_file as=20 nvarchar(50),</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>AS<BR>declare @IsUpdate as int<BR>EXEC = @IsUpdate =3D=20 mysp_IsIDExist @Id</FONT></DIV> <DIV><FONT face=3DArial size=3D2>SELECT @IsUpdate</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><STRONG>--From this point no error is = returned to=20 Execue Scalar<BR></STRONG>INSERT <BR> INTO = online.dbo.T_all<BR> =20 (Id,<BR>   source_file ,<BR>  )</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2> VALUES<BR> (  = @Id<BR>  =20 ,@source_file<BR>  )</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>GO<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>please help</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Leeor</DIV></FONT></BODY></HTML> ------=_NextPart_000_00C5_01C73ED8.A6B50E10-- Tag: A transport-level error has occurred when sending the request to the server Tag: 136654
  - 12
    - Help with INSERT statement. Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without any error in SQL View. What is the easiest way to execute this querie in ado.net/vb.net? Thanks Tag: A transport-level error has occurred when sending the request to the server Tag: 136650
  - 13
    - Help with INSERT statement. Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without any error in SQL View. What is the easiest way to execute this querie in ado.net/vb.net? Thanks Tag: A transport-level error has occurred when sending the request to the server Tag: 136649
  - 14
    - Stored Proc Params in TableAdapter In VS 2005, when configuring a table adapter to use stored procedures for Inserts, Updates, and Deletes, it appears you can only map each parameter to a column in the Select procedure's result set. Is it possible to specify a literal value for some of the parameters instead? Or would it be necessary to add the literal value to the result set of the Select procedure? Tag: A transport-level error has occurred when sending the request to the server Tag: 136647
  - 15
    - Update/insert one table from another Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without any need for datadatpters etc. What is the easiest way to execute these two queries in ado.net/vb.net? Thanks Tag: A transport-level error has occurred when sending the request to the server Tag: 136642
  - 16
    - MS SQL 2005 Configuration ??? Greetings, I'm fairly new to ASP.NET/ADO.NET and SQL. I worked out a few issues with the help of some nice folks here. Now, I'm starting a clean Web site project but am having trouble right off again. I'm trying to create a new database using MS SQL Server 2005. I entered localhost as the Server name, selected Use Windows Authentication, and entered a new name for my database. When I click OK, I get the following error: Microsoft Visual Studio 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) As far as I know, localhost does not indicate a remote connection. I eventually connected to a database previously with SQL Express Edition, so I'm guessing this might have to do with my SQL configuration. I'm using Visual Studio 2005 on a new C#/ASP.NET project. I'm running Windows XP Professional w/SP2. Sorry, but virtually every suggestion I get will probably need to include instructions on how to do--I'm quite new to this. Any help greatly appreciated! -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: A transport-level error has occurred when sending the request to the server Tag: 136641
  - 17
    - Leftover Connections in Connection Pool (connection leak) This never happened before in .NET Framework 1.0 nor .NET Framework 1.1, but connection leak happens if you don't close the connection when you use SqlTransaction. I would like to share this information with the MS dev community. We had this issue of SQL Server performing very poorly while running our application. My colleague found out that connection leak was happening whenever the .NET code executed transactions. So I created a small console program that does a transaction like the following. Imports System.Data Imports System.Data.SqlClient Module Module1 Sub Main() Begin: Dim Conn As SqlConnection = GetConnection() Conn.Open() Dim Trans As SqlTransaction = Conn.BeginTransaction(IsolationLevel.ReadUncommitted) Dim Cmd As New SqlCommand("tblTest_ins", Trans.Connection, Trans) Cmd.CommandType = CommandType.StoredProcedure For i As Integer = 1 To 50 Console.WriteLine("Executing stored proc. (" & i.ToString() & ")") Dim parTestCol As New SqlParameter() With parTestCol .ParameterName = "@TestCol" .Direction = ParameterDirection.Input .SqlDbType = SqlDbType.NVarChar .Size = 50 .SqlValue = "TestValue " & DateTime.Now.ToString() End With Cmd.Parameters.Add(parTestCol) Cmd.ExecuteNonQuery() Cmd.Parameters.Clear() Next Trans.Commit() Console.WriteLine("Execution Completed") Dim Entry As ConsoleKeyInfo = Console.ReadKey() If Entry.Key = ConsoleKey.Y Then GoTo Begin Else Return End If End Sub Private Function GetConnection() As System.Data.SqlClient.SqlConnection Dim Conn As New SqlConnection("server=(local);database=Test;Pooling=true;user id=sa;password=whatever;Application Name=HelloConnPool;connection reset=true;") Return Conn End Function End Module I ran this code many times, and connection leak was happening. So I added Conn.Close() right after Trans.Commit(), then the leak was gone. Well, I could have done Trans.Connection.Close(), but the thing was that right after the transaction was committed, Connection property was null. So as we have a data layer that doesn't expose the underlying connection, we had to define a variable as SqlConnection and hold onto the reference to the connection from the transaction and the close it after commit. I hope I explained this issue well, but this never happened in .NET Framework 1.1. We converted our code from 1.1 to 2.0, and didn't change a thing, but this issue came out. I hope this will help people who experience the same kind of issue. If you have any question, please just post it here. Tag: A transport-level error has occurred when sending the request to the server Tag: 136640
  - 18
    - Queries to an Access db from vs2005 Hello, I just have a form in which there's a textbox for queries. I need to use the SQL statements for an Access db, like this, which works fine in a SQL db: SELECT * FROM table WHERE name LIKE @name + '%' I just need to query the db to find names that start with letters I digit in the textbox. This query comes from dataset designer. If I use it in my Access db I get a syntax error from framework. Which is the Access equivalent? Thanks. Max Tag: A transport-level error has occurred when sending the request to the server Tag: 136634
  - 19
    - Append Room numbers fields by Building Hello, I have a table as follows- BUILDING ROOM_NUMBER MAIN 100 MAIN 101 MAIN 102 SUB 200 SUB 202 The Resultset should be as follows- BUILDING SUMMARY_ROOMNUMBE MAIN 100,101,102 SUB 200,202 I know I need to use the group by clause but I dont know how to append the summary room number. Any help would be greatly appreaciated. Thanks. -jay Tag: A transport-level error has occurred when sending the request to the server Tag: 136633
  - 20
    - Timeout error when inserting and reading from same table in sql server and .net Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\ExeTest.exe' I am calling the ExeTest.exe program which is supposed to read from the same table again and just display first. I am having a similar problem as this guy below( i.e updating and reading the same table. But there is no solution) http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/60921b45f9dc00e4/0494ca46ee4147bb?lnk=st&q=sql+server+.net+timeout+expired+sqldatareader&rnum=1#0494ca46ee4147bb Is there a way that I can achieve this? Even if it is long, I do not mind as long as there is no timeout. I have set the timeout to 5 minutes plus, and still got a timeout error. It seems the table is locked and cannot be selected from??? If you still reading, here is my code in the ExeTest.exe :) Sub Main() Dim sqlstring As String = "select * from tester" 'Dim connString1 As String = "Data Source=servername;Database=ProjectServer;UID=sa;pwd=pwd" Dim connString1 As String = "Data Source=localhost;Database=ProjectServer;Integrated Security=true" Dim conn As New SqlConnection conn = New SqlConnection(connString1) Try conn.Open() Dim cmd As New SqlCommand(sqlstring, conn) cmd.CommandTimeout = 40 Dim listA As SqlDataReader = cmd.ExecuteReader() While listA.Read Console.WriteLine(listA(1)) End While 'End If listA.Close() conn.Close() Catch ex As Exception Console.WriteLine("error : " + ex.Message) End Try End Sub Regards, Omar Tag: A transport-level error has occurred when sending the request to the server Tag: 136628
  - 21
    - Timeout when reading and updating / inserting to same table Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\ExeTest.exe' I am calling the ExeTest.exe program which is supposed to read from the same table again and just display first. I am having a similar problem as this guy below( i.e updating and reading the same table. But there is no solution) http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/60921b45f9dc00e4/0494ca46ee4147bb?lnk=st&q=sql+server+.net+timeout+expired+sqldatareader&rnum=1#0494ca46ee4147bb Is there a way that I can achieve this? Even if it is long, I do not mind as long as there is no timeout. I have set the timeout to 5 minutes plus, and still got a timeout error. It seems the table is locked and cannot be selected from??? If you still reading, here is my code in the ExeTest.exe :) Sub Main() Dim sqlstring As String = "select * from tester" 'Dim connString1 As String = "Data Source=jktgrhxsapps1;Database=ProjectServer;UID=sa;pwd=ProjectServer" Dim connString1 As String = "Data Source=localhost;Database=ProjectServer;Integrated Security=true" Dim conn As New SqlConnection conn = New SqlConnection(connString1) Try conn.Open() Dim cmd As New SqlCommand(sqlstring, conn) cmd.CommandTimeout = 40 Dim listA As SqlDataReader = cmd.ExecuteReader() While listA.Read Console.WriteLine(listA(1)) End While 'End If listA.Close() conn.Close() Catch ex As Exception Console.WriteLine("error : " + ex.Message) End Try End Sub Regards, Omar Tag: A transport-level error has occurred when sending the request to the server Tag: 136627
  - 22
    - DateTime Filter Expression Hi, is there anyway of selecting rows with a particular date but ignoring the time within a date time column? something like... DataTable.Select("DateTimeColumn".Date = '28/12/06') ? thanks in advance for any advice. Sharat Koya Tag: A transport-level error has occurred when sending the request to the server Tag: 136617
  - 23
    - Adding new object to Typed Data Set and return the primary key Hi, I have started using Typed Data Sets with VS2005 and so far so good, however I am having a problem with adding a row to a data table and returning the new Primary Key value. My data set has been auto generated from a DB table and has an auto generated Primary Key for the ID field. I create the row using ProjectsDataTable.NewProjectsRow() However the code that returns this Project Row does not persist the data table as it is a method on my singleton object. Once the new row has been populated with data I call an update method on the singleton which then creates a new table adapter. My problem is how to add this orphaned row to the database and return the Primary Key that the database creates for it. I have tried many of the different methods that are created by default in the TypedDataSet however so far the only one that works is the TableAdapter.Insert() method and this does not return the primary key. Method 1: DataAdapter.Update(myProjectRow) // fails I guess because the row has no connected DataTable Method 2: newDataTable = DataAdapter.GetData(); // returns eg a data table containing 4 rows. newDataTable.ImportRow(myRow); // data table still contains 4 rows no error generated. DataAdapter.Update(newDataTable); // does nothing as there is nothing to update Please does anyone have any insight into this or do i have to go back to the good old way of manually executing the SQL or dumping my data singleton and manually creating and persisting the data table for the form that creates the new project ? Another strange thing is that the if i return a project from the singleton (which does not persist the data table) then call the same update method ( on the singleton which creates a new data adapter) the updates are commited. Is something strange with the primary key going on ? Sudo Code Snippet: public class DataObject { private static DataObject this_Data; public static DataObject getInstance() { if (this_Data == null) this_Data = new Data(); return this_Data; } public TypedDataObjectProject newProject() { Projects.ProjectsDataTable db_ProjectsTable; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_TableAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectsTable2 = db_TableAdapter.GetData(); return db_ProjectsTable2.NewProjectsRow(); } public TypedDataObjectProject getProject() { Projects.ProjectsRow db_Project; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectTable2 = db_ProjectAdapter.GetData(); db_ProjectAdapter.Dispose(); return db_ProjectTable2[0]; } public int updateProject(Projects.ProjectsRow Project) { int int_Return = 0; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); db_ProjectAdapter.Update(Project); db_ProjectAdapter.Dispose(); } } This works: ob_Prog = DataObject.getInstance().getProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); This Fails not with error but no new row is added: ob_Prog = DataObject.getInstance().newProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); Many thanks in advance for you help. Nic Tag: A transport-level error has occurred when sending the request to the server Tag: 136616
  - 24
    - Why can't the .NET Datagrid show datetime columns with time ? Hi, I am using .NET Framework 1.1 and VS.NET 2003 I am pulling a recordset from an ORACLE database into a Windows Forms form and displaying the data in a datagrid.. Trouble is, even though the data includes datetime fields, the datagrid absolutely refuses to display them at runtime in proper datetime format (just shows . I know the time information is there because I can export to csv and the time is in each field. I even got some code from Kelly in another thread to force datetime fields to be formatted properly like this: >>> CODE >>> Public Shared Sub Format(ByRef grd As DataGrid, ByRef dt As DataTable) Dim ts As New DataGridTableStyle() Dim tc As DataGridTextBoxColumn Dim dc As DataColumn For Each dc In dt.Columns tc = New DataGridTextBoxColumn() tc.MappingName = dc.ColumnName tc.HeaderText = tc.MappingName If dc.DataType Is GetType(System.DateTime) Then tc.Format = "MM/dd/yyyy hh:mm:ss" tc.Width = 125 End If ts.GridColumnStyles.Add(tc) Next grd.TableStyles.Clear() grd.TableStyles.Add(ts) grd.DataSource = Nothing grd.DataSource = dt <<< END CODE <<< Now, when I run this, several fields are identified as system.datetime and these get the special format. But nothing happens in the datagrid. Is there anything else I can do to show the time with the dates? thanks for any help or assistance Philip Tag: A transport-level error has occurred when sending the request to the server Tag: 136611
  - 25
    - MSAccess DB and DataSets - help Hi, I have VS.net 2005 express and I have created a new project. I made a new folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily went and created a DataSet class for me (MaintenanceDataSet). My question is: How do I load the data from the Access DB so I can access it from the application? Thank you in advance. Tag: A transport-level error has occurred when sending the request to the server Tag: 136598
- Next
  - 1
    - Unicode and long data type I have an application where a limited amount of Unicode data is being inserted into a long data type field by an AIX program. I have written a dotnet program that copies the data from one domain to another with parameterized data. Everything works except for the Unicode data in the long field. My Characterset info is: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 Regional Settings are English (United States) A basic default U.S. installation of Windows. I do not have much control over the database. I have read that long data types do not support Unicode. Is there anyway I can insert Unicode data into a long data type from a dotnet program? Tag: A transport-level error has occurred when sending the request to the server Tag: 136595
  - 2
    - dataset question Hi I am a newbie in ado.net 2005. Is it possible to do a Group By in a dataset? thanks E. Tag: A transport-level error has occurred when sending the request to the server Tag: 136592
  - 3
    - Why can't I get the FormView control's Paging controls to show? I have tried everything I can think of, I have even tried copying examples from books and websites I have found, but every Formview control that I have tried to create does not show the Paging controls. The first record from the DataSource is displayed, but not the Paging controls. I have tried doing it with both automatically generated Paging controls as well as using the PagerTemplate, but neither one is displayed. What is the problem? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: A transport-level error has occurred when sending the request to the server Tag: 136591
  - 4
    - Reader ordinal problem Hi I am getting the System.IndexOutOfRangeException was unhandled error on the last line of below code; Cmd = New OleDb.OleDbCommand("SELECT [Last Staff Update From Site] FROM [Update Control]", LocalConn) Reader = Cmd.ExecuteReader() Console.WriteLine("{0}", Reader.GetOrdinal("[Last Staff Update From Site]")) What is the problem and how can I fix it? Thanks Regards Tag: A transport-level error has occurred when sending the request to the server Tag: 136588
  - 5
    - 36 Microsoft Certification Tutorials and Free Practice Exams 36 Microsoft Certification Tutorials and Free Practice Exams For complete Microsoft Certifications ebooks go to http://free-tech-ebooks.blogspot.com/search/label/Microsoft%20Certifications All the best !! Tag: A transport-level error has occurred when sending the request to the server Tag: 136582
  - 6
    - Have alternative to CommandDataBuilder? I realize that Microsoft not intend to fix problems of Commandbuilder: +not deal with SQL calculated fields +not deal with Identity field to retrieve it and also cannot be inherit! there someone wrote Alternative? Tag: A transport-level error has occurred when sending the request to the server Tag: 136577
  - 7
    - SqlCommand Parameters with SqlDbType and VarChar(MAX) If I have a field in MS SQL 2005 called "data" with type VarChar(MAX), how do I add a parameter using the syntax below if SqlDbType doesn't have a VarChar(MAX) type. If I use SqlDbType.VarChar will the value get truncated or is that what I should use? SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@data", SqlDbType.VarChar).Value = largeTextData; Or am I supposed to use the size parameter? cmd.Parameters.Add("@data", SqlDbType.VarChar, 1000000).Value = largeTextData; Also how many characters does VarChar(MAX) hold? Tag: A transport-level error has occurred when sending the request to the server Tag: 136575
  - 8
    - Accessing sql server behind proxy Hi My app is running on a windows 2000 server with isa 2000 installed. How can it access an external sql server (using its ip) from within the isa 2000 firewall/proxy via code? Thanks Regards Tag: A transport-level error has occurred when sending the request to the server Tag: 136573
  - 9
    - HowTo Convert Array to Binary I have an array of an array of doubles and need to save this as a single byte array. Then save this byte array as a BLOB to an SQL 2005 database. Array allocation code shown below: Array myArray = Array.CreateInstance(System.Type.GetType("System.Double[]"), 3); Double[] dblArray1 = new double[4] { 23.56, 24.56, 25.56, 26.56 }; Double[] dblArray2 = new double[4] { 33.56, 34.56, 35.56, 36.56 }; Double[] dblArray3 = new double[4] { 43.56, 44.56, 45.56, 46.56 }; // Place above three double arrays in an myArray myArray.SetValue(dblArray1, 0); myArray.SetValue(dblArray2, 1); myArray.SetValue(dblArray3, 2); I have tried serialize the myArray object however the byte array is almost twice the length of the array of doubles: MemoryStream stream = new MemoryStream(); BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(stream, dblArray1); BinaryReader reader = new BinaryReader(stream); reader.BaseStream.Position = 0; byte[] inputBytes = reader.ReadBytes((int)reader.BaseStream.Length); However the byte count of the byte array is almost doubled that of the array of doubles. inputBytes byte count is 175 should of been 96 bytes. Does anyone know a better way to save an Array of an Array of doubles to a byte array? Thanks in advance, Scott Tag: A transport-level error has occurred when sending the request to the server Tag: 136571
  - 10
    - TransactionScope Questions Hi! I have a couple of questions about TransactionScope... What exactly is the scope of a transaction? Is it only connections that are created in the actual code block where the TransactionScope is defined, or is it all connections created on the same thread as the TransactionScope? What is the performance like using a TransactionScope object for multiple consequetive connections to a single database as compared to using a standard ADO.NET transaction object? I'm guessing it would be slower... but by how much? Thx! Tag: A transport-level error has occurred when sending the request to the server Tag: 136569
  - 11
    - Add array of rows to datatable Hi, I need to add array of rows to datatable. Have I use for cycle? Because Datatable can add only one row into collection. Thanks. Tag: A transport-level error has occurred when sending the request to the server Tag: 136564
  - 12
    - SQL Concatenation (||), Query builder in VS 2005 Hi, I need concatenate values of two fields in select command, but if I use this select command in Query builder in VS I get error. I concatenate two string values using SQL concatenation operator (||). It's a bug in Query builder? I think.... Tag: A transport-level error has occurred when sending the request to the server Tag: 136560
  - 13
    - ExecuteXMLReader I have a Sql2000 Stored Proc. that returns the result in the form of XML. I am calling this SP in my .NET application(webservice) using ADO.net. Can you please suggest me if I should be using the ExecuteReader or ExecureXMLreader method? Also, what are the advantages of using ExecureXMLreader over ExecuteReader In my .NET application, I need to populate the xml returned by SQL SP in a XML document. Thanks. Rajiv Tag: A transport-level error has occurred when sending the request to the server Tag: 136559
  - 14
    - Firebird Upper function VS.NET 2005 - Firebird 1.5.3 - Firebird.Net data provider I'm trying to add a fill commandText like this to an FBDataTable in the database designer. Select <field list> from CONTACTS where ("UPPER"(NAME) like @Name) The database designer put the quotes around "Upper", not me. And I get this error: ________________________________________ Failed to update CommandText: The schema of data returned by your new command could not be retrieved. Schema of table "CONTACTS" was not changed and might not reflect data retrieved by your command. The database returned the following error: Dynamic SQL Error SQL error code = -804 Function unknown UPPER Can I use "Upper" in the form designer or is there some other way? Rick Tag: A transport-level error has occurred when sending the request to the server Tag: 136539
  - 15
    - There is no Original data to access when updating a DataTable with computed columns Hi all, this was driving me crazy! I've a datatable its related sqlDataAdapter, if I call the .Update method of the adapter everything is ok, but if I add a compute column to the DataTable (a columns computed via a DataRelation) I receive the "There is no Original data to access" Tag: A transport-level error has occurred when sending the request to the server Tag: 136536
  - 16
    - How to Insert the date function in asp.net to sql serevr i have 3 dropdown lists.from this dropdown list to { }{day[first dropdown list],month[second dropdown list],year [third dropdown list]. how insert the day,month,year to sql server databse EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: A transport-level error has occurred when sending the request to the server Tag: 136531
  - 17
    - DataTable. Foreign key does not works. Hello to all. I have simple form with DataGrid binded to DataTable. DataTable has foreign key to itself. When I'm deleting one row it's child rows stay in Table. (It deletes only parent row, not child). Here is code: DataTable TestTable = new DataTable("Test"); TestTable.Columns.Add("ID", typeof(Int32)); TestTable.Columns.Add("ParentID", typeof(Int32)); TestTable.Constraints.Add("PARENT_TO_ID", TestTable.Columns["ID"], TestTable.Columns["ParentID"]); DataRow TestRow = TestTable.NewRow(); TestRow["ID"] = 1; TestRow["ParentID"] = DBNull.Value; TestTable.Rows.Add(TestRow); TestRow = TestTable.NewRow(); TestRow["ID"] = 2; TestRow["ParentID"] = 1; TestTable.Rows.Add(TestRow); dataGrid1.DataSource = TestTable; Is it DataTable bug? Thanks in advance! Tag: A transport-level error has occurred when sending the request to the server Tag: 136530
  - 18
    - best practice for data display VS 2005 designing a WinForm. I have a typical CUSTOMER, ORDERS, ORDERDETAIL database. I want to show these related items on a winform with either textboxes or datagridview controls. If I use the dataset designer to create a strongly-typed DS it will bring into memory ALL the records in each table and then select a subset according to the relations I have set when the user selects a CUSTOMER. Of course, this is completely impractical when you have any quantity of rows in any of the tables since they cannot all be brought into memory. All the examples I see use the above approach for demonstration, but this doesn't seem practical in a real world app. So how do I do this right from the beginning? Do I create queries with a param for the relation between the parent and child table and then respond to a row change event? I'm confused since I don't see any demo apps that use this senario which surely must be quite common. Thanks for any guidance, Rick Tag: A transport-level error has occurred when sending the request to the server Tag: 136529
  - 19
    - RowChanged event fires after that the current cell is changed Hi all, I've a DataGrid wich DataSource is a DataTable declared with the "WithEvents" clause, I've write some code to handle the RowChanged event. My DataGrid has a boolean column (wich not allows null value) and a TextBox column with some decimal values, I wish that when a user checks the boolean column a TextBox in the form will display the computed sum of the rows "checked". But I have noticed that the RowChanged event fires when I change a row (doh!) but only after I've changed the current cell or after the grid has lost the focus. I want that when I check or uncheck a row, the textbox displayng the computed sum suddenly changes, is there a way to accomplish this? Tag: A transport-level error has occurred when sending the request to the server Tag: 136527
  - 20
    - MI5 Persecution: what people said (3927) From: aa1gha@zen.sunderland.ac.uk (gillian.hardy) Newsgroups: uk.misc,uk.legal,uk.politics,uk.politics.misc,uk.media Subject: Re: Read About "MI5 Persecution" on the Web! Date: Mon May 13 21:27:26 1996 : In article <Dr5sDI.50x.0.bloor@torfree.net>, bu765@torfree.net wrote: : |> This site is now running brilliantly. It will be updated with new : |> information regarding this case and is well worth including in your : |> bookmark file. For my sins I had a look and it's quite good actually. Nicely set out and presented. Didn't read it though, having read the rants a million times before. By the way, anyone noticed Chris Tarrant looking at you funny during Man O Man yet? Thought not... Gillian ------------------------------- From: franco@elea.demon.co.uk (Francis Devonshire) Newsgroups: uk.misc,uk.legal,uk.politics,uk.politics.misc,uk.media Subject: Re: Read About "MI5 Persecution" on the Web! Reply-To: franco@elea.demon.co.uk Date: Tue May 14 19:17:26 1996 In message <4na2d0$dho@leofric.coventry.ac.uk> Stephen Hopkins wrote: :Yes, I have to be honest: that page is one of the best examples of how to :present a long document on the Web that I've seen. Hopefully, frames will :become more and more prevalent and this style of presentation will become :the norm for long documents such as that. My html thingy doesnt seem to do frames so all I got was a blank page. Then again, maybe someone, somewhere doesn't want me to read it. BTW does 'troll' bring to mind a fishing lure (ie you are American), or an ogre type thing (ie you are European). I much prefer the image of the latter. +--------------------------------------------------------------------------+ | Francis Devonshire Titchfield, Hampshire, United Kingdom | +--------------------------------------------------------------------------+ ------------------------------- Newsgroups: uk.misc,uk.legal,uk.politics.misc,soc.culture.british From: duncan@yc.estec.esa.nl (Duncan Gibson) Subject: Re: MI5 Persecution: Bugging Date: Wed Jun 12 06:46:41 1996 Mike Corley <bu765@torfree.net> wrote: > Read about the MI5 Persecution on the Web Now, whatever you might think about the content, this is a very well designed and presented web page (if you use Netscape to look at it anyway - Mosaic couldn't handle it). This is my article, not my employer's, with my opinions and my disclaimer! -- Duncan Gibson, ESTEC/YCV, Postbus 299, 2200AG Noordwijk, The Netherlands Tel: +31 71 5654013 Fax: +31 71 5656142 Email: duncan@yc.estec.esa.nl 3927 -- Posted via a free Usenet account from http://www.teranews.com Tag: A transport-level error has occurred when sending the request to the server Tag: 136523
  - 21
    - MI5 Persecution: £20,000 Reward (3057) 20,000 Reward Offered to Expose the Conspiracy I am making a pledge for information directly leading to the exposing of the "BBC Newscaster Conspiracy". The exposing would specifically need to lead to a legally binding admission from Martyn Lewis or Michael Buerk of the BBC they they were watching me through the TV set. I would be happy (delighted, in fact) to pay GBP 20,000 sterling in reward for the above admission. -------------------------------------------------------------------------------- 3057 -- Posted via a free Usenet account from http://www.teranews.com Tag: A transport-level error has occurred when sending the request to the server Tag: 136522
  - 22
    - dataset fill brings all records? VS 2005 pro. I have a strongly typed dataset which I generate using the designer. From the xsd file I set the relations between the CONTACTS table to the ORDERS table to the ORDERITEMS table. Then I put some DataGridViews on the form and open. In the Load event of the form the Fill methods are used in the three tables. As I step through by line, I can see the CONTACTS (1500 rows) is pretty quick and the ORDERS (55,000 rows) is slower but the ORDERITEMS (5 million + rows) churns on and on until I run out of memory. If I leave out the ORDERITEMS datagridview, the form opens and the parent-child relations are good. It seems like the Fill method is taking ALL the rows from the DB and only displaying the subset I want based on CONTACT. I would have thought that it would only "hit" the DB when it had a record in the CONTACTS table as a parent. Do I have to setup my relations with a parameter to not retreive all rows from the DB, or is this what is happening? Rick Tag: A transport-level error has occurred when sending the request to the server Tag: 136519
  - 23
    - Paging controls won't show up when using FormView I have a very simple FormView control, but when I view the page it does not show the Paging controls, although it does show the data. Here is my code: <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="FormViewTest.aspx.vb" Inherits="family.FormViewTest" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> </head> <body> <form id="form1" runat="server"> <asp:FormView ID="fviewTesting" runat="server" AllowPaging="true" PagerSettings-Visible="true"> <rowstyle HorizontalAlign="Center"/> <ItemTemplate> <asp:Image ID="imgPhoto" runat="server" BorderWidth="0px" ImageAlign="Middle" ImageUrl='<%# DataBinder.Eval(Container,"DataItem.filename","images/photoalbum/{0}") %>'/><br/> <asp:Label ID="lblPhotoCaption" runat="server" AssociatedControlID="imgPhoto" Text='<%# DataBinder.Eval(Container,"DataItem.caption") %>'/><br/> <asp:Label ID="lblPhotoDate" runat="server" AssociatedControlID="imgPhoto" Text='<%# DataBinder.Eval(Container,"DataItem.photodate","Photo taken on: {0:D}") %>'/> </ItemTemplate> </asp:FormView> </form> </body> </html> Partial Public Class FormViewTest : Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim photoalbum As New DataTable Dim dataadapterSelect As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM babyphotos ORDER BY photodate,filename", System.Configuration.ConfigurationManager.AppSettings("connectionstring")) dataadapterSelect.Fill(photoalbum) Me.fviewTesting.DataSource = photoalbum Me.fviewTesting.DataBind() End Sub Private Sub fviewTesting_PageIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles fviewTesting.PageIndexChanged Dim currfile As String = CType(Me.fviewTesting.DataItem, DataRowView)("filename").ToString() Dim photo As System.Drawing.Image = System.Drawing.Image.FromFile(MapPath("images/photoalbum/" & currfile)) CType(Me.fviewTesting.FindControl("imgPhoto"), Image).Width = photo.Width CType(Me.fviewTesting.FindControl("imgPhoto"), Image).Height = photo.Height CType(Me.fviewTesting.FindControl("lblPhotoDate"), Label).Text = CDate(CType(Me.fviewTesting.DataItem, DataRowView)("photodate")).ToLongDateString() End Sub End Class What am I doing wrong? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: A transport-level error has occurred when sending the request to the server Tag: 136513
  - 24
    - More efficient way of getting this aggregate data? Hi all, Our database contains daily data going back for years, which I need aggregated into weekly averages. I came up with the code below to get it, but I don't like it - mostly because hitting the the database with a couple thousand queries feels wrong somehow. Is there a way to somehow send a "bulk query" to the DB through ado.net, and receive the response in a "bulk" package? (No need to tell me about parametrizing the query.) Thanks for any ideas, cdj ================ private void GetWeeklyAverages(DateTime theLastMonday) { DateTime currMon = theLastMonday; DateTime currFri = currMon.AddDays(4); int i=0; int numZeroAvgsInARow = 0; while (i<2000 && numZeroAvgsInARow<10) { string strConn = "user id=ID;password=PASSWORD;data source=SOURCE"; OracleConnection dc_UAT = new OracleConnection(strConn); string avg = "0"; try { dc_UAT.Open(); string oracleTable = "TABLE"; string oracleSelectString = "select round(avg(DATA),5) from " + oracleTable + //variable " where indexid='" + "1" + //variable "' and as_of_date between '" + currMon.ToString("dd-MMM-yyyy") + "' and '" + currFri.ToString("dd-MMM-yyyy") + "'"; OracleCommand cmd = new OracleCommand(oracleSelectString, dc_UAT); avg = cmd.ExecuteScalar().ToString(); } catch(Exception ex) { MessageBox.Show(i.ToString() + ": " + ex.Message, "Error getting average"); } finally { if (dc_UAT != null) { dc_UAT.Close(); } } //Print out info txt_Output.Text += i.ToString() + ": " + currMon.ToString("MM/dd/yy") + " -" + currFri.ToString("MM/dd/yy") + "\t\t" + avg + Environment.NewLine; //Next week back currMon = currMon.AddDays(-7); currFri = currMon.AddDays(4); //Take care of loop vars if (avg == "0") { numZeroAvgsInARow++; } else { numZeroAvgsInARow = 0; } i++; } Tag: A transport-level error has occurred when sending the request to the server Tag: 136511
  - 25
    - Reading catalog of IBM DB2 hi all, i have a problem with returning all tables included in IBM DB2 database. i'm using OleDbConnection to connect to IBM DB2, aRds As DataTable = CType(aConn, OleDbConnection).GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing) this line returns datatable with no rows, but it's schema is right, and the connection string is right. plz, i need ur help very quickly.. thanx in advance.. Ola Tag: A transport-level error has occurred when sending the request to the server Tag: 136507

Hi All,

We have a website build in ASP.NET 2.0 and we are receiving the following
error:

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 first we received this error at the localhost only, unfortunatelly it is
popping up in the logs of the live server as well now.

When we were searching for a sollution or a better explanation of what is
happening here, we found loads of people with the same problem. Nobody seems
to have an answer though.

If you had this problem and found a sollution or if you know more about this
error, please let us know!

Thanks in advance!

Kind regards,

Robin

Top

Re: A transport-level error has occurred when sending the request to the server by William

William
Thu Jan 25 12:04:37 CST 2007

I've seen this too and in some cases it was traced back to hardware issues
with the NIC, the switch, the cables or the volume of data being sent over
the wire.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Robin van de Water" <no_spam_please> wrote in message
news:eFmzRxFQHHA.2140@TK2MSFTNGP03.phx.gbl...
> Hi All,
>
> We have a website build in ASP.NET 2.0 and we are receiving the following
> error:
>
> 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 first we received this error at the localhost only, unfortunatelly it
> is popping up in the logs of the live server as well now.
>
> When we were searching for a sollution or a better explanation of what is
> happening here, we found loads of people with the same problem. Nobody
> seems to have an answer though.
>
> If you had this problem and found a sollution or if you know more about
> this error, please let us know!
>
> Thanks in advance!
>
> Kind regards,
>
> Robin
>
>
>
>
>
>
>
>

Top