Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: DB2 issue with OpenSchema(adSchemaTables)

    Hi,

    new on this forum I need some help with a DB2 issue

    When I use this code:

    Dim Conn As New ADODB.Connection
    Dim TablesSchema As ADODB.Recordset

    Conn.Provider = "MSDASQL"
    Conn.CursorLocation = adUseClient
    Conn.Open "PROVIDER=MSDASQL;dsn=" + sDSN + ";uid=" + USER + ";pwd=" + PASS + ";"
    Set TablesSchema = Conn.OpenSchema(adSchemaTables)

    I got an error : "Object or provider is not capable of performing requested operation."

    I work with DB2 v8.1 and MDAC 2.8

    I don't have this issue if I work on DB2 v7.1

    Does somebody knows what's wrong ?

    Thanks

  2. #2
    Join Date
    Nov 2004
    Posts
    108
    I think your doing it right
    Code:
    Set TablesSchema = Conn.OpenSchema(adSchemaTables)
    But the error says that your provider provider is not capable of performing requested operation in this case I suggest you place your question in a DB2 forum to learn how to retrieve the table schema and then use this code
    Code:
    Set TablesSchema = Conn.Execute(DB2OpenSchemaCode)
    to err is human ; to really mess things up requires a computer

  3. #3
    Join Date
    Aug 2003
    Posts
    7
    ok thanks I will ask in the DB2 forum with your sample code

Posting Permissions

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