sql server odbc: I have been attempting to access a database that I have
been able to use regularly prior to September 2003. I
have tried to resolve this problem through tech support
at Microsoft as well as the OEM. I have been unable to
find a solution that is more than just temporary. The
error msg reads as follows:

Microsoft OLE DB Provider for ODBC Drivers
error '80040e57' [Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated.

/emsdata/-fpclass/fpaddlog.inc, line 29

My research has told me that the problem originates at
the ODBC SQL Server Driver, and that the error msg is
being sent from the SQL server. Correct?

Any ideas on how to resolve? Can I resolve this on my
own without a costly investment?

Thank you in advance for any assistance.

Respectfully,
Shelly
shelbert6@msn.com
..

Can you access the database through osql?

Actually, one drastic solution may be to recreate the database. Is there
anyway that you can script it? If you have the schema of the database, you
could create a new database on another server, then use the bcp command to
copy out the data and then transfer it into a new server.

What is the quoted identifier setting (database options)? Try setting it
off if it is on.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]

Shelly,
Are you trying to insert or update data into a field when
this happens? Essentially the field is too small to
accept the amount of data you attempted to add. Try
inserting or pasting less data.


[quoted text, click to view]