This topic is locked

DB2 issues

10/22/2003 12:54:59 PM
ASPRunnerPro General questions
author

Having trouble getting my AS/400 ODBC to accept SQL string and properly produce pages.
First...
I can connect with no problem.

Field selections, no problem.
On the SQL string it does not like [ or ] brackets.
I took them out in "manual edit" but the compiled .asp pages still had a few brackets them which I took out where I could find them.
The output looks like it is partially able to produce the expected results but there is still significant scambling, especially on each page before the results tables.
Very anxious to get this working. Looks like a great product!
Thank you!
Alan

Sergey Kornilov admin 10/22/2003

Alan,
here is what you can do:

  1. Open include/..._variables.asp file in any text editor
  2. Remove any [ or ] brackets you see in this file. They can be found in the following variables: strTableName, strLeftWrapper, strRightWrapper, gstrSQL.
    I hope this helps.
    PS. Do you use AS/400 or DB2 database?
    Best regards,

    Sergey Kornilov