I see in profiler this error: "This message could not be delivered because its message timestamp has expired or is invalid"
What is a reason for error?
I run SB between 2 SQL servers. In profiler on an initiator side I see next error: 'This message could not be delivered because its message timestamp has expired or is invalid'. For the conversation we use best practice, i.e. target closes a conversation. Target side succeed to close conversation, but initiator still stay in DO (disconnect_outbound).
What is a reasone for the error? What to do?
When I send message from Server1 to Server2,I found the error "This message could not be delivered because it is duplicate" in SQLProfiler on Target, why message can be duplicate ? who can help me?
View 8 Replies View Related
Hi,
I am using service broker in between two database servers. following is the way i am sending and receiving messages
Send
BEGIN TRAN
BEGIN DIALOG CONVERSATION @handle
FROM SERVICE @SendService
TO SERVICE @ReceiveService
ON CONTRACT @Contract
WITH LIFETIME = @lifetime;
SEND ON CONVERSATION @handle
MESSAGE TYPE @xmlMessageType(@xmlMessage);
COMMIT
Receive
BEGIN TRAN;
RECEIVE TOP(1) @xmlMessage = message_body,
@handle = conversation_handle,
@message_type = message_type_name
FROM TransactionQueue;
----------------------------------------------------------------------------------------------------
-- Check to make sure a message was returned to process. In theory this should never happen.
----------------------------------------------------------------------------------------------------
IF @@rowcount = 1
BEGIN
IF @message_type = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog'
BEGIN
END CONVERSATION @handle;
COMMIT
RETURN 0
END
IF @message_type = N'http://schemas.microsoft.com/SQL/ServiceBroker/Error'
BEGIN
RAISERROR(N'Received error %s from service [Target]', 10, 1)
END CONVERSATION @handle;
COMMIT
RETURN 0
END
SET @sql = 'EXEC '+@message_processor_name+' @xml'
BEGIN TRAN
EXEC sp_executesql @sql, N'@xml XML', @xml=@xmlMessage
COMMIT TRAN
END CONVERSATION @handle;
END
COMMIT
I see Messages are delivered to the target every thing working fine other than following errors which i am seeing in profiler.
1) "This message could not be delivered because the conversation endpoint has already been closed." I see this error on initiator end. Is it like ending conversation on initiator end when i get "EndDialog" send an acknowledgement, which cannot be recieved by target as it has already ended conversation.
2) "An error occurred while receiving data: '64(The specified network name is no longer available.)'." I don't have much idea about the reason for this error. But in profiler i see value for GUID is different for this error and the real message.
Let me know if you need any other information
Hi,
I already had a thread for same problem but didn't recieved any response in last 4-5 months so I created a new thread for this
I am using service broker in between two database servers. following is the way i am sending and receiving messages
Send
BEGIN TRAN
BEGIN DIALOG CONVERSATION @handle
FROM SERVICE @SendService
TO SERVICE @ReceiveService
ON CONTRACT @Contract
WITH LIFETIME = @lifetime;
SEND ON CONVERSATION @handle
MESSAGE TYPE @xmlMessageType(@xmlMessage);
COMMIT
Receive
BEGIN TRAN;
RECEIVE TOP(1) @xmlMessage = message_body,
@handle = conversation_handle,
@message_type = message_type_name
FROM TransactionQueue;
----------------------------------------------------------------------------------------------------
-- Check to make sure a message was returned to process. In theory this should never happen.
----------------------------------------------------------------------------------------------------
IF @@rowcount = 1
BEGIN
IF @message_type = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog'
BEGIN
END CONVERSATION @handle;
COMMIT
RETURN 0
END
IF @message_type = N'http://schemas.microsoft.com/SQL/ServiceBroker/Error'
BEGIN
RAISERROR(N'Received error %s from service [Target]', 10, 1)
END CONVERSATION @handle;
COMMIT
RETURN 0
END
SET @sql = 'EXEC '+@message_processor_name+' @xml'
BEGIN TRAN
EXEC sp_executesql @sql, N'@xml XML', @xml=@xmlMessage
COMMIT TRAN
END CONVERSATION @handle;
END
COMMIT
I see Messages are delivered to the target every thing working fine other than following errors which i am seeing in profiler.
1) "This message could not be delivered because the conversation endpoint has already been closed." I see this error on initiator end. Is it like ending conversation on initiator end when i get "EndDialog" send an acknowledgement, which cannot be recieved by target as it has already ended conversation.
2) "An error occurred while receiving data: '64(The specified network name is no longer available.)'." I don't have much idea about the reason for this error. But in profiler i see value for GUID is different for this error and the real message.
Let me know if you need any other information
We have a stored procedure that is creating information in tempdb table and using cursors. It is suppose to produce a report of about 1000 records. If we run the stored procedure as a sql query then it works fine. If we run it using the VB app. it times out with the following message:
[Microsoft][ODBC Sql Server Drive]Timeout expired(#0)
Is there anything I can do to correct this problem?
Thank you,
Tracy
Hi,
I need to find the exact time a message was received in the service broker, the time it finished sending and the time it was received at the destination (which is another service broker queue on a different server). I am trying to figure out what the delay is, with increasing message size.
Please advice
Thanks
sorry for posting a question that has probably been posted hundreds oftimes, but i can't seem to find the answer i need...We're using a SqlServer 7.0 database and recently started getting timeout expirederrors on our views, which i'm assuming is due to the volume ofrecords in our tables. Unfortunately i'm not too experiences w/indexing tables, so my question is:1) how do you determine which fields to index (does it have to be afield w/ no nulls, no duplicates..similar to primary key), and why notindex the primary key2) is it better to index the same field on different tables, or is ita better design to index a different field for each table (ex. do youwant to index the same field that you link the different tables with,or do you want to avoid doing this)3) can somebody explain the concept of creating a clustered index4) once table is indexed, if there are users accessing the linkedtables via Access, do they have to re-link the tables?sorry for the number of questions and what may appear to be simplequestions to most, but again, i'm pretty unfamiliar w/ indexing andwould really appreciate any help...thanks
View 1 Replies View RelatedHi All,
I have the same question and error that Chopaka is getting:
"I have a SQL 2005 job that calls a stored proc. The job step returns the message "Query timeout expired....Message 7412...The step succeeded." The proc never actually ever did anything due to the query timeout, and the job continued on to other steps. I'm going to address the timeout issue eventually, but first I'd like to trap the timeout problem and force the job to end.
It appears that the query timeout isn't really an error, just a message. I've tried TRY-CATCH in the SP but the situation isn't caught, again probably due to the interpretation that it isn't an error."
I have reduced the "Remote Query time out" to 1 sec, in order to catch the error and to prevent the job from running, but the error is not caught.
Is there a way to catch this in the SQL or in the job step to prevent the job from continuing?
This is the script that I'm using without any luck
BEGIN TRY
BEGIN Transaction
Create table #tmpSummaryTable
(
)
insert into #tmpSummaryTable
select * from CDRServer01.iXtemp.dbo.gx_tbFTRSummary_test
COMMIT Transaction
END TRY
BEGIN CATCH
DECLARE @err int
SELECT @err = @@error
PRINT '@@error: ' + ltrim(str(@err))
SELECT ERROR_NUMBER() ERNumber,
ERROR_MESSAGE() Error_Message
ROLLBACK
Return
END CATCH
In the following code, I received an error on
execInfo = rsReportExec.LoadReport(strReportPath, strHistoryID). The errro was "System.Web.Services.Protocols.SoapException: The path of the item "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=119&nvchrWhoRan=DYW" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=119&nvchrWhoRan=DYW" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply.
I copied and pasted the path on the URL and it worked. What did I miss in the code? Why strHistoryID is required as it is nothing? Please refer to http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Private Sub sExecuteReportingServicesReport()
Dim rsReportExec As ReportExecutionService = New ReportExecutionService
rsReportExec.Credentials = System.Net.CredentialCache.DefaultCredentials
'rsReportExec.Url = "http://localhost/reportserver/ReportExecution2005.asmx"
Dim byteResult() As Byte = Nothing
Dim strReportPath As String = "http://localhost/ReportServer/Pages/ReportViewer.aspx?/CAITReports/rptIssuesByRole&rs:Command=Render&intProjectID=" & Me.cboProject.SelectedValue & "&nvchrWhoRan=" & Session("strEmployeeName")
'Dim strReportPath As String = "/Pages/ReportViewer.aspx?/CAIT/rptIssuesByRole&rs:Command=Render&intProjectID=" & Me.cboProject.SelectedValue & "&nvchrWhoRan=" & Session("strEmployeeName")
Dim strFormat As String = "MSWord"
Dim strHistoryID As String = Nothing
Dim strEncoding As String = ""
Dim strMineType As String = ""
Dim strExtension As String = ""
Dim wrnWarnings() As Warning = Nothing
Dim strStreamIDs() As String = Nothing
Dim execInfo As New ExecutionInfo
Dim execHeader As New ExecutionHeader
rsReportExec.ExecutionHeaderValue = execHeader
execInfo = rsReportExec.LoadReport(strReportPath, strHistoryID)
Dim strSessionID As String = rsReportExec.ExecutionHeaderValue.ExecutionID
byteResult = rsReportExec.Render(strFormat, Nothing, strExtension, strEncoding, strMineType, wrnWarnings, strStreamIDs)
Response.ClearContent()
Response.AppendHeader("content-length", byteResult.Length.ToString)
Response.ContentType = "application/MSWord"
Response.BinaryWrite(byteResult)
Response.Flush()
Response.Close()
End Sub
Thanks.
DanYeung
i'm working on an application using vs 2005, sql server2000, with c# asp.net
i can access many tables in my db that the dbo is the dbowner for them, but when i access few tables that the owner for them is dswebwork, i recieved an error says, invalid object name tbluser...which tbluser is table name...this is the error message in details.....
Invalid object name 'tblUsers'.
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: Invalid object name 'tblUsers'.Source Error:
Line 57: string passWord = txtPassword.Text;
Line 58:
Line 59: Users users = new Users(Constants.DB_CONNECTION,
Line 60: userName, passWord);
Line 61: Source File: e:web worksWebworksDSCWebWorksLoginMaster.master.cs Line: 59 Stack Trace:
[SqlException (0x80131904): Invalid object name 'tblUsers'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +95
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +82
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +52
System.Data.SqlClient.SqlDataReader.get_MetaData() +130
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +371
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1121
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +45
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +162
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +35
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +32
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +183
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +307
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +151
WebWorksBO.DBElements.BaseDataSQLClient.FillDataset(DataSet dsToFill) in C:DevelopmentMyWebWorks20WebWorksBODBElementsBaseDataSQLClient.cs:97
WebWorksBO.DBElements.dbUsers..ctor(String connStr, String loginname, String loginpassword) in C:DevelopmentMyWebWorks20WebWorksBODBElementsdbUsers.cs:38
WebWorksBO.AppElements.Users..ctor(String connStr, String loginname, String loginpassword) in C:DevelopmentMyWebWorks20WebWorksBOAppElementsUsers.cs:370
LoginMaster.LoginUser() in e:web worksWebworksDSCWebWorksLoginMaster.master.cs:59
LoginMaster.imgbtnOK_Click(Object sender, ImageClickEventArgs e) in e:web worksWebworksDSCWebWorksLoginMaster.master.cs:46
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +102
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +141
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3840
so..i hope to help me...i need to deploy this project soon...
Hi Friends,
I have the below procedure in my local system for sending automatic mails in sql server 2005.
Create Procedure dbo.SendEmail1@To VarChar(500), @From VarChar(100), @Subject VarChar(200), @Body VarChar(1000), @SMTPServer VarChar(50)ASDeclare @Object int, @Hr int, @Src VarChar(255), @Desc VarChar(255)--Create Message objectExec @Hr = sp_OACreate 'CDO.Message', @Object OUTIf @Hr <> 0BeginExec sp_OAGetErrorInfo @Object, @Src OUT, @Desc OUT SELECT hr=convert(varbinary(4),@Hr), Source=@Src, Description=@DescReturnEnd--set sEndusing propertyExec @Hr = sp_OASetProperty @Object, 'Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sEndusing")', '1'If @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set port propertyExec @Hr = sp_OASetProperty @Object, 'Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/SEndUsingMethod")', '25'If @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set smtp server propertyExec @Hr = sp_OASetProperty @Object, 'Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver")', @SMTPServerIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--Update the configurationExec @Hr = sp_OAMethod @Object, 'Configuration.Fields.Update', NullIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set TO propertyExec @Hr = sp_OASetProperty @Object, 'To', @ToIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set FROM propertyExec @Hr = sp_OASetProperty @Object, 'From', @FromIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set Subject propertyExec @Hr = sp_OASetProperty @Object, 'Subject', @SubjectIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--set HTMLBody propertyExec @Hr = sp_OASetProperty @Object, 'HTMLBody', @BodyIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--SEnd the mailExec @Hr = sp_OAMethod @Object, 'SEnd', Null If @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd--No memory leaks!Exec @Hr = sp_OADestroy @ObjectIf @Hr <> 0BeginExec sp_OAGetErrorInfo @ObjectReturnEnd
and executed as
SendEMail1 'x@x.com','a@a.com', 'Sending email through Stored Procedure', 'Body : An Email can be sent through stored procedure... and this is SAMPLE', 'smtpservername' This is working fine when I excuted the above procedure in the local system.
Same procedure I have created in the developement machine and excute it the it is giving error as
0x80040220 CDO.Message.1 The "SendUsing" configuration value is invalid. NULL 0
I need the suggestions on the above error and how to solve this in our development server.
Thanks,
I'm trying to use the message queue task in SSIS 2005 and not getting very far. Right off the bat I'm trying to create a Message Queue Connection Manager and when I enter the path, trying both "seawxxxx estq" (my local computer name) or ". estq" and test it, it comes back with "invalid path". Have done quite a bit of searching around and can't find anything on this particular error.
Suggestions? Thanks in advance.
I'm having trouble with cube processing. While processing a code I'm getting a "Invalid column name MessageType" error.
I unfolded the cube, then I opened "measure groups", my failing dimension (ServiceRequestDim) and the partition.
In the partition I opened the "Source" attribute so it now includes my column which was missing. But it didn't solve the issue.
If I get the query used during the process I'm getting this :
SELECT
DISTINCT
[ServiceRequestDim].[MessageType] AS [ServiceRequestDimMessageType0_0]
FROM
(
Select IsNull(IsDeleted, 0) as IsDeleted, [ServiceRequestDimKey], IsNull([Status_ServiceRequestStatusId], 0) as [Status_ServiceRequestStatusId],[Status],IsNull([TemplateId_ServiceRequestTemplateId], 0) as
[Code] ....
In the nested query which defines ServiceRequestDim the messagetype attribute is still missing. In my source datamart the ServiceRequestDim has the "MessageType" column.
So the question is where do I change the nested request that the dim process use to reflect the actual columns in my datamart .
i was deleting a row from my gridview.this fail ("System.Data.SqlClient.SqlException: Invalid object name 'MESSAGE'.") consists what must i do ?My SQL query is "UPDATE MESSAGESET DELETIONSTATUSTO = 1,_LASTMODIFYDATE =getdate() WHERE (_ID = @ID)"
View 5 Replies View RelatedI am trying to run a query on my sql server and get the following error message:
"An error occurred while executing batch. Error message is: The directory name is invalid."
how do I fix?
In my SQL Server, I see the below message in the Application Event Viewer
"18265 :
Log backed up: Database: HSD, creation date(time): 2007/01/06(05:05:05), first LSN: 1439:495055:1, last LSN: 1439:496675:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:MSSQLBACKUPHSDHSD_tlog_200707141300.TRN'})."
When I save the application event viewer and open it in another server, I do not see the above message, instead I get the following message:
" Can't find or load message DLL. Message DLL must be in path or in current directory."
Any thoughts to overcome this problem is appreciated.
Thanks
Santhosh
I am trying to set up a ODBC connection to a remote database using the ODBC data source administrator. I am getting an error message complaining of an invalid instance(). The database I am trying to connect to does have a default instance and a named instance. Do I need to specify the instance name somewhere in the connection settings? I tried specifying the server name as <Remote computer IP Address>/<Instance Name> but this didn't work. Any ideas?
View 4 Replies View RelatedHello,
I am having trouble specifying a message body that is valid. I mean for the client to send. If I leave it as null then everything is ok but if I create a memorystream and add a line of text it reports back it did not pass validation. I do not understand this and am not sure what to do. I need to send a message based on a code and text but do not know the format of the body that is allowed. The code I am refering to comes out of HelloWord_CLR because that is what I am formating my sample after. I call it the same way it calls the return message done in ServiceProc. I need to know the message format including body since this does not seem to work. A sample of the call is bellow.
// Create an empty request message
string Msg = "Hello";
MemoryStream body = new MemoryStream(Encoding.ASCII.GetBytes(Msg));
Message request = new Message("Request", body);
Thanks,
Scott Allison...
I am populating oracle source in Sql Server Destination. after few rows it fails it displays this error:
[OLE DB Destination [16]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description:
"Invalid date format".
I used this script component using the following code in between the adapters, However after 9,500 rows it failed again giving the same above error:
To convert Oracle timestamp to Sql Server timestamp
If Row.CALCULATEDETADATECUST_IsNull = False Then
If IsDate(DateSerial(Row.CALCULATEDETADATECUST.Year, Row.CALCULATEDETADATECUST.Month, Row.CALCULATEDETADATECUST.Day)) Then
dt = Row.CALCULATEDETADATECUST
Row.CALCULATEDETADATECUSTD = dt
End If
End If
I don't know if my code is right . Please inform, how i can achieve this.
Hi
Can anybody guide --
how to send the message to the user connected to SQL server 2005 on lan
thanks
Hi
I have basic knowledge of SQL Server and Expert in MS Access
Know I want to change my Access Database into Database.
Now what i required is when I create any Procedure
then we use a condition helping keyword 'Where'
No what I required is when I execute any procedure using where clause It must open a Input Box where I put a condition
For Example
when I create a procedure like this
create Procedure prc_Demo
(
a int,
as
Select * from employee where emp_id = 'a'
)
Something like that So I want when I execute this then there must be open a box where I type emp_id then it show matching the result
How can it is possible
Thanks
Ashish
You Have to Loss Many Times to Win Single Time
Has anyone encounterd this message in the sql log:
-----
BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.
-----
DB's are in simple recovery mode and only a daily backup is being done on DB's. It almost seems that SQL is doing something internally.
thanks
hi everybody
i m using dynamic connection in rdl file firstly i m showing username and pwd . after this user name and pwd i make a connection string for my report. when i m entering invalid pwd, than report generate an error. and stop. is there any way by which i can trace error and flash a message box to user about his invalid user name or pwd.
thanks
I sent a message from Server A to B. I didn't end the conversation. The message is stuck in sys.tranmission_queue with no error message (empty) . the initiatorQueue is empty (no records). why doesn't the message get sent ?
View 3 Replies View RelatedWe are running transactional replication on sqlserver 2000 and I see the following message: "The initial snapshot for article reason_type is not yet available" Followed 10 minutes later by a "timeout expired" event (we see lots of these). I see no reason for a snapshot to even be running at 3:04 AM but then, it apparently was so what can I say. The Snapshot agent history does not show any entries for the last year so that is a bit of a mystery. The table in question seems identical at both the publisher and subscriber (including content).
Any ideas why this message would appear? It appears that a snapshot for this article was somehow involved but I thought a snapshot was only created by specific request.
Thanks.
I have a service broker service and there are multiple clients that can put messages in the queue of that service. How do I check which message comes from which client? There is no field in the queue like message_senderId or something like that.
View 1 Replies View RelatedHi,May I know how can I show an error message in aspx page when I hit a transaction error in sql server 2K? Thanks Levine
View 5 Replies View RelatedI have a SQL Express database on our server that is used for one of our websites when the website tries to write to the database I get the following error: -
An attempt to attach an auto-named database for file D:lahwebsitesGiants North Walesapp_datadatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
This error is very frustrating and I really can't find a way around it. I have done the following: -
Deleted the SQL Server Express folders under user preferences
Hi,I am trying to write some C# ASP.NET 2.0 code. I have created a web form to send data to my sql server 2005 database. When I compile the application and insert data then click on the submit button I get this error
"A first chance exception of type
'System.Data.SqlClient.SqlException' occurred in System.Data.dll" I have been trying to solve this for a few days now with no luck, so any help would be appreciated. I'll post below the source code of the web form (addOrder.aspx). It might be worth mentioning that I have created another web form in the same project called addCustomer.aspx. Like addOrder.aspx it is a web form, however it successfully inserts data in the database. 1 <%@ Page Language="C#" MasterPageFile="~/Default.master" Title="Add Order Page" %>
2 <%@ import namespace="System.Data.SqlClient" %>
3 <%@ Import Namespace="System.Data" %>
4 <%@ Import Namespace="System.Web" %>
5 <%@ Import Namespace="System.Configuration"%>
6 <%@ Import Namespace="System.Globalization"%>
7
8 <script runat="server">
9
10 protected void Page_Load(object sender, EventArgs e)
11 {
12
13 }
14
15 protected void sumbitButton_Click(object sender, EventArgs e)
16 {
17 SqlConnection conn;
18 SqlCommand comm;
19 string connectionString =
20 ConfigurationManager.ConnectionStrings[
21 "ShippingSystemConnectionString1"].ConnectionString;
22 conn = new SqlConnection(connectionString);
23 comm = new SqlCommand(
24 "INSERT INTO Order(CustomerID, " +
25 "NumberofItems, DescriptionsofItems, SafeItems) " +
26 "VALUES (@CustomerID, " +
27 "@NumberofItems, @DescriptionsofItems, @SafeItems)", conn);
28 comm.Parameters.Add("@CustomerID", System.Data.SqlDbType.Int);
29 comm.Parameters["@CustomerID"].Value = int.Parse(DropDownList1.SelectedValue);
30 comm.Parameters.Add("@NumberofItems", System.Data.SqlDbType.Int);
31 comm.Parameters["@NumberofItems"].Value = numofitemstxt.Text;
32 comm.Parameters.Add("@DescriptionsofItems", System.Data.SqlDbType.VarChar);
33 comm.Parameters["@DescriptionsofITems"].Value = descofitemstxt.Text;
34 comm.Parameters.Add("@SafeItems", System.Data.SqlDbType.VarChar);
35 comm.Parameters["@SafeItems"].Value = safetxt.Text;
36 try
37 {
38 conn.Open();
39 comm.ExecuteNonQuery();
40 Response.Redirect("Success.aspx");
41 }
42 catch
43 {
44 }
45 finally
46 {
47 conn.Close();
48 }
49 }
50
51
52
53 protected void CustomerIDList_SelectedIndexChanged(object sender, EventArgs e)
54 {
55
56 }
57 </script>
58
59 <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
60 <table style="position: static">
61 <tr>
62 <td style="width: 169px">
63 Customer ID:</td>
64 <td style="width: 100px">
65 <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
66 DataTextField="CustomerID" DataValueField="CustomerID" Style="position: static">
67 </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ShippingSystemConnectionString1 %>"
68 SelectCommand="SELECT [CustomerID] FROM [Customer]"></asp:SqlDataSource>
69 </td>
70 <td style="width: 178px">
71 </td>
72 </tr>
73 <tr>
74 <td style="width: 169px">
75 Number of Items:</td>
76 <td style="width: 100px">
77 <asp:TextBox ID="numofitemstxt" runat="server" Style="position: static"></asp:TextBox></td>
78 <td style="width: 178px">
79 <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="numofitemstxt"
80 ErrorMessage="Number of Items Required" Style="position: static"></asp:RequiredFieldValidator></td>
81 </tr>
82 <tr>
83 <td style="width: 169px">
84 Descriptions of Items:</td>
85 <td style="width: 100px">
86 <asp:TextBox ID="descofitemstxt" runat="server" Style="position: static"></asp:TextBox></td>
87 <td style="width: 178px">
88 <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="descofitemstxt"
89 ErrorMessage="Description Required" Style="position: static"></asp:RequiredFieldValidator></td>
90 </tr>
91 <tr>
92 <td style="width: 169px">
93 Are Items safe:</td>
94 <td style="width: 100px">
95 <asp:TextBox ID="safetxt" runat="server" Style="position: static"></asp:TextBox></td>
96 <td style="width: 178px">
97 <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="safetxt"
98 ErrorMessage="Are Items Safe?" Style="position: static"></asp:RequiredFieldValidator></td>
99 </tr>
100 <tr>
101 <td style="width: 169px">
102 <asp:ValidationSummary ID="ValidationSummary1" runat="server" Style="position: static" />
103 </td>
104 <td style="width: 100px">
105 <asp:Button ID="sumbitButton" runat="server" OnClick="sumbitButton_Click" Style="position: static"
106 Text="Submit" /></td>
107 <td style="width: 178px">
108 </td>
109 </tr>
110 </table>
111 </asp:Content>
112
113
My order table in SQL server 2005 (express) looks like this:
Hello-
I have the following sql statement which produced an error when I add the order by clause
SQL = "SELECT DISTINCT nc_department.department, Count(nonconformance.department_id) as 'events', ISNULL(SUM(nonconformance.nc_wafer_qty),0) as wafers FROM nc_department LEFT OUTER JOIN nonconformance ON nc_department.department_id = nonconformance.department_id WHERE nc_department.active = '1' GROUP BY nc_department.department ORDER by nc_department.order_id"
This is the error I get:
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
Any help appreciated
I'm catching a primary constraint error in SQL and don't want to return the SQL error message back to the client. Is there any way to stop this. Thankyou
View 5 Replies View RelatedI need help on this!
When I try to change the data from a table using Web Matrix, then I get this error message.
The table’s data cannot be edited because the table does not contain modifiable columns.
As I need to edit the data’s, how can I solve this?
Thanks for Your Help
Mikel