This message was edited by the ljuba at 2002-3-16 15:51:4

---

I took all MySQL databases and tables in some database in PHP like this:

$listdb = mysql_list_dbs();
$listtb = mysql_list_tables ($currdb);

How I can make this in ASP for Access databases (or for MS SQL)?

Or if I choose mdb file how to know 'structure' ... tables, fields of tables, ...?

Thanks

Aleksandar

Try posting this in an ASP messageboard
: This message was edited by the ljuba at 2002-3-16 15:51:4

---

: I took all MySQL databases and tables in some database in PHP like this:
:
: $listdb = mysql_list_dbs();
: $listtb = mysql_list_tables ($currdb);
:
: How I can make this in ASP for Access databases (or for MS SQL)?
:
: Or if I choose mdb file how to know 'structure' ... tables, fields of tables, ...?
:
: Thanks
:
: Aleksandar
:
:
:

: Try posting this in an ASP messageboard

Thanks ... I did but no one answered :(((

Bye,

LJUBA

Well, too bad, but if you ask a question about ASP there isn't much chance that someone in the PHP board knows it.
There is a site phpbuilder.com with a very good forum, perhaps you have an equivalent for ASP

: : Try posting this in an ASP messageboard
:
: Thanks ... I did but no one answered :(((
:
: Bye,
:
: LJUBA

OK man !! .. i give you the first few steps !!
* you must be deal with ADO (ActiveX Database Objects) so that you can refer to any thing you want.
* you can connect to mdb files directly!! which i don't prefer, or via ODBC link for more security.
* you can process ANY SQL statment!! so you can create, alter, .. any object!!

send me at (aoz_001@hotmail.com) and i will give you a Sample ASP file.
** Good Luck ... abdullah