It may be that the varchar(8000) was being converted to a text field. Try 'varchar(max)' as the datatype and it should work.
Thanks, Shawn Wildermuth Wildermuth Consulting Services, LLC http://adoguy.com C# MVP, MCSD.NET, Author and Speaker > -----Original Message----- > From: Discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Brown > Sent: Wednesday, August 09, 2006 5:26 PM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: [ADVANCED-DOTNET] SQL output parameters > > We have a stored procedure that uses a varchar(8000) as an > output parameter. > The stored proc was written in SQL 2000, and is called by > .Net 1.0 clients. > We copied the stored proc to a test server that has SQL > Server 2005 installed, and are trying to write a client in > Visual Studio 2005 using the .Net 2.0 frame work. The > problem is that the following error is being thrown... > > "ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL > Server]Invalid parameter 3 (''): Data type 0x23 is a > deprecated large object, or LOB, but is marked as output > parameter. Deprecated types are not supported as output > parameters. Use current large object types instead." > > When we run the stored proc from the SQL 2005 management > studio query window, it works fine. The output parameter > gets populated, and there is no error. But when we call it > via ODBC from the client, it throws the error. > I thought maybe the ODBC driver was causing the error, so we > installed the old .Net 1.0 data components, but it still > generates the error. > > It seems that you can use varchar data type with a size of > 3999 or smaller, but anything larger than that will throw the > above mentioned error. I know we could just change the data > type, but when we put the code on the production server, it > will be connecting to the old SQL 2000 database, so I can't > use the new data types in the code. Also, we are considering > upgrading the production database, but I am afraid that it > might break all of the current clients if there isn't a > resolution to this situation. > > Any ideas? > > > Thanks, > Shawn Brown > > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
