connecting to DB2- help required for a beginner

Results 1 to 3 of 3

Thread: connecting to DB2- help required for a beginner

  1. #1
    Join Date
    Dec 1969
    Posts
    51

    Default connecting to DB2- help required for a beginner

    could any one help me out , i have a problem in connecting to db2 , following is the script using<BR><BR><BR>strsql="select deptnumb from jeya.org"<BR>strdsn="dsn=sample;uid=jeya;pwd=valan "<BR>set cn=server.CreateObject ("adodb.connection")<BR>set rs=server.CreateObject ("adodb.recordset")<BR>cn.open strdsn<BR>rs.open strsql,cn<BR><BR>a=rs.deptnumb<BR>Response.write (a)<BR>rs.close<BR>cn.close<BR><BR>set rs=nothing<BR>set cn=nothing<BR><BR><BR>pl suggest me<BR><BR><BR><BR>i am getting the following error<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[ <BR><BR>/avt/db2.asp, line 16 <BR><BR><BR><BR>thanks<BR>regards<BR>gopi<BR>gopin ath3@hotmail.com

  2. #2
    Sathiya Guest

    Default RE: connecting to DB2- help required for a beginne

    I didnt work in DB2 with ASP but try to give Provider and Filename in the Connection String

  3. #3
    Join Date
    Dec 1969
    Posts
    51

    Default RE: connecting to DB2- help required for a beginne

    hello sathya<BR><BR><BR>same problem persists

Posting Permissions

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