469,290 Members | 1,804 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,290 developers. It's quick & easy.

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

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

Jul 19 '05 #1
2 3293
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" <jr*******@hotmail.com> wrote in message
news:el**************@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
:
:
:
Jul 19 '05 #2
http://www.darkfalz.com/1065/

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------
"John Davis" <jr*******@hotmail.com> wrote in message
news:el**************@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

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Bart Torbert | last post: by
1 post views Thread by SkyGringo | last post: by
1 post views Thread by SkyGringo | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.