🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.csharpbuilder.language.csharp
Article #497

ExecuteReader error when run a Stored Procedure

#497
From: Diego
Date: Thu, 10 Feb 2005 16:39
30 lines
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-mail

Show 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