Abhishek Mishra 9.Oct.06 05:31 PM a Web browser LS:DO All Releases Windows NT
I am creating a new topic after searching through the forums for an existing solution\suggestion.
I am supporting an old Lotus Notes Application that writes data to a SQL database using an ODBC connector.
The application works fine for most of the users but not for only few which get the following messages :
Error 720 : LS:DO-ODBC cannot complete the requested operation.
[Microsoft][ODBC SQL Server Driver][SQL Server]String or Binary Data would be truncated.
I have already verified that the data that is being inserted is smaller than the SQL table column sizes. Moreover other users are able to insert the same data (through a button in the application that calls an SQL Insert Statement). Also i am able to update the data in Development environment.
I have asked the one of the users that was getting these errors to re-install the MDAC (v 2.8) and then reconfigure the ODBC driver on his machine, but no success.
I re-wrote the function using Lotus Connector, but the user received the following error this time :
Error: Data Overflow, Connector 'oledb', Method -Execute
I am however able to update SQL tables through Lotus Connector function that i created.
My Development Environment exactly resembles the Production Environment.