Posted by ZRexRider on 12/23/05 19:22

Hi,

I have a .NET application that connects to a SQL 2000 database using
trusted security. It eventually calls a stored procedure that receives
3 parameters - nothing special.

If I simply change the connection string to use a valid Userid and
Password it still connects to the DB w/o problems but when it executes
the SP I get the following:

System.Data.SqlClient.SqlException: Invalid length parameter passed to
the substring function.

I change nothing but the login. Same store procedure, same parameters.

Any ideas?

• Next in forum: SQL Server Std vs Small Business Server 2003
• Prev in forum: Re: How to execute a "batch file" using SQL Server 2005?
• Thread view: Stored Procedure only works in when app uses trusted security

[Reply to this message]