01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation 
Author Message
 01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation

I get this error when using an Access97 pass-thru query to call a stored
procedure on SQL 6.5.  It returns a memo field.  When I exclude the memo
field the error disappears.  There seems to be some known issues with memo
fields in SQL calls.  But, I haven't found any resolution other than
disabling the "log messages" property of the pass-thru query.

Should I ignore this error and disable the log.  Or is there a solution to
fix the problem?
- Jon



Mon, 26 Nov 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. -2147217889 [ODBC SQL Server Driver] String Data, Right Truncation

2. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

3. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ?????????

4. Error: 40002 - 01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted

5. S1T00[Microsoft][ODBC SQL SERVER DRIVER] TIMEOUT EXPIRED ????

6. Error : 40002 - 01S03: [Microsoft][ODBC SQL Server Driver]No rows updated or deleted

7. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

8. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

9. Error -2147217887 [Microsoft][ODBC SQL Server Driver]Optional feature not implemented ,

10. 0 [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt

11. ? S1000:[Microsoft][ODBC SQL Server Driver]TDS buffer length too large

12. 0 [Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt

 

 
Powered by phpBB® Forum Software