try something like this
sqlserver = new COM("SQLDMO.SQLServer*\..........."*);
if(sqlserver.connect(servername,userid,password))
where \............ should be replaced by \DatabaseName hope this should
work but not sure.
And let me know.
On 5/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> i can test the connection using
>
> sqlserver = new COM("SQLDMO.SQLServer");
> if(sqlserver.connect(servername,userid,password))
>
> but, if i have more than one database in the server, how do i specify the
> database in the above statement. in the above statement, only servername,
> userid and password are given. i want to specify the database name also to
> force the system to test the connection only in the specified database.
>
>
> pls. provide the solution. Thank u.
>
> 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
- 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.