odbc error

Getting the following error:
SQL error. Stmt #: 1568 Error Position: 0 Return: 8602 -
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB
provider returned message: Errors occurred] (SQLSTATE
01000) 7312
Scenario: application/database sitting on win nt4 server
running sql7 linked to a Windows 2000 server running sql
2000. Trigger on serverA trying to update table on
ServerB via linked server.Turn on trace flag 7300 to try to get better information.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

ODBC -- Call Failed with error # 547

[Microsoft}{ODBC SQL Server Driver][SQL Server] INSERT
statement conflicted with COLUMN FOREIGN KEY
constraint 'Attachment_FK00'. The conflict occured in
database 'assay', table 'suborders', column 'suborderid'.
(#547) [Microsoft}{ODBC SQL Server Driver][SQL Server]The
statement has been terminated (#3621)
when user try to upload the document thought Access 2002
to SQL database, occasionally user could get this error.
did someone experience this error before?
thanks,
wilson
Hi
You need to look at the data or insert order/method as your FK constraint is
not being satisfied.
John
"Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:1a51b01c44e4d$4543dc20$a501280a@.phx.gbl...
> [Microsoft}{ODBC SQL Server Driver][SQL Server] INSERT
> statement conflicted with COLUMN FOREIGN KEY
> constraint 'Attachment_FK00'. The conflict occured in
> database 'assay', table 'suborders', column 'suborderid'.
> (#547) [Microsoft}{ODBC SQL Server Driver][SQL Server]The
> statement has been terminated (#3621)
> when user try to upload the document thought Access 2002
> to SQL database, occasionally user could get this error.
> did someone experience this error before?
> thanks,
> wilson
|||Hi john,
thanks for your quick response.
why it is working sometimes, but sometimes it is not.
wilson
>--Original Message--
>Hi
>You need to look at the data or insert order/method as
your FK constraint is
>not being satisfied.
>John
>"Wilson" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1a51b01c44e4d$4543dc20$a501280a@.phx.gbl...
column 'suborderid'.[vbcol=seagreen]
The[vbcol=seagreen]
2002[vbcol=seagreen]
error.
>
>.
>
|||Hi
That is a feature of the data you are inserting. Try loading this into a
copy of the table (i.e. without the FK) and then check the data with a
statement similar to:
SELECT * FROM TmpTable
WHERE FKCol NOT IN ( SELECT PKCol from PKTbl)
John
<anonymous@.discussions.microsoft.com> wrote in message
news:1a63301c44e5b$c829ce70$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi john,
> thanks for your quick response.
> why it is working sometimes, but sometimes it is not.
>
> wilson
> your FK constraint is
> message
> column 'suborderid'.
> The
> 2002
> error.
|||thanks, John.
But now we got another error:
Syntax error (missing operator) in query
expression '[SubOrderID]='
any ideas?
thanks,
wilson
>--Original Message--
>Hi
>That is a feature of the data you are inserting. Try
loading this into a
>copy of the table (i.e. without the FK) and then check
the data with a[vbcol=seagreen]
>statement similar to:
>SELECT * FROM TmpTable
>WHERE FKCol NOT IN ( SELECT PKCol from PKTbl)
>John
><anonymous@.discussions.microsoft.com> wrote in message
>news:1a63301c44e5b$c829ce70$a401280a@.phx.gbl...
in[vbcol=seagreen]
INSERT[vbcol=seagreen]
in[vbcol=seagreen]
Server]
>
>.
>
|||Hi
You may want to start ODBC logging and see what the statements are. At a
guess you either are creating the statements dynamically and that is not
working correctly e.g. as missing 'AND' or alternatively that your data has
a character that needs escaping in it e.g as a quote.
John
<anonymous@.discussions.microsoft.com> wrote in message
news:1aa3301c44f0b$bc9fcb80$a301280a@.phx.gbl...[vbcol=seagreen]
> thanks, John.
> But now we got another error:
> Syntax error (missing operator) in query
> expression '[SubOrderID]='
> any ideas?
> thanks,
> wilson
> loading this into a
> the data with a
> in
> INSERT
> in
> Server]