BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQL Server's databases

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers)
View previous topic :: View next topic  
Author Message
Daryl
Guest





PostPosted: Wed Apr 07, 2004 6:00 am    Post subject: SQL Server's databases Reply with 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
George Christoforakis
Guest





PostPosted: Wed Apr 07, 2004 1:13 pm    Post subject: Re: SQL Server's databases Reply with quote



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





PostPosted: Thu Apr 08, 2004 12:16 pm    Post subject: Re: SQL Server's databases Reply with quote



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
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.