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

    Unanswered: ASP connect to DB2 on IBM system i

    Hi.

    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=10.230.1.32; UID=PCS; PWD=PCS;"
    set con = Server.CreateObject("ADODB.Connection")
    con.open(ConnectionString)


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


    on error resume next

    set rs=server.CreateObject("adodb.recordset")
    sql="select * from KORAKOTLIB.QRPGSRC"
    rs.open sql,conn,1,3
    if err.number<> 0 then
    response.write err.Description&"<br>"
    response.write err.source&"<br>"
    response.write err.number
    else
    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.
    ADODB.Recordset
    3001

    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
    Location
    The Bottom of The Barrel
    Posts
    6,102
    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
    Posts
    2

    It is type of connection

    rs.open 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
  •