Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: asp and as400 data

    Hello,

    I have to make a webpage (on IIS) with a database on AS400. I use asp. For the database connection, I use the ODBC Client Access driver.
    The problem is that when I want to put something on the screen, sometimes it works and sometimes it is very slowly (actualy the page keeps loading). This is strange because I don't change anything on my code. This is even with a very simple sql string (SELECT [DATA] FROM [TABLE])...
    Why does it work sometimes? Most of the time, my browser keeps loading and nothing happens. On the end of the page I close my recordset and connection. So I don't think it's that problem.

    Anybody know why? Thnx!

  2. #2
    Join Date
    Oct 2002
    Location
    Argentina
    Posts
    72
    Try setting your recordsets to Nothing

    Set MyRecordset=Nothing

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    Yes I know, I do this standard. But it doesn't work.

  4. #4
    Join Date
    Oct 2003
    Location
    Glasgow, UK
    Posts
    8

    Re: asp and as400 data

    No idea, sorry, but use the OLEDB Provider instead of that Client Access stuff.

    Originally posted by qtip
    Hello,

    I have to make a webpage (on IIS) with a database on AS400. I use asp. For the database connection, I use the ODBC Client Access driver.
    The problem is that when I want to put something on the screen, sometimes it works and sometimes it is very slowly (actualy the page keeps loading). This is strange because I don't change anything on my code. This is even with a very simple sql string (SELECT [DATA] FROM [TABLE])...
    Why does it work sometimes? Most of the time, my browser keeps loading and nothing happens. On the end of the page I close my recordset and connection. So I don't think it's that problem.

    Anybody know why? Thnx!

Posting Permissions

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