Optimistic Concurrency Control Error

Jun 28, 2006

Hi,

I have a table X:
ID (PK, int, not null)
cstID(FK, int, not null)
Name( nvarchar(100),not null)
Desc( ntext, null)

I am using the table view in Enterprise manager, if I manually type in a new row, then I edit that row, setting "Desc" = NULL, then I delete that row (from within the table view) I get the error:

Data has changed since the results pane was last retrieved. Do you want to save your changes now? (Optimistic Concurrency Control Error)

Things to note:
There was a FTI on this table, I deleted it, didn't help.
No other process or users are editing/viewing this table
The error doesn't occur if edit any other column, just setting the "Desc" to NULL creates this error.

Some other tables in my DB exhibit this same behavior, but not all......I can't figure out what the heck is going on...can you?

View 3 Replies


ADVERTISEMENT

Optimistic Concurrency Help

Jun 1, 2007

Hi,I'm trying to implement Optimistic Concurrency in asp 2 but so far it has caused me nothing but problems.First, when doing an UPDATE I tried to use the primary key & a timestamp field which I had in SQL Express.. VS 2005 generated the stored procedures fine however when it came to the actual updating I think there was a problem with the conversion of the timestamp field when it was being stored in a text box (in a FormView control). So.. as a result that failed. And also I checked sooo many places online and haven't been able to find any examples of code where a timestamp was used with success in asp2.Next, I got ride of the timestamp type (in SQL Express database) and used a datetime and then.. I just implemented Optimistic Concurrency by passing in ALL the values (ie all the original values) like is proposed http://www.asp.net/learn/dataaccess/tutorial21vb.aspx?tabid=63 . This... works however I really do not want to have to pass in ALL these values (ie original and new).Ideally I would like to be able to use the primary key & the datetime field to handle the Optimistic Concurrency checks where only the original values of both those fields are passed back into the stored procedure. Now.. I tried this as well, but I kept getting an error that suggests that (for some reason) the FormView or DataSource is passing ALL the values (original & new) into the dataset as opposed to only the original primary key & datetime fields & the new set of values.Can ANYONE offer any help? I really would like not to have to pass in all these values.Thanks in advance! 

View 6 Replies View Related

How To Enable Optimistic Concurrency

Jul 25, 2006

I have a number of SqlDataSource objects in my application, which don't have Optimistic Concurrency option enabled. The SDS objects use custom Sql statements so I can no longer select the Advance button to enable Concurrent Concurrency.
How can I enable this option? Is there a designt ime property, and even a run time property that can be set?
The only method we have so far is to create a new SDS, with Optimistic Concurrency switched on, then copy and paste my custom Sql into it and rebind my components..
Any help on this matter is appreciated.
Regards,
Steven
 
 

View 2 Replies View Related

Msde And Optimistic Concurrency

Apr 2, 2006

hello allI am working with the visual studio web express using MSDE as sql server.Every thing is working fine with database except when working with optimistic concurrency.So if I have a GridView or FormView binded to a SqlDataSource that is configured to perform the concurrency, these controls can't perform the update to the database.From debugging, I found that the SqlDataSource Old Value Paramters always null after postback.Is this a bug in the WebExpress, or do I need to use the SqlExpress Edittion?Thanks in advance, and keep the good effort.Hesham

View 1 Replies View Related

Rowlock V. Optimistic Concurrency

Feb 8, 2008

Hi,Sql-Server 2000, 2005.A report fetches a lot of rows using the "WITH (ROWLOCK)" syntax (thesql is generated on the fly by a tool and not easily changeable).SELECT col1, col2 FROM mytab WITH (ROWLOCK) WHERE ...."The select-clause runs for several minutes.Another user fetches one of those rows and tries to update it. Theresult is a lock timeout.I suppose that the long running select-clause has put a shared lock onthe rows and the updater (exclusive-lock) will have to wait for thelong-running select and so the lock timeout is expiring.Are all those rows "shared locked" until all are fetched?Would there be any change if the "WITH (ROWLOCK)" is removed, isn'talthough "shared lock" the default behaviour?The "WITH (NOLOCK)" would probably help?What about the definition of optimistic concurrency, shouldn't allselect-clauses contain "WITH (NOLOCK)" to allow an optimisticconcurrency scenario?Regards Roger.PS. Probably some misunderstanding from me here, but this should bethe right place to get it right.

View 8 Replies View Related

Concurrency Control

Apr 6, 2005

Hi! I'm building a web application with ASP.NET, and using MS SQL 2000 for my database server.
How should I do to guarantee the integrity of the data in spite of the concurrent access? Meaning... how can I make sure that more than 1 user can update 1 table at the same time, while no error will occur? Do I need to add some codes at my aspx file? Or do I need to do something to my database? Or do I not have to worry about it?
Thank you.

View 1 Replies View Related

Concurrency Control

Mar 5, 2008

I created an ETL Process which loads four different types of files into different tables in parallel. There is no issue with this parallelism as the sources and destinations are distinct. But I have a common log table where I log the status and timings of each load for any file type. When ever I start a new file load, I create an entry in this log table with the FileTypeID and LoadInProcess as 1 (this will be set to 0 for all other records of the same file type). At different stages of the load, I will pull the active LoadID of the current file type and update the same record with the timings and results. My code looks like this -





Code Snippet
SELECT

@LoadLogKey = LoadLogKey
FROM

SystemLoadLog (NOLOCK)
WHERE

FileTypeID = 1 and LoadInProcess = 1


IF @LoadLogKey is NULL

RAISERROR('Unable to retrive LoadLogKey for the current load!')

***Process1 Query
***Process2 Query
***Process3 Query

UPDATE

SystemLoadLog
SET

Process1Result = x,
Process2Result = y,
Process3Result =z
WHERE

LoadLogKey = @LoadLogKey






The first SELECT query is giving problems as different processes are using the same table to log the results and timings. The source files I load are too small that the data load finished in 1 or 2 seconds most of the time and within this timespan, I update the log atleast 10 times. So, if four different file types are loading, the hits to the SystemLoadLog can be as bad as 20 to 30 times in 1 second.

Can anyone let me know how to handle this?

Thanks in Advance!!!
Harish

View 3 Replies View Related

Timestamp Concurrency Control With SQLDataSource

Nov 10, 2005

I am trying to use a 'timestamp' type column with SQLDataSource for concurrency control with SQL Server.  I'm getting the following error:
Operand type clash: timestamp is incompatible with sql_variant
It appears that the problem is that the value for the Type property of the Parameter (which was generated by the SqlDataSource wizard) is Object which maps to 'sql_variant' rather than to 'timestamp'.
I know that the older way of doing things with SqlDataAdapter, SqlCommand, SqlParameter can handle timestamps because SqlParameter has a SqlDbType property that can have a value of SqlDbType.Timestamp, but I don't see how to do this with the newer SqlDataSource, Parameter classes because the Parameter.Type property (of type TypeCode) doesn't have a Timestamp value.
Has anyone been able to use a 'timestamp' type field with SqlDataSource?
Here's my sample code:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MyTestPage.aspx.cs" Inherits="MyTestPage" %><!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"><title>Untitled Page</title></head><body><form id="form1" runat="server"><div><asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"EmptyDataText="There are no data records to display." DataKeyNames="MyID"><Columns><asp:CommandField ShowEditButton="True" /><asp:BoundField DataField="MyID" HeaderText="MyID" InsertVisible="False" ReadOnly="True"SortExpression="MyID" /><asp:BoundField DataField="MyDesc" HeaderText="MyDesc" SortExpression="MyDesc" /></Columns></asp:GridView><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"ConnectionString="<%$ ConnectionStrings:CtrlConnectionString1 %>" DeleteCommand="DELETE FROM [MyTest] WHERE [MyID] = @original_MyID AND [MyDesc] = @original_MyDesc AND [timestamp] = @original_timestamp"InsertCommand="INSERT INTO [MyTest] ([MyDesc], [timestamp]) VALUES (@MyDesc, @timestamp)" OldValuesParameterFormatString="original_{0}"ProviderName="<%$ ConnectionStrings:CtrlConnectionString1.ProviderName %>" SelectCommand="SELECT [MyID], [MyDesc], [timestamp] FROM [MyTest]"UpdateCommand="UPDATE [MyTest] SET [MyDesc] = @MyDesc WHERE [MyID] = @original_MyID AND [MyDesc] = @original_MyDesc AND [timestamp] = @original_timestamp"><DeleteParameters><asp:Parameter Name="original_MyID" Type="Int32" /><asp:Parameter Name="original_MyDesc" Type="String" /><asp:Parameter Name="original_timestamp" Type="Object" /></DeleteParameters><UpdateParameters><asp:Parameter Name="MyDesc" Type="String" /><asp:Parameter Name="timestamp" Type="Object" /><asp:Parameter Name="original_MyID" Type="Int32" /><asp:Parameter Name="original_MyDesc" Type="String" /><asp:Parameter Name="original_timestamp" Type="Object" /></UpdateParameters><InsertParameters><asp:Parameter Name="MyDesc" Type="String" /><asp:Parameter Name="timestamp" Type="Object" /></InsertParameters></asp:SqlDataSource></div></form></body></html>

View 3 Replies View Related

Concurrency Violation Error!

May 16, 2006

Hiim keep getting  the following errorConcurrency violation: the UpdateCommand affected 0 recordsI dunno whats wrong, im the only person using the database and program at the moment.Anyone know what im doing wrong?thanks 

View 1 Replies View Related

Optimistic Vs. Pessimistic Locking

Oct 19, 2006

I am confused, I'll admit that outright.

A lot of entries in these forums recommend optimistic locking for most cases. Well, I have a very simple case (like everyone else, I bet :-)) and it seems to me pessimistic locking is the right answer:

User A loads an item on screen for maintenance. When user B wants to load the same item on screen for maintenance, he/she should be presented with a message "Item in use by someone else". That way they know they can't perform maintenance on the item (as yet). This can be achieved with pessimistic locking, by locking the row that is being loaded for maintenance and only unlocking it after an update or after another item is loaded in maintenance. The lock would be in update mode. This way the record cannot be modified but queries (for reporting or lists) in other parts of the system would still work fine.

The alternative in this case would be to allow both users to load the item on screen for maintenance, allow both of them to make changes and allow both of them to save -- one of them will save, the other would be stopped and another message will pop up, "Item already changed". This can be acheived with optimistic locking, by just allowing the engine to do its job.

While both approaches work, I strongly consider the first one to be more user friendly. Noone looses any changes they made, they know they have to wait for the item to become available and everything's peachy (granted, loading the item on screen and then leaving for an extended lunch may trigger some unpleasant after effects :-)).

Apart from the pessimistic update mode lock in the first case, is there any other (read better, safer, recommended) way to achieve this?



Thank you,

View 5 Replies View Related

Error Control

Aug 30, 2007



hi,
I'm trying to insert files from one table to anotherone. The problem is that the source table doesnt have any primary key, and it has duplicated PK that the destination needs to be unique. It's possible to ignore this kind of errors? I am using an OLEDB Destination transformation, and trying to omit this error configuring the error output, but it doesnt work.


Thanks!

View 6 Replies View Related

SqlDataSource Control Error

Jan 19, 2007

Hello:
I am having a little issue with an error that is frustrating me. I have a SqlDataSource within an asp:label control and also have a two dropdownlists inside that asp:label control also. When I select from the first dropdownlist, it should enable the second dropdownlist with the populated data, but instead I receive.
The SqlDataSource control 'sqlGetMLSByCity' does not have a naming container.  Ensure that the control is added to the page before calling DataBind.
Any ideas why this would be? Here is the web from portion:
<asp:Label ID="recip_form_request" runat="server" Visible="false">    <ul>        <li>Step one: Select listing type.</li>        <li>Step two: Select the City that you are reciprocating to.</li>        <li>Step three: Complete the Recip Form.</li>    </ul>    <asp:DropDownList ID="recip_form_type" runat="server" AutoPostBack="true" Visible="False">        <asp:ListItem Value="0" Text="(Select Form)"></asp:ListItem>        <asp:ListItem Value="1" Text="Residential"></asp:ListItem>    </asp:DropDownList>    <br />    <asp:DropDownList ID="outside_assoc_cities" runat="server" AutoPostBack="True" Enabled="False" DataTextField="city" DataValueField="id" Visible="False"></asp:DropDownList><br />    <asp:Label ID="city_mls_desc" runat="server"></asp:Label><br />    <asp:Button ID="page1_btn" runat="server" Text="Next >>" Visible="False" />    <asp:SqlDataSource ID="sqlCities" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ AppSettings:connectionstring %>" SelectCommandType="Text" SelectCommand="SELECT id, city FROM  tCityMaster"></asp:SqlDataSource>    <asp:SqlDataSource ID="sqlGetMLSByCity" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ AppSettings:connectionstring %>">        <SelectParameters>            <asp:ControlParameter ControlID="outside_assoc_cities" Name="City" />        </SelectParameters>    </asp:SqlDataSource></asp:Label>
then the code behind:
Protected Sub outside_assoc_cities_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles outside_assoc_cities.SelectedIndexChanged        If outside_assoc_cities.SelectedIndex > -1 Then            Dim ItemId As Integer = Integer.Parse(outside_assoc_cities.SelectedValue)            Dim MLSID As String = Nothing
            Dim cmd As New SqlCommand            Dim con As New SqlConnection            cmd.Connection = con
            Dim sqlGetMLSByCity_sql As SqlDataSource = CType(Page.FindControl("sqlGetMLSByCity"), SqlDataSource)            'using connectionstring from SqlDataSource Control            con.ConnectionString = sqlGetMLSByCity_sql.ConnectionString            'con.ConnectionString = sqlGetMLSByCity.ConnectionString
            cmd.CommandType = CommandType.Text            cmd.CommandText = "SELECT mls_id FROM pwaordev..tCityMaster WITH(NOLOCK) WHERE ID=@ID"
            cmd.Parameters.Add("@ID", SqlDbType.Int, 4).Value = ItemId
            Try                con.Open()                MLSID = cmd.ExecuteScalar                con.Dispose()                cmd.Dispose()            Catch ex As Exception                con.Dispose()                cmd.Dispose()                Response.Write(ex.ToString())            End Try
            'Further logic to display button depending on MLS            If Not String.IsNullOrEmpty(MLSID) Then                If MLSID = "B" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is Greater South Bay MLS."                    page1_btn.Visible = True                ElseIf MLSID = "A" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is Big Bear BOR, MLS, which is not covered by Pacific West Association of REALTOR&reg, please contact us for more information."                    page1_btn.Visible = False                ElseIf MLSID = "C" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is Combined L.A./Westside MLS."                    page1_btn.Visible = True                ElseIf MLSID = "F" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is Crisnet MLS, which is not covered by Pacific West Association of REALTOR&reg, please contact us for more information."                    page1_btn.Visible = False                ElseIf MLSID = "Y" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is DCAoR - Yucca Valley Area, which is not covered by Pacific West Association of REALTOR&reg, please contact us for more information."                    page1_btn.Visible = False                ElseIf MLSID = "D" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is Desert Area MLS."                    page1_btn.Visible = True                ElseIf MLSID = "L" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is i-Tech Glendale/Pasadena."                    page1_btn.Visible = True                ElseIf MLSID = "M" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is MRM - Multi-Regional MLS."                    page1_btn.Visible = True                ElseIf MLSID = "R" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is RIM - Rim of the World MLS, which is not covered by Pacific West Association of REALTOR&reg, please contact us for more information."                    page1_btn.Visible = False                ElseIf MLSID = "G" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is SDI - San Diego, which is not covered by Pacific West Association of REALTOR&reg, please contact us for more information."                    page1_btn.Visible = False                ElseIf MLSID = "S" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is SOCAL MLS - Southern California MLS."                    page1_btn.Visible = True                ElseIf MLSID = "T" Then                    city_mls_desc.Text = "The MLS system that covers " & outside_assoc_cities.SelectedItem.Text & " is Outside Area, which is not covered by Pacific West Association of REALTOR&reg, please contact us for more information."                    page1_btn.Visible = False                End If                'test.Text = MLSID                'If test.Text = "L" Then                'mls_text.Text = "i-Tech"                'End If            End If        End If    End Sub
Any help would be great, thank you!

View 1 Replies View Related

Out Of Control Error Logs

Jan 2, 2001

I have recently uncovered a problem we are experiencing with SQL Server 6.5 Service Pack 4 (Don't ask) and wonder if anyone has seen this before, and maybe has a solution.

When viewing an errorlog either current or historic, via either enterprise manager of xp_readerrlog, occassionaly the network connection is dropped and the process runs out of control. The process is unkillable, as it is in a 'Critical Section' and does not respond to kill. The real problem is that the process is logging millions of errors of the form "...cannot send results to the front end..." at a rate of around 1GB / hour.

Any help would be much appreciated.

Cheers
BP

View 1 Replies View Related

Error While Connect To SQL Server Using ADO Control

Jun 22, 2006

The following error happens in my ASP.NET page from time to time. It will disappear after I restart the SQL Server. I guess I messed up in the garbage collection, but I really don't know what to do except using "conn=nothing" statement, can anyone help me with this?
Thanks!
 
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. 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.Runtime.InteropServices.COMException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.Source Error:



Line 39: Public Sub New()
Line 40: conn = New ADODB.Connection
Line 41: conn.Open("Provider=SQLOLEDB.1;Persist Security Info=xxxxx;User ID=xxxxx;Initial Catalog=xxxx;Data Source=xxx")
Line 42: rs = New ADODB.Recordset
Line 43: my_UserID = 0

View 7 Replies View Related

Error Trapping Of Datasource Control

Oct 1, 2007

Hello,
I encountered an interesting situation. I have a gridview and a sqldatasource. It has delete function. When I delete a record an error of foreign key violation is raised. I would like to trap this error and give a user friendly message to the user.
If I use ADO.Net I can use Try/Catch, but it seems there is no way to do the same thing using datasource. Anyone knows?
Thank you,
J

View 6 Replies View Related

Do We Control Over Sql Server Error Log Files ?

May 9, 2001

Hi, everybody
I am trying to run job that will
look for errors in error log files and save it to text file
In order to get up to last minute infromation I am using errorlog

1. at what point errorlog ranamed to errorlog1?
2. Can configurate size of errorlog file ?
3. Can I configurate time when errorlog ranamed to errorlog1

when i run in Sql Query analyser
print '------------ level 16 from last Sql errorlog file ----------------'
print 'These messages indicate errors that can be corrected by the user '
USE master
EXEC xp_cmdshell 'findstr /i /n /c:"level 16" InnvisionGMSSQL7LOGerrorlog.*'
go

I getting output
------------ level 16 from last Sql errorlog file ----------------
These messages indicate errors that can be corrected by the user

(0 row(s) affected)

when my job saves this command to file
I getting output
------------ level 16 from last Sql errorlog file ---------------- [SQLSTATE 01000]
These messages indicate errors that can be corrected by the user [SQLSTATE 01000]

How replace [SQLSTATE 01000] on user friendly message

Thanks

View 2 Replies View Related

SQL Server Error Log - Growing Out Of Control

Sep 3, 1998

In the past month and a half I have had the SQL Server error log on one of my SQL Server 6.0 servers eat up ALL the free disk space on the partition containing SQL Server and the databases/devices.

This means that the error log gets to be about 3 GB in size!

When I try to run a `tail` against the error log to determine what errors might be filling up the log, I get `garbage` like it`s not really a text file. This has indicated to me that the error log is somehow becoming corrupt.

Anybody have similar experiences or suggestions?

Thanks!

View 1 Replies View Related

Issue With SSRS Report Exporting To Excel With The Matrix Control Inside The Table Control

Jan 27, 2008

Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.

With Thanks
M.Mahendra

View 5 Replies View Related

Is It Possible To Embbed And Ocx Control On A Report Or Some Sort Of Interactive Control Like A Flash.ocx?

Oct 25, 2007

does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.

View 1 Replies View Related

Error While Using Database Procedure In A Gridview Control

Dec 19, 2006

Dear Forum,
I have a gridview control  which is associated to a storedprocedure  with a parameter(Customer Number) to be supplied.  In the Define Custom Statement or stored procedure section  I selected stored procedure and selected the stored procedure.  The Define Parameter window I defaulted the Parameter Source as 'none' and default value as '%'.   In the next screen, I do a test query which retuns the following error
There was an error executing the query.  Please check the syntax of the command and if present, the type and values of the parameters  and ensure that they are correct.
[Error 42000] [Microsoft][ODBC SQL Server Drive][SQL Server] Procedure 'SP_TransactionDetails' expects parameter '@cnum' which was not supplied.
I am using SQL server studio  2005 version2.0. 
But the same procedure, if I use as SQL Statement, it works.
Can somebody help me.
Thanks,
Hidayath 

View 3 Replies View Related

SqlDataSource Control Error When Trying To Sort The Data

Feb 5, 2007

Hello:I forgot what to do in a case like this. I have a SqlDataSource control within a label and I want to allow auto sorting, but when I click on the sort link the page comes back with:The SqlDataSource control 'sqlViewIncompleteForms' does not have a naming container.  Ensure that the control is added to the page before calling DataBind.[HttpException (0x80004005): The SqlDataSource control 'sqlViewIncompleteForms' does not have a naming container.  Ensure that the control is added to the page before calling DataBind.]   System.Web.UI.WebControls.DataBoundControlHelper.FindControl(Control control, String controlID) +1590679   System.Web.UI.WebControls.ControlParameter.Evaluate(HttpContext context, Control control) +76   System.Web.UI.WebControls.Parameter.UpdateValue(HttpContext context, Control control) +46   System.Web.UI.WebControls.ParameterCollection.UpdateValues(HttpContext context, Control control) +103   System.Web.UI.WebControls.SqlDataSource.LoadCompleteEventHandler(Object sender, EventArgs e) +40   System.EventHandler.Invoke(Object sender, EventArgs e) +0   System.Web.UI.Page.OnLoadComplete(EventArgs e) +2010392   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1209How do I over come this? Do I have to use the find control method on page_load? Here is the code portion .vb<%  'Label which contains the default.aspx home content %><asp:Label ID="recip_home_display" runat="server" Visible="false">    <div align="center" class="HeaderSmall">Incomplete Recip Submissions</div>    <asp:GridView ID="RecipStatusGridView" runat="server" AutoGenerateColumns="False" BorderWidth="0px" DataKeyNames="queue_id"        DataSourceID="sqlViewIncompleteForms" AllowPaging="True" AllowSorting="True" CellPadding="2" CellSpacing="2" CssClass="TextSmall" HorizontalAlign="Center" Width="500px" Visible="False">        <Columns>            <asp:BoundField DataField="queue_id" HeaderText="Incomplete Listings" HtmlEncode="False"                InsertVisible="False" ReadOnly="True" SortExpression="queue_id">                <ControlStyle CssClass="LinkNormal" />                <ItemStyle HorizontalAlign="Center" />                <HeaderStyle HorizontalAlign="Center" />            </asp:BoundField>            <asp:BoundField DataField="form_type" HeaderText="Listing Type" SortExpression="form_type">                <ItemStyle HorizontalAlign="Center" />                <HeaderStyle HorizontalAlign="Center" />            </asp:BoundField>            <asp:BoundField DataField="listing_address" HeaderText="Listing Address" ReadOnly="True"                SortExpression="listing_address">                <ItemStyle HorizontalAlign="Center" />                <HeaderStyle HorizontalAlign="Center" />            </asp:BoundField>            <asp:BoundField DataField="last_modified_date" DataFormatString="{0:d}" HeaderText="Last Modified"                HtmlEncode="False" SortExpression="last_modified_date">                <ItemStyle HorizontalAlign="Center" />                <HeaderStyle HorizontalAlign="Center" />            </asp:BoundField>        </Columns>        <HeaderStyle BackColor="#5C6F8D" />        <AlternatingRowStyle BackColor="#e9eaf0" />    </asp:GridView>    <asp:SqlDataSource ID="sqlViewIncompleteForms" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ Appsettings:connectionstring %>" SelectCommandType="StoredProcedure" SelectCommand="spGetIncompleteForms">    <SelectParameters>        <asp:ControlParameter ControlID="active_member_id" Name="AgentId" />    </SelectParameters></asp:SqlDataSource></asp:Label>

View 1 Replies View Related

User Control Data Access Error

Mar 3, 2008

When creating a user control (ascx) and registering it in the webpage, an error occurred:
"Login failed for user ''. The user is not associated with a trusted SQL Server connection."
This error does not appear when creating data access normally, and I don't use username/password for the northwind database; any suggestions.

View 5 Replies View Related

Help! Jump To Report: Error With Web Reportviewer Control

Jan 14, 2008

Hello everyone,
I have a report that has a "Jump to report:" link in it and in the report it jumps to there is another "Jump to report:" link. When I click on this link I get the following error.

The path of the item '(null)' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)


I have tried moving the link from the header to the body of the report with the same results.

This is only happening in the web reportviewer control as our windows app works flawlessly.

We are running SQL SERVER 2005 SP2.


Does anyone have a fix, workaround or idea how to resolve this issue?

Thanks in advance

-JW

View 13 Replies View Related

Error On Reporting Server - But Only Through The ReportViewer Control

Apr 11, 2006

We are using the webviewer control.

We get the following error when we try to export to EXCEL.



InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.



This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.

The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.

And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.

So what was the above error all about????

Does anyone have any ideas that I can look into?

Thanks!

View 6 Replies View Related

How To Control Error Log File In SQL Server 2005 Express?

Dec 30, 2007

I attached a SQL database called Cars, using the following code:




Code Block

IF NOT EXISTS(
SELECT *
FROM sys.databases
WHERE name = N'Cars'
)
CREATE DATABASE Cars
ON PRIMARY (FILENAME = 'C:DataServer FilesCars.mdf')
FOR ATTACH
GO






I then detached the database using:




Code Block

EXEC sp_detach_db @dbname = 'Cars'
,@skipchecks = 'true'
,@KeepFulltextIndexFile = 'true'
GO





I then copied the .mdf and .ldf to another folder, using Windows Explorer.

I then attached the database using the new folder name in my code.:




Code Block

IF NOT EXISTS(
SELECT *
FROM sys.databases
WHERE name = N'Cars'
)
CREATE DATABASE Cars
ON PRIMARY (FILENAME = 'C:DataNew FolderCars.mdf')
FOR ATTACH
GO







Now when I go to update my table, I see that I am hitting the .mdf in the new folder.

And, when I do my table updates, I see that I am hitting the .ldf in the old folder.

Two questions:
1. What did I do wrong, that updates are hitting the new .mdf, but the old .ldf?
2. How do I control what .ldf SQL Express uses?

I see references to 'SQL Server Agent' in the help pages, but do not see 'SQL Server Agent' within the application.

I see the reference to the old folder path, within the 'Database Properties Files page', but no possibity to edit the value.


View 5 Replies View Related

Copy And Paste Control Flow Item Error

Mar 26, 2008

Hi,

I'm trying to copy and paste an 'Execute SQL Tasks' within one of my packages.

I've managed to solve the copy part of the problem by registering the following dlls:



regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
However, I can't paste the copied task onto my control flow. When I paste I get the following error:

The designer could not paste one or more executables.
Additional information:
At least one executable could not be pasted correctly.
the executable with the name 'Record Row Count' could not be pasted successfully.
Information about the state of the executable with the name
'Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' could not be loaded from the clipboard.
Exception from HRESULT: 0xC0010028 (Microsoft.DataTransformationServices.Design)

Any help getting this fixed would be appreciated.

Tom

View 5 Replies View Related

Unable To Load Client Print Control ERROR

Mar 12, 2007

Only one of our users is getting this error

unable to load client print control

She was able to print fine before, any idea why this is happening.

View 1 Replies View Related

Control Flow Task Error Shouldn't Fail Package

Mar 1, 2007

Hi all,

I have a Send Mail Task in my control flow to notify users that the processing is done. I want to avoid the package to fall in error if the Send Mail task failed.

What is the best practice to do that ?

Should I raise the MaximumErrorCount of theSend Mail Task ? Should I play with ErrorHandler ?

 

View 1 Replies View Related

Windows Control Library In A Webpage Accessing Sql Has A Security Error

Aug 23, 2006

I know this should be the easiest thing in the world but I cant seem to find out how to allow my windows control library dll which is loaded in a webpage to access sql.
It works perfectly from within visual studio though, what do I need to do allow my webpage dll to access sql without throwing a security exception?
Any links or help would be greatly appreciated.

View 1 Replies View Related

Error Handling Prevents Control Flow From Stopping. Is This Correct Behavior?

Dec 20, 2007



I have two tasks on a control flow. First task is Execute SQL task which drop an index. Second one is a Data Flow task. I also have an error handler for packcage_onerror. Because there is no index in the database, the first task rasies an error and package on error catches the error. The precedence constraint for the Data Flow task in "success". I don't expect the data flow task to execute because of the error. But it does. Is this the right behavior because I have already handle the error? I don't want the the job to continue if there is any error. I believe I should raise error in the error handler. Pleae help me how to do this. Thanks

View 12 Replies View Related

WMI File Watcher In Control Flow Issues Quota Violation Error

May 22, 2008

My SSIS control flow includes a standard "textbook" WMI Event Watcher Task that monitors a folder for incoming files. Generally it works fine, but now I regularly see the error message:

"Watching for the Wql Query caused the following system exception: "Quota Violation." Check the query for errors or WMI connection for access rights/permissions"


I do not see any indication of trouble in the event logs. The SSIS log simply states that it failed.

Is there any magic about WMI Event Watcher?

When I restart, it runs fine for hours.

SQL05 is 9.0.3054 on W2003 with all microsoft updates applied. It is basically a bare machine with SQL Server, SSIS running and a service that kicks in occasionally.

Thanks for reading!

View 3 Replies View Related

Please Help This Should Be Simple Trying To Use Variables With A Copy DB Control Flow, Ssis Reports Following Error:

Dec 26, 2007

Why isn't there some documentation on how to do this. This should be really simple and it has taken me 2 weeks and I still haven't gotten an answer. Please Help Does anyone know the answner or some place where there is some documentation!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I get the following error when I try to substitute the strings in the databasedetails collection with variables:
Error: Object reference not set to an instance of an object. StackTrace: at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.CheckLocalandDestinationStatus(Database srcDatabase, DatabaseInfo dbDetail) at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSpAttachDetach()

I created the following variables:
strDestinationDB = AirCL2Exp_new3
strDestinationDBPath = C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDATAAirCL2Exp_new3_Data.mdf
strDestinationLGPath = C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDATAAirCL2Exp_new3_Data.ldf
strSourceDB = AirCL2Exp
strSourceDBPath = C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDataDataNewAirCL2Exp_Data.mdf
strSourceLGPath = C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLDataDataNewAirCL2Exp_Log.ldf

I then assigned those variable to DatabaseDetails Collection:

DatabaseName = @strSourceDB
DestinationDatabaseName = @strDestinationDB

Inaddtion I also assigned the following to the two DatabaseFiles Collection:
for 0:
DatabaseFileSize = 0
DestinationFilePath = @strDestinationDBPath
FileType = DatabaseFile
SourceFilePath = @strSourceDBPath
SourceSharePath = @strSourceDBPath

for 1:
DatabaseFileSize = 0
DestinationFilePath = @strDestinationLGPath
FileType = LogFile
SourceFilePath = @strSourceLGPath
SourceSharePath = @strSourceLGPath

View 13 Replies View Related

Reporting Services :: Error Unable To Load Client Print Control

Nov 16, 2015

We have recently upgraded our .Net web application from a windows 2003 server to a windows 2012 server. Since this happened users that are trying to print a reporting services report is getting the error "Unable to load client print control". We are using reporting services 2012, but the application is using the 8 version of the viewer. The reporting services server did not change only the application server. The code for the application did not change.

View 4 Replies View Related







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