Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    1

    Question Unanswered: Informix .Net Provider asp.net null values on execution on reader

    Hi,

    I am expiriencing a strange problem that I can not solve.

    I have an asp.net application and I have made a setup of the Informix .Net provider.

    When I run my application with F5 in debugg mode everything works fine, but the same application with the same unchanged code and on the same machine doesn't work on IIS 7. When I run it on IIS 7 the Connection to database opens fine, and after executing the IfxDataReader I recieve a null value.

    ????

    Apsolutly the same code, same machine, same database and problems ???


    Can you help

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I don't know about informix specifically but usually if you have this sort of issue in ASP.NET it's due to a credential or other configuration issue.

    What are you using for your connection string? Are you explicitly defining a username/password? Have you tried attaching to the IIS process to inspect your connection/reader and make sure it's connecting with the credentials you think it is?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Sep 2004
    Posts
    51

    formix .Net Provider asp.net null values on execution on reader

    You may want to check on the configuration with the user running in debug and the one running in IIS7. If you are using Informix Dynamic server then the database admin can turn on sqlexplain for the session running the asp program.

    It sounds like the connection is using multiple ports where the connection starts on one port but return the results on a different port. You may want to check the configuration as the previous user already stated.

    I hop this helps.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •