Results 1 to 2 of 2

Thread: DB2 Connect

  1. #1
    Join Date
    Feb 2006
    Posts
    1

    Question Unanswered: DB2 Connect

    Hi,

    I would connect me to DB2 database with ASP. I've a ASP server and DB2 server (where there's the database).

    I installed DB2 Connect on ASP server , created a DSN System and tested (the connection is successful).

    But when I try with a ASP page, it's impossible. I use the same DSN, same uid and same pwd.

    In my ASP page :
    <%
    Dim connBdD
    Set connBdD = Server.CreateObject("ADODB.Connection")
    connBdD.ConnectionString = "DSN=D2CPLOC;uid=D2CPAD1;pwd=HUBERT"
    connBdD.open
    %>

    If I execute this, I've :
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [IBM][CLI Driver] SQLSTATE=
    /Ordo/TWS/test.asp, line 5

    Where's the problem ?

    Thanks

    Yannick

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    If you can't get the DSN connection to work, perhaps you could try this:

    http://www.carlprothman.net/Default....ProviderForDB2
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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