SV: [Axapta-Knowledge-Village] how do i get the database server names, database names

Tue, 09 May 2006 00:27:48 -0700

Try this:
static void ListSQLServers(Args _args)
{
    COM com = new COM("SQLDMO.Application");
    COM servers = com.ListAvailableSQLServers();
    int i;
    ;
    for (i=1;i<=servers.count();i++)
        info(servers.item(i));
}

regards
Thomas

________________________________

Fra: Axapta-Knowledge-Village@yahoogroups.com på vegne af [EMAIL PROTECTED]
Sendt: ti 09-05-2006 09:07
Til: Axapta-Knowledge-Village@yahoogroups.com; development-axapta@yahoogroups.com
Emne: [Axapta-Knowledge-Village] how do i get the database server names, database names




Hi,

how do i get all the database server names from all the machines in an
organization?

ex:
-----
in aos settings, we can see the list of database servers against Server
combo. how do i get all those names thro' x++ coding? based on the
selection of server, i want to get the database names. again i want to get
the userid and password of the specified database name.

wherever sql server is installed in the machines, all the server names and
its corresponding database names, userid and password should be displayed
in the combo. how do i do?


pls. provide the solution. urgent.


regs,
Hema. S






Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links













[Non-text portions of this message have been removed]



Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.



SPONSORED LINKS
Business finance course Business to business finance Small business finance
Business finance consultant Business finance magazine Business finance schools

YAHOO! GROUPS LINKS



Reply via email to