Board index » delphi » SQL Error Code: 7134 - please help.

SQL Error Code: 7134 - please help.

I have hit a brick wall with this one, any help greatly appreciated. By
the way BDE has enable BCD set to true and SQL server 6.5 has service
pack 2 and patch 2 loaded.

Below is a log snippet:

470     07:33:11  SQL Prepare: MSSQL - SELECT custno ,date_added
,date_modified ,notes ,status ,type ,priority ,user_entered ,user_action
,date_action  FROM dbo.contact ORDER BY  custno ASC , date_added ASC
471     07:33:11  SQL Misc: MSSQL - Set statement type
472     07:33:11  SQL Execute: MSSQL - SELECT custno ,date_added
,date_modified ,notes ,status ,type ,priority ,user_entered ,user_action
,date_action  FROM dbo.contact ORDER BY  custno ASC , date_added ASC
473     07:33:11  SQL Stmt: MSSQL - Fetch
474     07:33:11  SQL Data Out: MSSQL - Column = 1, Name = custno, Type
= fldINT32, Precision = 0, Scale = 0, Data = 194806
475     07:33:11  SQL Data Out: MSSQL - Column = 2, Name = date_added,
Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/30/1998
16:34:0:0
476     07:33:11  SQL Data Out: MSSQL - Column = 3, Name =
date_modified, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data =
3/30/1998 16:34:0:0
477     07:33:11  SQL Data Out: MSSQL - Column = 5, Name = status, Type
= fldZSTRING, Precision = 2, Scale = 0, Data = NULL
478     07:33:11  SQL Data Out: MSSQL - Column = 6, Name = type, Type =
fldZSTRING, Precision = 2, Scale = 0, Data = I
479     07:33:11  SQL Data Out: MSSQL - Column = 7, Name = priority,
Type = fldINT16, Precision = 0, Scale = 0, Data = NULL
480     07:33:11  SQL Data Out: MSSQL - Column = 8, Name = user_entered,
Type = fldZSTRING, Precision = 4, Scale = 0, Data = sa
481     07:33:11  SQL Data Out: MSSQL - Column = 9, Name = user_action,
Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL
482     07:33:11  SQL Data Out: MSSQL - Column = 10, Name = date_action,
Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL
483     07:33:12  SQL Prepare: MSSQL - SELECT DATALENGTH (notes) FROM
dbo.contact WHERE custno=:1 AND date_added=:2
484     07:33:12  SQL Data In: MSSQL - Param = 1, Name = custno, Type =
fldINT32, Precision = 0, Scale = 0, Data = 194806
485     07:33:12  SQL Data In: MSSQL - Param = 2, Name = date_added,
Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 3/30/1998
16:34:0:0
486     07:33:12  SQL Misc: MSSQL - Set statement type
487     07:33:12  SQL Stmt: MSSQL - Close
488     07:33:12  SQL Execute: MSSQL - SELECT DATALENGTH (notes) FROM
dbo.contact WHERE custno=:1 AND date_added=:2
489     07:33:12  SQL Stmt: MSSQL - Fetch
490     07:33:12  SQL Stmt: MSSQL - Close
491     07:33:12  SQL Blob IO: MSSQL - Get
492     07:33:12  SQL Error: MSSQL -
493     07:33:12  SQL Error: MSSQL - Unmapped SQL Error Code: 7134
494     07:33:18  SQL Connect: MSSQL - Disconnect GENERAL

Cheers,
Rob.

 

Re:SQL Error Code: 7134 - please help.


Don't worry - figured it out. Problem with restoring a table with BLOB
fields - emptying it and reloading using ISQL fixes it.

Other Threads