SQL Stored Procedure & VB6
I need to get a list of DB's, Tables and Fields from a VB6 app. I know that in SQL there are standard stored procedures that will return this data (sp_HelpDB, sp_tables and sp_columns)
My problem is how do I excecute these from VB6 And get the results back into the app? Or is there a better way to do this?