Member Avatar

Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Thanks, Raymond.

Member Avatar
0
4
Member Avatar

hi........ can anyone tell me the connection strings to connect JAVA JAPPLET to sql server 2005 database and also the execution of SQL statement in java thanks

Member Avatar
0
2
Member Avatar

Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to another row called "totalbreak" BreaksTable ========= break_id - int rec_id - int userid - int breakStart - time breakEnd - time breaktotal - int reason - text I have tried to calculate the difference in minutes between the two dates using ; [CODE] SELECT DATEDIFF(MI, breakstart, breakend) from RP_RecordBreaks where …

Member Avatar
0
5
Member Avatar

Hello Everyone, I have developed an application for website using ASP.NET and SQL Server 2005. Recently I have uploaded it to server, but after uploading its showing the following error message - [B] Login failed for user ''. The user is not associated with a trusted SQL Server connection.[/B] [B]Description:[/B] [I]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: Login failed for user ''. The user is not associated with a trusted SQL Server connection.[/I] I …

Member Avatar
0
8
Member Avatar

I have a T-SQL function (transact SQL is SQL server 2005 programming language, with many limitations compared to say C# or Java). It currently works but has severe limitations. Its input is string (formula) that has ternary operators used in it. The function converts it into CASE statement and returns it. For ex. input: [B]a>0?111:222[/B] will be output as [icode]case when a>0 then 111 else 222 end [/icode] The function works as long as there is no brackets nesting in various levels alongwith use of use of math binary operators. For ex. [icode] (a>0?(b>0?2:3):(c=1?(d=1?4:5)+(e=1?6:7):8)) [/icode] and output expected is (with …

0
1
Member Avatar

Hi all well this is the first time in this forum so I'll be clear about my question and thanks in advance I'll create a software in C#, this app takes a cvs file (about 73,000 lines). This files comes from another system, also the cvs file can change, what's that means? the cvs file can change in one line ( the data ) or can have more new lines or can have less lines, the cvs change every hour or half hour it depends!!! I add those lines from the cvs file to a table in sqL,The first time …

Member Avatar
0
12
Member Avatar

I have an arraylist in which i have stored structures. Now i store the arraylist in a session and pass the it to the nextpage. I am having trouble trying to figure out how to get the strusture values out of the arraylist and store in database.....???? Anyone who knows this please help me.. I ll really appreciate it. Thanks I can provide the code as desired...

0
2

The End.