can ASP get a list of databases and tables of SQL Server at run time?

[John Davis]

When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?

Please advice. Thanks!
John

[John Davis]

When we want to get data access, we need to specify the datasource name and
table name in ASP page. I want to know if we can get the list of databases
and tables of SQL Server at run time? i.e. The user can choose the database
or table to open, and get the records of the table?

Please advice. Thanks!
John

[Ken Schaefer]

Yes, you can! :-)

There are three ways that I can think of:
a) query the system tables
b) use ADOX
c) use the ADO Schema

Cheers
Ken


"John Davis" <jrefactor@hotmail.com> wrote in message
news:elqSUrTZDHA.2352@TK2MSFTNGP12.phx.gbl...
: When we want to get data access, we need to specify the datasource name
and
: table name in ASP page. I want to know if we can get the list of databases
: and tables of SQL Server at run time? i.e. The user can choose the
database
: or table to open, and get the records of the table?
:
: Please advice. Thanks!
: John
:
:
:

[Ken Schaefer]

Yes, you can! :-)

There are three ways that I can think of:
a) query the system tables
b) use ADOX
c) use the ADO Schema

Cheers
Ken


"John Davis" <jrefactor@hotmail.com> wrote in message
news:elqSUrTZDHA.2352@TK2MSFTNGP12.phx.gbl...
: When we want to get data access, we need to specify the datasource name
and
: table name in ASP page. I want to know if we can get the list of databases
: and tables of SQL Server at run time? i.e. The user can choose the
database
: or table to open, and get the records of the table?
:
: Please advice. Thanks!
: John
:
:
:

[Curt_C [MVP]]

[url]http://www.darkfalz.com/1065/[/url]

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
[url]http://www.Darkfalz.com[/url]
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------


"John Davis" <jrefactor@hotmail.com> wrote in message
news:elqSUrTZDHA.2352@TK2MSFTNGP12.phx.gbl...

> When we want to get data access, we need to specify the datasource name

and

> table name in ASP page. I want to know if we can get the list of databases
> and tables of SQL Server at run time? i.e. The user can choose the

database

> or table to open, and get the records of the table?
>
> Please advice. Thanks!
> John
>
>
>

[Curt_C [MVP]]

[url]http://www.darkfalz.com/1065/[/url]

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
[url]http://www.Darkfalz.com[/url]
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------


"John Davis" <jrefactor@hotmail.com> wrote in message
news:elqSUrTZDHA.2352@TK2MSFTNGP12.phx.gbl...

> When we want to get data access, we need to specify the datasource name

and

> table name in ASP page. I want to know if we can get the list of databases
> and tables of SQL Server at run time? i.e. The user can choose the

database

> or table to open, and get the records of the table?
>
> Please advice. Thanks!
> John
>
>
>