Hi, i have an application updating a SQL Server db using cursoradapters in the de of a form. The user is cut-and-pasteing large amounts of stuff into a form field which is causing a 22001 error: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
Ansi Warnings is off on the database which should stop this error, but reading Help! "By default, ODBC and OLE DB clients issue a connection-level SET statement setting ANSI_WARNINGS to ON for the session when connecting to SQL Server." I can't find anywhere in the de or ca to override this - anyone know how it's done please? (or do I just send a SET command in e.g the ca init?) thanks Andrew Davies MBCS CITP - AndyD 8-)# _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
