| View previous topic :: View next topic |
| Author |
Message |
Daryl Guest
|
Posted: Wed Apr 07, 2004 6:00 am Post subject: SQL Server's databases |
|
|
Hi all
I would like to develop a small from that will allow a user to browse for
SQL Servers and once one is selected the databases are available for
selection. I would like this so I don't have to hard code in the database
path.
I have had a look and there appears to be a couple of ways to do it ie use
the SQLDMO suite or the ODBC API SQLDataSources or perhaps the API
NetServerEnum - I don't know if there is a way to then get at the databases
using this approach.
Any comments, or examples would be very very nice.
Thanks
Daryl
|
|
| Back to top |
|
 |
George Christoforakis Guest
|
Posted: Wed Apr 07, 2004 1:13 pm Post subject: Re: SQL Server's databases |
|
|
Try the PromptDatasource. Unit AdoDB.
George Christoforakis.
"Daryl" <daryl.stock (AT) qr (DOT) com.au> wrote
| Quote: | Hi all
I would like to develop a small from that will allow a user to browse for
SQL Servers and once one is selected the databases are available for
selection. I would like this so I don't have to hard code in the database
path.
I have had a look and there appears to be a couple of ways to do it ie use
the SQLDMO suite or the ODBC API SQLDataSources or perhaps the API
NetServerEnum - I don't know if there is a way to then get at the
databases
using this approach.
Any comments, or examples would be very very nice.
Thanks
Daryl
|
|
|
| Back to top |
|
 |
Jim Elden Guest
|
Posted: Thu Apr 08, 2004 12:16 pm Post subject: Re: SQL Server's databases |
|
|
Hi Daryl,
| Quote: | I would like to develop a small from that will allow a user to browse for
SQL Servers and once one is selected the databases are available for
selection. You may find this useful:
|
http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=17523
--
Jim
|
|
| Back to top |
|
 |
|