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

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -