ASP connection to AS400

Results 1 to 2 of 2

Thread: ASP connection to AS400

  1. #1
    Join Date
    Dec 1969

    Default ASP connection to AS400

    Ok folks I need some real help. I have to connect to a AS400 db. I have Client access installed on my iis server.<BR>the following code does not work it just locks up when the is used if i comment it out then the state comes back as 0, but with in place it just runs and runs. Help please<BR>&#060;% <BR>dim DNS1, objConn, SQLString, rs, strSERIAL<BR><BR>%&#062;&#060;% <BR>Set objConn = Server.createobject("ADODB.connection")<BR><BR>obj Conn.connectionstring = "UID=USERQC;PWD=Lewinsky;SYSTEM=;DRIVER= {Client Access ODBC Driver (32-bit)};DBQ=KPDAT11;"<BR><BR>response.wr ite objconn.state<BR>Set rs=server.createobject("ADODB.Recordset") <BR><BR>&#039;rs.Open "SELECT * FROM KPDAT11.I2IC150M WHERE I2LCPPN = &#039;H711A&#039;", objConn<BR> %&#062;

  2. #2
    Join Date
    Dec 1969

    Default Answered in Advanced forum


Posting Permissions

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