Development Tools Forum

Re: .NET Provider Unknown SQL Type - 0

Posted By: Jonathan Leffler
Date: Wednesday, 1 September 2010, at 2:11 a.m.

In Response To: .NET Provider Unknown SQL Type - 0 (MARCO PéREZ)

I assume there is a good reason why you are using a product that is no
longer supported (IDS 9.40 has been out of support for a while; 10.00 goes
out of support at the end of September 2010.)

2010/8/31 MARCO PéREZ <light.kuragari@gmail.com>

> Hi all, I've been dealing with this problem for several days now, i've
> googled
> and searched bt nothing.
>
> I am connecting to an Informix Dynamic Server 9.4 Database, and i'm doing
> so
> through the .NET Provider that comes in CSDK 3.0 TC3. I know there's the
> 3.5
> version, but i'm using v3 because in the docs it says that v3.5 supports
> dynamic server 10.0 up, and v3's docs say that it supports from 9.3.
>
> I want to call a stored procedure that accepts a char(2), and an integer as
> parameters, and returns a table consisting of char(2), char(2), char(1) and
> char(60).
>
> This is the code i use to call the stored procedure (after i open my
> connection):
>
>
I don't know enough to be able to help. With Informix, type 0 is usually
CHAR - using the native type numbers. However, the World of .NET may have
other views on the valid type numbers. The .NET provider should handle it.
It may be a fixed bug in the more recent providers - but using that probably
requires a server upgrade too.

> =======================================================CODE:
>
> object[] parametros = new object[]{"DG",1};
>
> IfxDataAdapter adaptador = new IfxDataAdapter();
>
> adaptador.SelectCommand = connection.CreateCommand();
>
> adaptador.SelectCommand.CommandText = "mystoredproc";
>
> adaptador.SelectCommand.CommandType = CommandType.StoredProcedure;
>
> //Add parameters
>
> if (parametros != null)
>
> {
>
> foreach (object parameter in parametros)
>
> {
>
> IfxParameter dbparam = new IfxParameter();
>
> if (dbparam.Value.GetType() == typeof(string))
>
> {
>
> dbparam.IfxType = IfxType.Char;
>
> }
>
> adaptador.SelectCommand.Parameters.Add(dbparam);
>
> }
>
> }
>
> try
>
> {
>
> adaptador.Fill(mDataSet);
>
> }
> ===================================================================
>
> 1.- As you can see, i'm forcing the use of IfxType.Char, since the provider
> automatically maps the type to varchar, but even if i assign it like this,
> it
> stays as varchar.
>
> 2.- I've also done this by assigning the corresponding parameterName to
> each
> parameter, with the names they were defined in the stored procedure's
> parameter definition section.
>
> 3.- THE PROBLEM comes when executing adaptador.Fill(mDataSet); it throws an
> exception that says Unknown SQL Type - 0.
>
> I've also tried this by first using IfxCommandBuilder.DeriveParameters on
> adaptador.SelectCommand, and it populates the parameters (although it adds
> an
> extra RETURN parameter at the beginning and an extra "Parameter 1"
> parameter
> at the end, so i removed them) but the same exception is thrown at
> adaptador.Fill()
>
> Could someone please help me with this? I have to finish this project but
> have
> been days trying different things with no success.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.

--0016361e84a8608421048f2c91b2

Messages In This Thread

• .NET Provider Unknown SQL Type - 0
  MARCO PéREZ -- Tuesday, 31 August 2010, at 6:07 p.m.
  • Re: .NET Provider Unknown SQL Type - 0
    Jonathan Leffler -- Wednesday, 1 September 2010, at 2:11 a.m.
    • Re: .NET Provider Unknown SQL Type - 0
      MARCO PéREZ -- Wednesday, 1 September 2010, at 2:39 a.m.
      • Re: .NET Provider Unknown SQL Type - 0
        Jonathan Leffler -- Saturday, 4 September 2010, at 5:51 p.m.
        • Re: .NET Provider Unknown SQL Type - 0
          Art Kagel -- Saturday, 4 September 2010, at 9:15 p.m.
          • Re: .NET Provider Unknown SQL Type - 0
            MARCO PéREZ -- Tuesday, 7 September 2010, at 1:38 p.m.
          • Re: .NET Provider Unknown SQL Type - 0
            Jonathan Leffler -- Thursday, 9 September 2010, at 12:52 a.m.
        • Re: .NET Provider Unknown SQL Type - 0
          MARCO PéREZ -- Tuesday, 7 September 2010, at 1:34 p.m.

Development Tools Forum is maintained by Administrator with WebBBS 5.12.