Hi Thomas,
thank u very much. it is working. one more doubt is when i give wrong
userid/password, it shows system error. to prevent this, i write the code
within the try catch exception block. but, system shows both the system
provided error and also the following exception error. how to suppress the
system error? pls. provide the solution. sorry for the trouble agin. Thank
u.
catch (Exception::Error)
{
error("Could not connect to database server");
}
regs,
Hema. S
"Thomas Jensen"
<[EMAIL PROTECTED]> To: <Axapta-Knowledge-Village@yahoogroups.com>
Sent by: cc:
[EMAIL PROTECTED] Subject: SV: SV: SV: [Axapta-Knowledge-Village] how do i get the
groups.com database server names, database names
05/15/2006 01:23 PM
Please respond to
Axapta-Knowledge-Village
Hi Hema
If you want to validate the password you should connect using the loginid
and password. If you want to verify which databases the user has been
granted access to you can use the EnumDatabaseMappings method on the login
object.
Example:
static void TestDatabaseAccess(Args _args)
{
str serverName = "(local)";
str loginId = "testuser";
str password = "password";
COM sqlServer = new COM("SQLDMO.SQLServer");
COM logins;
COM login;
COM databases;
int i;
int j;
;
try
{
sqlServer.connect(servername,loginid,password);
logins = sqlServer.logins();
for (i=1;i<=logins.count();i++)
{
login = logins.item(i);
if (login.name()==loginId)
{
databases = login.EnumDatabaseMappings();
for (j=1;j<=databases.rows();j++)
{
info(databases.getColumnString(j,2));
}
}
}
}
catch (Exception::Error)
{
error("Could not connect to database server");
}
}
For documentation of the SQL-DMO object take a look here:
http://msdn.microsoft.com/library/default.asp?url="">
Regards
Thomas
-----Oprindelig meddelelse-----
Fra: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] På vegne af
[EMAIL PROTECTED]
Sendt: 12. maj 2006 06:00
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: RE: SV: SV: [Axapta-Knowledge-Village] how do i get the database
server names, database names
Hi,
i think it will work only after creating datasource. but, i dont want to
use odbc connection. in the following code, tell me how to check with user
password.
COM com = new COM("SQLDMO.Application");
COM servers = com.ListAvailableSQLServers();
COM sqlserver;
COM sqlserver1;
COM databases;
COM database;
COM users;
COM user;
COM Passwords;
COM Pwd;
int i;
int j;
int k;
;
setprefix("SQL Servers");
try
{
sqlserver = new COM("SQLDMO.SQLServer");
sqlserver1 = new COM("SQLDMO.SQLServer");
sqlserver.connect(ListofSqlServers.getEditText());
databases = sqlserver.databases();
for (j=1;j<=databases.count();j++)
{
database = databases.item(j);
setprefix(database.name());
if(database.name()==Databasename.text()) //user input
value)
{
users = database.users();
for (k=1;k<=users.count();k++)
{
user = users.item(k);
setprefix(user.name());
if(user.name()==userid.text()) //user input
value)
{
//here i want to check the user password.
only after that i will show //message it is a
valid connection
info('Valid connection');
}
}
}
}
}
catch (Exception::Error)
{
error("Please check the data entered. Connection could not be
established based on the values provided");
}
regs,
Hema. S
"Bayliss, Barry"
<[EMAIL PROTECTED]> To:
<Axapta-Knowledge-Village@yahoogroups.com>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE:
SV: SV: [Axapta-Knowledge-Village] how do i get the
groups.com database server
names, database names
05/11/2006 04:23 AM
Please respond to
Axapta-Knowledge-Village
Hema,
There is a simpler way to do this, and it can be done using X++.
Here is an extract of code I use
ODBCConnection
FormConnection
(
)
{
#PCDMacro
LoginProperty loginDetails = new LoginProperty();
ODBCConnection currentconnection;
str Database, CurrentServer,
CurrentApplication;
int pos;
;
// Create the connection
database = sqlsystem::databaseBackendDesc();
<. processing the database variable to get the information I
require.>
LoginDetails.setDatabase(Database);
logindetails.setUsername(#loginname);
logindetails.setPassword(#logincode);
currentconnection = new ODBCConnection(logindetails);
return currentconnection;
}
As you see, you can supply:
1. The database. In this case I use the currently connected database
to determine which database I will connect to.
2. The login name. In this case it is stored in a macro.
3. The password. In this case it is stored in a macro.
While this example uses an ODBC connection, there may be other connection
types that can also be used.
Thomas, thanks for the code for supplied.
Barry.
p.s. Hema, by describing your requirement you made it a lot easier to
address your issue.
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, 10 May 2006 3:22 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: SV: SV: [Axapta-Knowledge-Village] how do i get the database
server names, database names
Hi,
thank u very much. i'll tell u my requirement. the user will enter the
servername, database name, userid and password. i have to make test connect
for the given data. if it does not connect, then throw the error.
ex:
----
server name - axapta server
db name - EAM
user id - Hema
password - Hema
i want to check the connection for the above data. if it fails, then throw
error. i tried. but, i dont know how to make test connection for the above.
i specify database name from the input value as server.databases("axapta
server"). it gives error (number of invalid argument"). how do i do?
u specified
database = databases.item(j);
setprefix(database.name());
but, i want to give the database name from the user input value. how do i
give?
pls. provide the solution. sorry for the trouble. Thank u.
regs,
Hema. S
"Thomas Jensen"
<[EMAIL PROTECTED]> To:
<Axapta-Knowledge-Village@yahoogroups.com>
Sent by: cc:
[EMAIL PROTECTED] Subject: SV:
SV: [Axapta-Knowledge-Village] how do i get the database
groups.com server names,
database names
05/09/2006 06:35 PM
Please respond to
Axapta-Knowledge-Village
Hi Hema S
This job will show SQL Servers, their databases and the usernames for each
database. Obviously you will need appropriate trusted login rigths for the
server to retrrive this information. The login names can also be retrieved
from one of the DMO objects but obviously it's not possible to retrieve the
passwords for the logins for security reasons.
Regards
Thomas
static void ListSQLServers(Args _args)
{
COM com = new COM("SQLDMO.Application");
COM servers = com.ListAvailableSQLServers();
COM sqlserver;
COM databases;
COM database;
COM users;
COM user;
int i;
int j;
int k;
;
setprefix("SQL Servers");
for (i=1;i<=servers.count();i++)
{
setprefix(servers.item(i));
try
{
sqlserver = new COM("SQLDMO.SQLServer");
sqlserver.loginsecure(true);
sqlserver.connect(servers.item(i));
databases = sqlserver.databases();
for (j=1;j<=databases.count();j++)
{
database = databases.item(j);
setprefix(database.name());
users = database.users();
for (k=1;k<=users.count();k++)
{
user = users.item(k);
info(user.name());
}
}
}
catch (Exception::Error)
{
info("Could not connect to server");
}
}
}
________________________________
Fra: Axapta-Knowledge-Village@yahoogroups.com på vegne af
[EMAIL PROTECTED]
Sendt: ti 09-05-2006 12:31
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: Re: SV: [Axapta-Knowledge-Village] how do i get the database server
names, database names
Hi Thomas,
Thank u. it is working fine. pls. kindly tell me how do i get the databases
names
under the selected 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.
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.
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.
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 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.
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 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.
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.
