February 4, 2002 at 2:52 am
[Microsoft][ODBC SQL Server Driver]insert Error:
Column name or number of supplied values does not match table definition
I encountered the above message in my financial application after configuring the replication, my application is working before replication.
thanks
Peter
20394
20394
February 4, 2002 at 3:11 am
Peter I want some more info to clarify your doubt. What version of SQL you are using? What kind of replication you are using?
Ram
February 4, 2002 at 3:16 am
Hi RAM
I am using SQL 2000 standard edition, i already applied the service pack 2
thanks
20394
20394
February 4, 2002 at 3:22 am
What type of replication are you using?
February 4, 2002 at 4:53 am
Did you modify the table, either on the publisher or subscriber? There will be an insert proc on the subscriber for each table that is being replicated, you can compare that with both the source and destination tables to see if the description matches. The fastest resolution is to just reinit your publication and have it send over a new snapshot.
Andy
February 4, 2002 at 10:36 pm
I am using Merge replication, I only created the snapshot and theres no subcriber yet and i did not modify the table.
thanks
Peter
20394
20394
February 4, 2002 at 10:57 pm
Are u started the snapshot or not? If you started the snapshot that will create the tables in subscriber database and replicate the data also. So, check whether u started the snapshot or not.
February 5, 2002 at 1:54 am
i already created and started the snapshot.
20394
20394
February 5, 2002 at 5:29 am
Are you dynamically constructing the insert? Merge will have added a rowguid col to the table, this is probably causing the error.
Andy
February 6, 2002 at 2:09 am
Hi Andy
you're right, rowguid was added to the table, but why the other tables are replicating with no problem
20394
20394
February 6, 2002 at 6:35 am
Maybe they already had a uniqueidentifier? Or you were handling inserts differently?
Andy
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply