Board index » delphi » SQL Server Names & Databases
NS
Delphi Developer |
Tue, 01 Jul 2003 00:18:06 GMT
|
NS
Delphi Developer |
Tue, 01 Jul 2003 00:18:06 GMT
SQL Server Names & Databases
Does anyone know how I can retrieve the available SQL Server Names on a
Network (the same as the ODBC Administrator shows, when adding a new SQL Server DSN) and add them to a TListBox and then when I click on an available server in the list, it adds the available databases on that server in a secondary listbox? If anyone has a code example of this or something similar (it doesn't matter Thanks for any help provided. |
Euan Garde
Delphi Developer |
Tue, 01 Jul 2003 03:29:12 GMT
Re:SQL Server Names & DatabasesThere are 2 choices, use SQL-DMO, which is the programming model that Enterprise Manager uses or look at the ODBC function SQLBrowseConnect, this is used to enumerate SQL Servers. -Euan Quote"NS" <gi...@nospam.netshift.com> wrote in message Quote> Does anyone know how I can retrieve the available SQL Server Names on a |
Alexei Malmyguin
Delphi Developer |
Tue, 01 Jul 2003 05:38:06 GMT
Re:SQL Server Names & DatabasesIt's also possible to load a list of servers registered on the workstation from the system registry and after that you can log in to the master database on the desired server and read sysdatabases. As I had some bad experience with the list ODBC administrator generated ========================== rSQLServers.CloseKey; // Deleting the extra string slSQLServers.Sort; // Populating the combo box with the SQL servers Alex Quote"NS" <gi...@nospam.netshift.com> wrote in message Quote> Does anyone know how I can retrieve the available SQL Server Names on a |
NS
Delphi Developer |
Tue, 01 Jul 2003 19:28:55 GMT
Re:SQL Server Names & DatabasesEuan, Thanks for the pointers. I am starting to learn DMO development but I'm Thanks for any help provided. Quote"Euan Garden" <euan.gar...@spicedham.usa.net> wrote in message Quote> There are 2 choices, use SQL-DMO, which is the programming model that |
NS
Delphi Developer |
Tue, 01 Jul 2003 19:36:16 GMT
Re:SQL Server Names & DatabasesAlexei, Thanks for the tips on using the registry. However, when I look at regedit Thanks for any help provided. Quote"Alexei Malmyguine" <alex...@usa.net> wrote in message Quote> It's also possible to load a list of servers registered on the workstation |
1. Named Pipes , SQL Server 6.5 & Delphi
2. How to pass Database Name Parameter to SQL Server Procedure from ADOCommand
3. Getting SQL server database name from TDatabase /BDE
4. Sql Server 2000 & Sql Server 7.0
5. ADO SQL build Index and test for unique [First name], [Middle name], [Last name]
7. Advantage Database Server vs SQL Server
8. SQL Databases - MS Sql Server 7 vs. Interbase
9. Creating MS SQL Server database in the specific path Using SQL-DMO
10. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server