var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DB2 issue with OpenSchema(adSchemaTables)
I already asked on the Visual basic forum and somebody suggested me to ask here.
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
the suggestion from the VB forum was :
learn how to retrieve the table schema and then use this code :
Set TablesSchema = Conn.Execute(DB2OpenSchemaCode)
My goal is to be able to clean an account with tables, views, procs, functions so I try to list all and after I make a drop.