Wednesday, February 15, 2012

Errocde = 3

Hi..
I wrote a StoreProcedure and use delphi to call it. if I am admin it run OK,
if I use normal user system will display error message like :
gereral SQL error
[MICROSOFT][ODBC SQL server Driver][SQL server]string or binary
data would
be trunated
[MicroSoft][ODBC SQL server Driver][SQL Server]the statement has
been
terminted
[MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
What's problem?how to solved it'
ThanksCan you reproduce this by running the code from within Query Analyzer?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"James" <James@.discussions.microsoft.com> wrote in message
news:E4DC72AA-BC62-42F7-8552-6BB9212BFD4D@.microsoft.com...
> Hi..
> I wrote a StoreProcedure and use delphi to call it. if I am admin it run O
K,
> if I use normal user system will display error message like :
> gereral SQL error
> [MICROSOFT][ODBC SQL server Driver][SQL server]string or binar
y data would
> be trunated
> [MicroSoft][ODBC SQL server Driver][SQL Server]the statement h
as been
> terminted
> [MicroSoft][ODBC SQL server Driver][SQL Server]errocde = 3
> What's problem?how to solved it'
> Thanks
>

No comments:

Post a Comment