Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012

    Unanswered: ASP connect to DB2 on IBM system i


    Now, I create ODBC of system i access software and config finished

    But, I can not get data form database on System i for show

    Souce code as below.
    (It connected to ODBC but can not get data for show)

    ConnectionString= "Driver={iSeries Access ODBC Driver}; System=; UID=PCS; PWD=PCS;"
    set con = Server.CreateObject("ADODB.Connection")

    Set rs = Server.CreateObject("ADODB.Recordset")

    on error resume next

    set rs=server.CreateObject("adodb.recordset")
    sql="select * from KORAKOTLIB.QRPGSRC" sql,conn,1,3
    if err.number<> 0 then
    response.write err.Description&"<br>"
    response.write err.source&"<br>"
    response.write err.number
    response.write "succeed"
    end if

    on error goto 0

    On run it display error :
    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

    Please support me for rolve this problme

    if nay question or not clear, please post message in this borad..

    Thank you.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    What is the "1, 3" for?
    oh yeah... documentation... I have heard of that.

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

  3. #3
    Join Date
    Jul 2012

    It is type of connection sql,conn,1,3

    It is type of connection

    You have sample source code for connection ?

    Thank you

Posting Permissions

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