Hema,
Is there are reason why you need to do this by code? Why not:
1. Use enterprise manager, add the database server and examine the databases that way.
2. Ask the system administrator.
Barry.
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, 9 May 2006 6:17 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: SV: [Axapta-Knowledge-Village] how do i get the database server names, database names
Hi,
it is working fine. pls. kindly tell me how do i get the databases names under the selected sql server and also its corresponding userid and password. urgent.
regs,
Hema. S
"Thomas Jensen"
<[EMAIL PROTECTED]> To: <Axapta-Knowledge-Village@yahoogroups.com>
Sent by: cc:
[EMAIL PROTECTED] Subject: SV: [Axapta-Knowledge-Village] how do i get the database
groups.com server names, database names
05/09/2006 12:56 PM
Please respond to
Axapta-Knowledge-Village
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 Business to Small business
course business finance finance
Business finance Business finance Business finance
consultant magazine schools
YAHOO! GROUPS LINKS
Visit your group "Axapta-Knowledge-Village" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------ Yahoo! Groups Sponsor --------------------~--> Protect your PC from spy ware with award winning anti spy technology. It's free.
http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
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
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.