Resolver Is Either Missing Or Incorrect
Oct 18, 2006
Hi all sql guru's
I'm having this problem for a while now and can't find any solid answer on the net for it.
I have 2 server in diffrent location ( +- 1200k's) away from eachother. When the msmerge agent run it return the following error and return the status as successfull with the following error information:
(The colum information specified for the MS SQL Server maximum conflict resolver) Resolver is either missing or incorrect. I've change every single article to "Latest chagne wins". Any suggestion. I happend when the power failed and the server got restarted.
View 1 Replies
ADVERTISEMENT
Dec 1, 2007
I built my package on my development machine with a config file at a given location. Let's say:-
C:DevelopmentdtsConfig.xml
Then I shipped my package to the Production machine and ran my package (in a .bat file) as follows:-
DTExec /FILE "C:ProductionPackage.dtsx" /CONFIGFILE "C:ProductiondtsConfig.xml"
But I get the following output:-
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:01:27 PM
Warning: 2007-11-30 22:01:29.52
Code: 0x80012012
Source: Package
Description: The configuration file name "C:DevelopmentdtsConfig.xml" is not valid. Check the configuration file name.
End Warning
...
But then it goes on to read values from my Production config file.
How can I stop the annoying warning about my Development config file-path (which doesn't exist on the Production machine)
Thanks
View 6 Replies
View Related
Jan 26, 2006
Hi there,
I have created a custom conflict resolver for an article that is using Merge replication. I can register my custom resolver OK, I can change my merge article to use my new custom resolver, but when a conflict occures the replication monitor shows the following errors:
Error messages:
No signature was present in the subject.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2146762496)
Get help: http://help/MSSQL_REPL-2146762496
The Custom Resolver Component for article 'BRANCH' does not have a valid digital signature. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147198713)
Get help: http://help/MSSQL_REPL-2147198713
At first I thought it was because my assembly wasn't signed, so I signed it. I still get the same error.
I have various debug statements in the assembly and I can see that Initialize and HandleChangeStates gets called ok, but no other overrides.
Can anyone help me please?
Thanks
Graham
View 3 Replies
View Related
Jan 18, 2007
Hi Everyone!
Here another post on replication.
When conflict occur, I want the user to be able to select witch row to keep and witch to delete.
I've look for system stored procedure, that could help me do the resolution but I've founded nothing.
So I've thought that I could do it by hand, with UPDATE/DELETE query
Take the row in the %TABLE_NAME%_Conflict table and copy it into the real table, than delete the row.
I this the good way of doing it?
Is there any other way?
Thanks !
View 5 Replies
View Related
Sep 26, 2007
Hi all,
here is the context of our problem:
- Publisher : version SQL Server 2005 SP2, table in SQL Server 2000 (80) compatibility level, publication in SQL Server 2000 compatibility level
- Distributor : SQL Server 2005 SP2
- Subscriber : SQL Server 2000 SP4 + hotfixes (version 8.00.2187)
There is only one article in our publication (a simple table with a GUID and a nvarchar(50) columns), and we have left the default resolver.
1 - The first synchronization of the subscription is successfully completed, and it is the same for the different updates/inserts/deletes or conflicts.
2 - Then we change the Resolver of our article by our own COM-Based Custom Resolver (developped in C# 2.0). This resolver only change the default behaviour: the subscriber always win (this is for a test, in the future we will have a complex business logic). All the synchronizations works fine and do what we want in the conflicts.
3 - We rollback the resolver to the default one... and here is the problem!
The synchonizations stop to work correctly. For all of them we've got the same error:
quote:Replprov.dll , 2007/09/25 14:26:07.591, 4000, 16890, S1, ERROR: ErrNo = 0x80045017, ErrSrc = <null>, ErrType = 8, ErrStr = The schema script '
declare @cmd nvarchar(1000)
set @cmd='exec sys.sp_MSchangearticleresolver @article_resolver=@ar, @resolver_clsid=@rc, @artid=@ai, @resolver_info=@ri'
exec dbo.sp_executesql @cmd, N'@ar> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie..." mailto:N?@ar">N'@armailto:N'@ar">N'@ar</A< A>> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie...
It is no more possible to synchronize this subscription... Any remark will be helpfull cause we did not find anything on the net concerning this error.
Thanks a lot!
View 1 Replies
View Related
Sep 7, 2006
Hi there!
I'm trying to create a custom resolver for merge replication exactly like in the MS example.
It seems to work, but only ONE time. If I change, insert or delete a
record in a table the second time, the subscriber monitor comes with
the following errors:
Error messages:
Attempted to read or write protected memory. This is often an
indication that other memory is corrupt. (Source: MSSQL_REPL, Error
number: MSSQL_REPL-2147199411)
The Merge Agent encountered an error when executing code in the
'UpdateHandler' method implemented in the business logic handler
'D:Program FilesMicrosoft SQL Server90COMMyResolver.dll'. Ensure
that the overridden 'UpdateHandler' method has been properly
implemented in the business logic handler. (Source: MSSQL_REPL,
Error number: MSSQL_REPL-2147199411)
This last error is of course dependant on my action (update, delete, insert).
My code is -exactly- like the example (I just stripped out the log message).
Does anyone know why I am "trying to read or write protected memory" ?
The thing is that I'm trying to create an application that detects if a
table changes. Is this the right way to do this anyway or are there
better solutions?
Any help is appreciated! Thanks!
View 13 Replies
View Related
Nov 6, 2006
Hello,
I'm trying to setup the Interactive Conflict Resolver in my C# app via RMO. (using SQL Server 2005)
The only article I can find on MSDN or anywhere is involing T-SQL. Can someone please shed some light on this for me specificaly on the subscriber side.
Thank you! Chris
View 2 Replies
View Related
Jan 22, 2007
Hi,
I have created a custom resolver in VB .net (VS2005). The resolver works ( Both Publisher and Subscriber are SQL 2005 ), but I need to be able to debug the code within the resolver. How do I do this? I have tried a number of things without success.
Any suggestions would be appreciated.
Cheers
Neil
View 3 Replies
View Related
Sep 20, 2005
Hi, I'm replicating a database between two instances of Sql 2000 using Merge Replication. I have no custom resolvers at present but I'm seeing something unexpected.
View 5 Replies
View Related
Oct 2, 2006
Hi all,
I need to write a custom conflict resolver for an application using merge replication. It's relatively simple logic - compare the two rows from the publisher and the subscriber and the winner is based on the value of one particular column.
Reading BOL gives me the input parameter list for the sp, and specifies that the output should be exactly the winning row. What is doesn't give is any example of how to do this, in particular how to access the two rows in conflict so that they can be compared.
I can do this by dynamically building SELECT statements, one connecting to the table locally on the publisher and another connecting to the subscriber using the form SERVER.DATABASE.OWNER.TABLE, but this requires me to explicitly have the subscriber as a linked server to do this. An example of my revolting code is appended to this post.
Is this what I have to do, or is there some table I can access on the publisher that has the conflicting rows in so I can compare them without going back to the subscriber?
Thanks for your help
Richard
---- code sample --
ALTER PROCEDURE [dbo].[prRep_ResolveInventoryConflicts]
@tableowner sysname, @tablename sysname, @rowguid uniqueidentifier,
@subscriber sysname, @subscriber_db sysname,
@log_conflict int OUTPUT, @conflict_message nvarchar(512) OUTPUT,
@destination_owner sysname
AS
BEGIN
DECLARE @qrySubscriber varchar(255)
DECLARE @qryPublisher varchar(255)
DECLARE @Publisher sysname
DECLARE @RecentCheck datetime
-- Temp table with same form as tbl_Inventory
CREATE TABLE #ConflictingRows (
[Machine] [sysname]NOT NULL,
[LocationID] [int] NOT NULL,
[PartGUID] [uniqueidentifier] NOT NULL,
[Qty] [int] NOT NULL ,
[LastUpdatedDtm] [datetime] NOT NULL,
[LastUpdatedUser] [varchar](50) NOT NULL ,
[rowguid] [uniqueidentifier] NOT NULL
)
-- Build the T-SQL To run against publisher and subscriber
SET @Publisher = @@Servername
SET @qryPublisher =
'INSERT INTO #ConflictingRows
SELECT '+@Publisher+' as Machine, * FROM '+@tableowner+'.'+@tablename+
'WHERE rowguid = '+CAST(@rowguid as varchar(40)) +';'
SET @qrySubscriber =
'INSERT INTO #ConflictingRows
SELECT '+@subscriber+ ' AS Machine, * FROM '+@subscriber+'.'+@subscriber_db+'.'+@tableowner+'.'+@tablename+
'WHERE rowguid = ' + CAST(@rowguid as varchar(40)) +';'
-- execute the stored procedures
EXECUTE @qryPublisher;
EXECUTE @qrySubscriber;
-- Compare the two rows and return the winning row, ie the one that was last updated by a human checking the inventory
SELECT @RecentCheck = MAX(LastUpdatedDtm) FROM #ConflictingRows
SELECT TOP 1 * FROM #ConflictingRows where LastUpdatedDtm=@RecentCheck;
-- Cleanup and exit
DROP TABLE #ConflictingRows
END
----
View 11 Replies
View Related
Dec 5, 2006
Hi!
I'm trying to create a custom conflict resolver for SQL Server 2000 in
C# but i can't seem to find any source code examples of a *.dll where i
can actually see what needs to be done.
Any help is welcome.
Thanks
View 3 Replies
View Related
Dec 21, 2006
Hi everyone,
I am working on a COM-based custom conflict resolver (vb.net) for a merge replication problem that I am having. This is what I am trying to accomplish. 1. Have a Last_Upd_Dt column. 2. When there is a conflict between publisher and subscriber on a column, the winner is the most recent date in Last_Upd_Dt and want the value for that column from that source. 3. If there is no conflict on a column and the column was updated by either the publisher or subscriber, I want to keep the change made by the publisher or the subscriber. (i.e publisher made change in col #1, subscriber made change in col #2, no conflict, the resulting row will now have the col #1 value from publisher, col # 2 will have value from subscriber. Essentially merging the changes.)
Does anyone have any examples of a COM-based Conflict Resolver that implements ICustomResolver for SQL Server 2005? Can this be done using the Business Logic Handler (examples?) ?
TIA
View 4 Replies
View Related
May 22, 2006
Hello,
I see that MS has a conflict viewer that can be accessed by managment studio, however I would like to create one with some customized options. Is there a sample of code somewhere to start this? I could really find anything in BOL. Thanks in advance.
John
View 1 Replies
View Related
Aug 4, 2015
I have been evaluating merge replication, 'push' subscription on SQL Server 2014. If the default resolver is used (I refer to @article_resolver parameter of sp_addmergearticle), all seems to work as expected. However if I use "Microsoft SQL Server Subscriber Always Wins Conflict Resolver" (or any other MS standard resolver for that matter), if the Subscriber is on a different machine, the merge agent invariably gives the following error: "The process could not initialize <resolver_name>. Verify that the component is registered correctly."
This does not happen if the Subscriber is on the same machine as the Publisher and Distributor.
The problem seemed to exist in SQL Server 2008 according to some posts but it has been apparently fixed since then. I've tried the following:
- @partition_options = 0, as was suggested somewhere.
- Copied ssrpub.dll (the resolver dll) to the Subscriber machine (should not really matter as this is 'push' subscription?)
- Registered ssrpub.dll with regsvr32 on the Publisher/Distributor machine.
I've also run sp_enumcustomresolvers on the Publisher machine, and it happily showed all standard resolver, including the "Microsoft SQL Server Subscriber Always Wins Conflict Resolver".
Another thought is, I'm using SQL Server Express as the Subscriber (on the remote machine). Perhaps it does not support custom resolvers? (I'm using the full SQL Server in the 'local subscriber' variant, which does work OK as I mentioned before).
Note also that if I create a new publication via SSMS, the Resolver tab of the Article Properties dialog is empty, i.e. it does not list any resolver. The same tab contains the full list of resolvers though, if opened for an existing publication.
View 2 Replies
View Related
Oct 12, 2007
I am using SQL 2005 build 9.0.2227
I have a custom conflict resolver - which fires on update conflicts (using row level tracking)
I have had a couple of occasions when the resolver has failed with the following error:
"The schema of the custom Dataset object implemented in the business logic handler does not match the schema of the source Dataset object. Verify that the custom Dataset object has been correctly defined"
In both cases I found that the row for which a conflict was being handled was not a conflict at all. One was a straightforward non conflicting update at the publisher and the other was a similar update at the subscriber.
I got round the problem by temporarily using a fix version of the conflict resolver dll that either set the custom Dataset to the publisher dataset or the subscriber dataset - depending on where the update had occurred.
When the first error (publisher update) occurred - the resolver code was basing the custom dataset on the publisher dataset - which was presumably empty - so I changed the code to base the custom dataset on the subscriber dataset. The second error therefore occurred when the custom dataset was based on the subscriber dataset - which again was presumably empty
Note that the tables involved in each occasion were different and neither table is filtered.
Is there a known bug in this area?
I am considering trying to change the resolver code to identify false conflicts in order to workround the problem - but this would be difficult to test as I can't reproduce the problem
aero1
View 2 Replies
View Related
Sep 25, 2007
Hi all,
here is the context of our problem:
- Publisher :
version SQL Server 2005 SP2
table in SQL Server 2000 (80) compatibility level
publication in SQL Server 2000 compatibility level
- Distributor : SQL Server 2005 SP2
- Subscriber : SQL Server 2000 SP4 + hotfixes (version 8.00.2187)
There is only one article in our publication (a simple table with a GUID and a nvarchar(50) columns), and we have left the default resolver.
1 - The first synchronization of the subscription is successfully completed, and it is the same for the different updates/inserts/deletes or conflicts.
2 - Then we change the Resolver of our article by our own COM-Based Custom Resolver (developped in C# 2.0). This resolver only change the default behaviour: the subscriber always win (this is for a test, in the future we will have a complex business logic). All the synchronizations works fine and do what we want in the conflicts.
3 - We rollback the resolver to the default one... and here is the problem!
The synchonizations stop to work correctly. For all of them we've got the same error:
Code SnippetReplprov.dll , 2007/09/25 14:26:07.591, 4000, 16890, S1, ERROR: ErrNo = 0x80045017, ErrSrc = <null>, ErrType = 8, ErrStr = The schema script '
declare @cmd nvarchar(1000)
set @cmd='exec sys.sp_MSchangearticleresolver @article_resolver=@ar, @resolver_clsid=@rc, @artid=@ai, @resolver_info=@ri'
exec dbo.sp_executesql @cmd, N'@ar> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie..." mailto:N?@ar">N'@armailto:N'@ar">N'@ar</A< A>> nvarchar(255),@rc nvarchar(40),@ai uniqueidentifie...
It is no more possible to synchronize this subscription... Any remark will be helpfull cause we did not find anything on the net concerning this error.
Thanks a lot!
View 3 Replies
View Related
May 17, 2007
I created a stored procedure based custom conflict resolver in SQL 2005, I return the winning result set and also save that result set to a test table to compare the values. The values saved to the test table are correct but some of the values saved as the conflict winter are truncated.
Example a char(3) filed is updated at the subscriber as €˜111€™ and updated at the publisher as €˜222€™, in my custom conflict resolver if I use the value from the subscriber the conflict resolver updates the field as €™11 €˜, if I use the publisher value the conflict resolver updates the field as €™22 €˜. Now the same records is saved to the test table correctly as either €˜111€™ or €˜222€™ depending on the logic I used. So the result set has the correct values, its after the custom conflict resolver is called where the values is somehow truncated. Has anybody run into this before and what steps can I take to avoid this.
Thank you,
Pauly C
View 1 Replies
View Related
May 27, 2008
This is the error it gives me for my code and then it calls out line 102. Line 102 is my buildDD(sql, ddlPernames) When I comment out this line the error goes away, but what I don't get is this is the same way I build all of my dropdown boxes and they all work but this one. Could it not like something in my sql select statement. thanksPrivate Sub DDLUIC_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DDLUIC.SelectedIndexChanged
Dim taskforceID As Byte = ddlTaskForce.SelectedValueDim uic As String = DDLUIC.SelectedValue
sql = "select sidstrNAME_IND from CMS.dbo.tblSIDPERS where sidstrSSN_SM in (Select Case u.strSSN from tblAssignedPersonnel as u " _
& "where u.bitPresent = 1 and u.intUICID in (select intUICID from tblUIC where intTaskForceID = " & taskforceID & " and strUIC = '" & uic & "'))"ddlPerNames.Items.Add(New ListItem("", "0"))
buildDD(sql, ddlPerNames)
End Sub
View 2 Replies
View Related
May 22, 2008
What I am trying to create a query to check, If recDT is not value or null, then will use value from SELECT top 1 recDtim FROM Serv. Otherwise, will use the value from recDT. I have tried the below query but it doesn't work. The error says, Incorrect syntax near the keyword 'SELECT'.Incorrect syntax near the keyword 'else'.1 SELECT
2 case when recDT='' then SELECT top 1 recDtim FROM Serv else recDT end
3 FROM abc
4
Anyone can help? Thanks a lot.
View 5 Replies
View Related
Jul 26, 2006
I am not sure how to fix this??
Imports System.Data
Imports System.Web.UI.WebControls.FormView
Imports System.Data.SqlClient
Partial Class Assignment
Inherits System.Web.UI.Page
Protected Sub UpdateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UpdateButton.Click
Dim empID As Integer
Dim nbrID As Integer
Dim equid As Integer
Dim UpdateQuery
Dim empequipid As SqlCommand
Dim mySQLConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("DBConnectionString").ToString
Dim myConnection As New SqlConnection(mySQLConnection)
myConnection.Open()
empID = (Session("UserEmployeeID"))
equid = (Session("UserEquipID"))
If CType(empID, Integer) = Nothing Then
empID = (DropDownList1.SelectedValue)
'Response.Write("Insert: " & empID)
'Response.End()
Me.SqlDataSource1.InsertCommand = "INSERT INTO [EMPLOYEES_EQUIP] ([EquipID], [EmployeeID]) VALUES " & equid & " " & empID & ""
Me.SqlDataSource1.InsertCommand = SqlDataSourceCommandType.Text
Me.SqlDataSource1.Insert()
Else
empequipid = New SqlCommand("Select EmpEquipID From EMPLOYEES_EQUIP Where EmployeeID = " & empID & " AND EquipID = " & equid & " ", myConnection)
empequipid.CommandType = CommandType.Text
nbrID = empequipid.ExecuteScalar
'Response.Write("Select EmpEquipID: " & nbrID)
'Response.End()
empID = (DropDownList1.SelectedValue)
'Response.Write("<br>Update EmployeeID: " & empID)
'Response.End()
Me.SqlDataSource1.UpdateCommand = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " "
Me.SqlDataSource1.UpdateCommand = SqlDataSourceCommandType.Text
Me.SqlDataSource1.Update() <---Right here is displaying "Incorrect syntax near '0'."
'Added to output the Update Query
UpdateQuery = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " "
'Response.Write(UpdateQuery)
'Response.End()
End If
'Updating the session to new EmployeeID
Session("UserEployeeID") = (DropDownList1.SelectedValue)
'Response.Write("<br>UserEmployeeID Session: " & Session("UserEmployeeID"))
'Response.End()
'-- Turn On Employee Information Table
EmpInfo.Visible = True
'-- Hides the Employee Name's Drop Down List table.
maintable.Visible = False
End Sub
End Class
View 2 Replies
View Related
Aug 11, 2006
Why am I getting this error.
[SqlException (0x80131904): Incorrect syntax near '.123'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857418 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735030 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 WebApplication10.Edit.dgrdEdit_UpdateCommand(Object source, DataGridCommandEventArgs e) in C:Inventoryedit.aspx.vb:186 System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) +105 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +471 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +117 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
View 1 Replies
View Related
Sep 8, 2006
Hi,I am trying to test a login form and I get this error message and can't find out why. Istarted out with the Login control, but since I have to try it on the ISP's server, I can't use the SQL Server Managment Studio's integrated authentication. So, I converted the login control to a template and assigned a handler for the login button:protected void LoginButton_Click(object sender, EventArgs e){String usrname = lpLogin.UserName.ToString(); //lpLogin is the <ASP:Login ...>String conString = "Data Source=mylocalserver\SQLEXPRESS;Initial Catalog=LPRU;Integrated Security=True";String selQuery = "SELECT [Password], [FirstName], [LastName] FROM [lpUserInfo] WHERE ([UserID] ='" + usrname + "';";SqlConnection con = new SqlConnection(conString);SqlCommand cmd = new SqlCommand(selQuery, con);con.Open();SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // <--- it says "syntax error near ';' " on this line, I tried it without CommandBehaviorwhile (rdr.Read()){Label1.Text= rdr.GetString(0) + rdr.GetString(1); // for testing purposes, trying to print out first name and last name}rdr.Close();con.Close();}Is there a way of using SQLServer 2000, used by my ISP, and take advantage of .net 2.0's login control, roles, membership, ...? By just using a connection string?
View 6 Replies
View Related
Feb 19, 2007
OS: Windows2kPlatform: ASP.Net 2.0.50727DB Server: SQL Server 2000 I'm getting an error that I don't understand, could someone help me please? In the interest of brevity I threw most of the query out (it's a somewhat long join). --- query += "AND TOURNAMENT_ROUNDS.END_TIME BETWEEN ? AND ?"; System.Data.SqlClient.SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@from",System.Data.SqlDbType.DateTime).Value = from; cmd.Parameters.Add("@to", System.Data.SqlDbType.DateTime).Value = to; SqlDataAdapter da = new SqlDataAdapter(query, connection); da.SelectCommand = cmd; DataSet ds = new DataSet(); int i = 0; try { connection.Open(); da.Fill(ds); --- The da.Fill(ds) is what's throwing. I was under the impression that ADO.Net would handle the syntax so that this shouldn't be a problem. Any idea about what direction I should be looking? If you need me to post more I'll be happy to do that. I've verified that the above is where the exception is throwing by taking out the particular AND clause, and the query worked as expected. Thanks for the help,Michael
View 2 Replies
View Related
Mar 17, 2007
Hi Guys,I have moved my asp.net app from access db over to MS SQL 2005 DB.And I have got a slight problem when I go to view any productfor example if I type in the url of http://domain.com/catalog/Details.aspx?AdNum=1I get this errorServer Error in '/catalog' Application.--------------------------------------------------------------------------------Incorrect syntax near '?'. 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: Incorrect syntax near '?'.I have attached the details.aspx.I await for some suggestions.ThanksMatthew
------------------1 <%@ Page MasterPageFile="Classy.master" Explicit="True" Language="VB" Debug="True" %>
2
3 <asp:Content runat="server" ID="HeaderContent" ContentPlaceHolderID="PageHeader">
4 Ad Detail - <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
5 </asp:Content>
6
7 <asp:Content runat="server" ID="BodyContent" ContentPlaceHolderID="Body" >
8
9 <script runat="server">
10 Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs)
11 If Not IsPostBack Then
12 If Request.QueryString("AdNum") = "" Then
13 Response.Redirect("default.aspx")
14 End If
15 EditLink.NavigateUrl = "confirm.aspx?AdNum=" & Request.QueryString("AdNum")
16 End If
17 End Sub
18
19 Protected Sub DetailsView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewPageEventArgs)
20
21 End Sub
22 </script>
23
24
25 <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
26 CellPadding="4" DataKeyNames="AdNum" DataSourceID="SqlDataSource1" ForeColor="#333333"
27 GridLines="None" Height="65px" Width="100%" Font-Names="Arial" Font-Size="8pt" OnPageIndexChanging="DetailsView1_PageIndexChanging">
28 <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
29 <FieldHeaderStyle BackColor="#FFFF99" Font-Bold="True" />
30 <Fields>
31 <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
32 <asp:BoundField DataField="Category" HeaderText="Category" SortExpression="Category" />
33 <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
34 <asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
35 <asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
36 <asp:TemplateField HeaderText="Email">
37 <ItemTemplate>
38 <asp:HyperLink ID="HyperLink1" runat="server" Text=Email NavigateUrl='<%# Eval("Email", "mailto:{0}") %>' />
39 </ItemTemplate>
40 </asp:TemplateField>
41 <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
42 </Fields>
43 </asp:DetailsView>
44 <p><i>To respond to this ad, just click the email address
45 above to send the poster
46 a message.</i></p>
47 If you created this ad, you can
48 <asp:hyperlink id="EditLink" runat="server" >edit or delete it.</asp:hyperlink> <br>
49 <asp:SqlDataSource ID="SqlDataSource1" runat="server"
50 ConnectionString="<%$ ConnectionStrings:classydbConnectionString %>"
51 ProviderName="<%$ ConnectionStrings:classydbConnectionString.ProviderName %>"
52 SelectCommand="SELECT * FROM [Ads] WHERE ([AdNum] = ?)">
53 <SelectParameters>
54 <asp:QueryStringParameter Name="AdNum" QueryStringField="AdNum" Type="Int32" />
55 </SelectParameters>
56 </asp:SqlDataSource>
57
58 </asp:content>
View 4 Replies
View Related
Jun 18, 2007
Can anyone see why I would get the 'Incorrect Syntax near AS' error in this?
USE [SQL2]GO/****** Object: StoredProcedure [dbo].[PlanGroupGrid] Script Date: 06/18/2007 06:07:34 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[PlanGroupGrid]@dp_id intASSELECT tblExpenses.gp_ID, tblExpenses.Amount INTO #tempApExpFROM tblExpensesSELECT tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose, tblGroups.Group_StartDate, tblGroups.Group_EndDate, COALESCE (tblGroups.Group_Goal, 0) AS Goal, SUM(COALESCE(#tempApExp.Amount,0)) AS [Total Expenses], SUM(COALESCE (tblReceipts.AmountPaid, 0)) AS [Total Paid], SUM(COALESCE (tblReceipts.AmountPaid, 0)) - COALESCE (tblGroups.Group_Goal, 0) - SUM(COALESCE(#tempApExp.Amount,0)) AS [Total Expenses], AS VarianceFROM tblGroups LEFT OUTER JOIN tblTracking ON tblGroups.Group_ID = tblTracking.Group_ID LEFT OUTER JOIN tblReceipts ON tblTracking.gp_ID = tblReceipts.gp_ID LEFT OUTER JOIN #tempApExp ON tblTracking.gp_ID = #tempApExp.gp_IDWHERE (tblGroups.dp_id = @dp_id)GROUP BY tblGroups.dp_id, tblGroups.Group_ID, tblGroups.Group_Type, tblGroups.Group_Purpose, tblGroups.Group_StartDate, tblGroups.Group_EndDate, tblGroups.Group_GoalIf Exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tempApExp]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)Drop table #tempApExp
View 2 Replies
View Related
Jul 28, 2007
I'm getting a pop up error "Incorrect syntax near the keyword 'ORDER'.
Can someone please tell me what is wrong with my code? It worked before I added the underlined part.
If FoundChecked = True Then
Dim SQLString As String
SQLString = "SELECT ID, Bedrooms, Bathrooms, Location, Rent FROM ListingsTable WHERE "
For Each Item In LocationList.Items
If Item.Selected Then
SQLString &= " Location = '" & Item.Value & "' OR " & "" & " ORDER BY Location" ----------------------This is the problem
End If
View 8 Replies
View Related
Aug 28, 2007
Hi
I'm trying to lookup a sigle value from an MS SQL Express database. However, I get an error - Incorrect Syntax near '' - when executing the code. The line in bold below is what is highlighted on the error I get back. Please Help!!
The code is below
Thanks
Dim oSQLConn As Data.SqlClient.SqlConnection = New Data.SqlClient.SqlConnection()oSQLConn.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|SDCentral.mdf;Integrated Security=True;User Instance=True"oSQLConn.Open() Dim ValExtract As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("SELECT * FROM ProjectsQRY", oSQLConn) Dim Get1 As Int32 = CInt(ValExtract.ExecuteScalar()) Me.Active1.Text = Get1
oSQLConn.Close()
View 4 Replies
View Related
Aug 28, 2007
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: Incorrect syntax near ')'.Source Error:
Line 42: objAdapter.SelectCommand = New System.Data.SqlClient.SqlCommand(strSQL, objConn)Line 43: ' Fill the dataset.Line 44: objAdapter.Fill(objDataset)Line 45: ' Create a new view.Line 46: Dim oView As New DataView(objDataset.Tables(0))
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim AllorOne As String
Dim company As String
AllorOne = Request.QueryString("AllorOne")
company = Request.QueryString("company")
' Create a connection and open it.
Dim objConn As New System.Data.SqlClient.SqlConnection("User ID=******;Password=******;Initial Catalog=customer_config;Data Source=rqa4-sql01;")
objConn.Open()
Dim strSQL As String
Dim objDataset As New DataSet()
Dim objAdapter As New System.Data.SqlClient.SqlDataAdapter()
' Get all the sql
If AllorOne = "All" Then
strSQL = "SELECT [Company_Name] as 'Company Name', [Entity_Code] as 'Entity Code', [YTD_Transactions] as 'YTD_Transactions', [Num_Reports_DB] as 'Num_Reports_DB', [Reports_Advanced_Workflow] as 'Reports_Advanced_Workflow', [Has_Customization] as 'Has_Customization',[TA_Trans_All] as 'TA Trans All', [TA_Trans_US] as 'TA Trans US', [Using_VAT] as 'Using VAT', [Total_Users] as 'Total Users',[Non_English_Langages] as 'Non English Langages',[Non_English_Users] as 'Non English Users', [Using_Offline] as 'Using Offline', [Using_Audit_Services] as 'Using Audit Services' from(v_customer_master_list) order by company_name"
Else
strSQL = "SELECT [Company_Name] as 'Company Name', [Entity_Code] as 'Entity Code', [YTD_Transactions] as 'YTD_Transactions', [Num_Reports_DB] as 'Num_Reports_DB', [Reports_Advanced_Workflow] as 'Reports_Advanced_Workflow', [Has_Customization] as 'Has_Customization',[TA_Trans_All] as 'TA Trans All', [TA_Trans_US] as 'TA Trans US', [Using_VAT] as 'Using VAT', [Total_Users] as 'Total Users',[Non_English_Langages] as 'Non English Langages',[Non_English_Users] as 'Non English Users', [Using_Offline] as 'Using Offline', [Using_Audit_Services] as 'Using Audit Services' from(v_customer_master_list) where lower(company_name) like '%" & company & "%' order by company_name"
End If
objAdapter.SelectCommand = New System.Data.SqlClient.SqlCommand(strSQL, objConn)
' Fill the dataset.
objAdapter.Fill(objDataset)
' Create a new view.
Dim oView As New DataView(objDataset.Tables(0))
' Set up the data grid and bind the data.
SimpleDataGrid.DataSource = oView
SimpleDataGrid.DataBind()
End Sub
Can anyone tell me what causes this type of error, what they think is wrong, or what IS wrong if someone wants to take the time to go through the code. Anything helps. Eh, I feel like one of those guys on a street corner with a sign when I say that.
View 3 Replies
View Related
Nov 20, 2007
Hi there
I'm getting an Incorrect syntax near '='. error when I click update in my gridview.
Any ideas?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Taskdb %>" SelectCommand="SELECT [taskid], [taskname], [taskdescription], [taskstatus] FROM [tblTask]" UpdateCommand="UPDATE [tbltask) set [taskname] = @taskname, [taskdescription] = @taskdescription, [taskstatus] = @taskstatus where [taskid] = @taskid"> <UpdateParameters> <asp:Parameter Type="String" Name="taskname" /> <asp:Parameter Type="String" Name="taskdescription" /> <asp:Parameter Type="Int16" Name="taskstatus" /> <asp:Parameter Type="Int16" Name="taskid" /> </UpdateParameters> </asp:SqlDataSource> Thanks in advance.
View 2 Replies
View Related
Jan 16, 2008
Could someone please tell me what is wrong with the following? Thanks!
Dim objcmd As New SqlCommand
Dim link As String
Dim pocount As Integer
objConn.Open()objcmd = New SqlCommand("SELECT COUNT(PONumber) FROM (SELECT PONumber FROM BOL_Dtl GROUP BY PONumber, BOLNumber HAVING BOLNumber = @BOLNumber)", objConn)
objcmd.Parameters.Add("@BOLNumber", SqlDbType.Int, 4)objcmd.Parameters("@BOLNumber").Value = Int32.Parse(Request.QueryString("BOLNumber"))
pocount = objcmd.ExecuteScalar()
View 2 Replies
View Related
Feb 28, 2008
Hi,
I have a table 'MemberPayment', into which I would like to pass a derived value, and a value from another table (table 'Vehicle', value 'Registration'). However, I keep getting errors with my syntax... would anybody be able to kindly tell me where I am going wrong? My code is;Declare @Total int
Declare @Registration str
SELECT (@Registration=(Vehicle.Registration), @Total=((MileageHistory.MileageUrban * Vehicle.EmissionsPerGramUrban) * 0.05) + ((MileageHistory.MileageCountry * Vehicle.EmissionsPerGramUrban) * 0.05) )
FROM [NeuCar].[dbo].[MileageHistory] JOIN [NeuCar].[dbo].[Vehicle]
ON MileageHistory.Registration = Vehicle.Registration
JOIN [NeuCar].[dbo].[Member] ON Vehicle.UserName = Member.UserName
WHERE Member.UserName = 'wenger1' AND (MileageHistory.[Date] >= CURRENT_TIMESTAMP - 30)
INSERT INTO MemberPayment (Registration, TotalCharge) VALUES ( @Registration, @Total )
Many thanks for your time,
Best regards,
Chima
View 2 Replies
View Related
Mar 14, 2008
Hi All,
When binding my dropdownlist I get this error: Incorrect syntax near '?'.
My code behind:
'Set country drop list value c = Request.QueryString("c") ddlCountry.SelectedValue = c
'Begin populating if country has been selected ddlLeaveType.DataBind()
My HTML:
<asp:DropDownList ID="ddlLeaveType" runat="server" CssClass="AdminLeaveDDL" DataSourceID="SDSLeaveTypes" DataTextField="Description" DataValueField="PTO_Leave_Type_ID"></asp:DropDownList>
<asp:SqlDataSource ID="SDSLeaveTypes" runat="server" ConnectionString="<%$ ConnectionStrings:PTOTrackConnectionString %>" ProviderName="<%$ ConnectionStrings:PTOTrackConnectionString.ProviderName %>" SelectCommand="SELECT PTO_Leave_Type_ID, Description FROM PTO_Leave_Type WHERE PTO_Leave_Type_ID NOT IN (SELECT PTO_Leave_Type_ID FROM PTO_Country_Leave_Type WHERE Country_ID = ?) ORDER BY Description"> <SelectParameters> <asp:QueryStringParameter Name="CountryID" QueryStringField="c" Type="Int32" /> </SelectParameters> </asp:SqlDataSource>
If I rund the query in sql management studio and replace the ? with a valid id, it runs fine.
Thanks,
Mark
View 5 Replies
View Related
