ADOX - tables in an SQL Server Schema not listed -
I am retrieving table names using ADOX, but any table, other than DBO Not listed in Schema, are not listed.
sub listababo () as new dimension of ADOB.Connection 'Conne.Provider = "MSDASQL" Conn.Open "DSN =" to get the Open Connection Database objects you want. ..; Database = ...; "," UID "," PWD "'Create Catalog Object, New Adox. Catalog, as catalog set catalog. ActiveConcation = Connection 'table and column dim tableble for each table in the form of adoices. Debug Print table I left the code using ADOX, re-coded all of my catalog information processes, instead of using ADO OpenSecma methods. While doing so, I could not find ADOX beyond the DO schema.
Comments
Post a Comment