Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  stored procedure parameters and sqloledb provider

Author  Topic  terre Starting Member 1 Post Posted - 2004-11-05 : 20:40:32 I am trying to upgrade my application db connection type from odbc to sqloledb provider using asp. Most of my stored procedures work except for some parameterized stored procedures which take datetime and/or integer as parameters. The error in my web app is: Microsoft OLE DB Provider for SQL Server error 80040e57 String or binary data would be truncated. I am using MS SQL 2000 SP 3a on Windows 2000. I get the error on IIS IV (NT) and IIS 6 (win2003) and I get the same error using Call, Exec and Adodb command methods. The values of the datatypes are valid in my test cases. I have made some progress changing the datetime parameters to string parameters, packing the string as yyyy-mm-dd but that seems excessive and other developers using the same product set do not have to do this and I am wondering what could be wrong. Thanks in advance for any suggestions. -Terre