Article View: borland.public.csharpbuilder.language.csharp
Article #497ExecuteReader error when run a Stored Procedure
From: Diego
Date: Thu, 10 Feb 2005 16:39
Date: Thu, 10 Feb 2005 16:39
30 lines
1802 bytes
1802 bytes
I have this code:
string connS =
Provider=interbase;Database=192.198.0.1:C:\\db\\ENGLAND.GDB;UserName=SYSDBA;Password=masterkey";
BdpConnection Conn = new BdpConnection();
Conn.ConnectionString =connS;
Conn.Open();
Trans = (BdpTransaction)Conn.BeginTransaction();
Comm = (BdpCommand) Conn.CreateCommand();
Comm.Connection = Conn;
Comm.Transaction = Trans;
Comm.CommandText = "execute procedure SP_TEST(param1,param2)";
Comm.Prepare();
textBox1.Text = "";
BdpDataReader rr = Comm.ExecuteReader();
while(rr.Read())
{
textBox4.Text += rr.GetInt16(0).ToString();
}
rr.Close();
The stored procedure return 1 integer.
When the ExecuteReader method being run, the compiler give me thi message:
Non Managed Exception "Borland.Data.Common.BdpException" in
borland.data.provider.dll
Additional Informations: Execute failed. message length error (encountered
0, expected 8)
What can i do?
Technical Details
Message-ID:
<420b8e5a@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 1efe35,9e2383c0640ddf8b,start X-Google-Attributes: gid1efe35,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Diego" <diego@magex.loc> Newsgroups: borland.public.csharpbuilder.language.csharp Subject: ExecuteReader error when run a Stored Procedure Date: Thu, 10 Feb 2005 17:39:54 +0100 Lines: 32 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 62.94.191.249 Message-ID: <420b8e5a@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1108053594 62.94.191.249 (10 Feb 2005 08:39:54 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!proxad.net!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail