ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error 
Author Message
 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error

Hi!

I have a Table - where every INSERT/MODIFIY/DELETE is copied to a "history
table"
that table has the same struktur as the main table!
If i delete or insert any fields of table i always get the error:

******************************
'RootCodeMT' table saved successfully
'CodeMT' table
- Unable to preserve trigger 'tr_OnUpdateNewCode'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error:
Column name or number of supplied values does not match table definition.
*****************************

first the table isn't saved ... and the best ----> near all referencies to
or from that table are deleted from the diagrams
what can i do to get them all back - without new-create them!

best regards
-Brisi



Mon, 10 Feb 2003 03:00:00 GMT
 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error

Thomas,

My guess is that the tool which you modify the table chokes on the complexity (EM
creates a new table copies columns etc etc etc).
Try using straight TSQL (ALTER TABLE ADD/DROP...).

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.


Quote:
> Hi!

> I have a Table - where every INSERT/MODIFIY/DELETE is copied to a "history
> table"
> that table has the same struktur as the main table!
> If i delete or insert any fields of table i always get the error:

> ******************************
> 'RootCodeMT' table saved successfully
> 'CodeMT' table
> - Unable to preserve trigger 'tr_OnUpdateNewCode'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error:
> Column name or number of supplied values does not match table definition.
> *****************************

> first the table isn't saved ... and the best ----> near all referencies to
> or from that table are deleted from the diagrams
> what can i do to get them all back - without new-create them!

> best regards
> -Brisi



Mon, 10 Feb 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. what is ODBC ERROR: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error 23

2. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

3. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]

4. ODBC error:S1010: [Microsoft][ODBC SQL Server Driver]Function sequence error

5. [Error=18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: guest

6. ADO Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Line 1: Incorrect

7. ADO Error: [Microsoft][ODBC SQL Server Driver][SQL Server] Line 1: Incorrect

8. odbc error:[microsoft][odbc sql server driver] numeric value out of range

9. Microsoft SQL-DMO (ODBC SQLState:42000) [microsoft] [odbc sql server driver] [sq

10. [Error=613][Microsoft][ODBC SQL Server Driver]General error

11. Error adding database to SourceSafe (ADO error: [Microsoft][ODBC SQL Server Driver] Timeout expired)

12. VB,ADO,SQL [Microsoft][ODBC SQL Server Driver] Protocol error in TDS stream


 
Powered by phpBB® Forum Software