BizTalk Server General - Getting Biztalk 2004 SQL Server name

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > November 2004 > Getting Biztalk 2004 SQL Server name





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Getting Biztalk 2004 SQL Server name
Lars Mathiesen

2004-11-18, 7:46 am

Hi

Is it possible to find the Biztalk SQL Server name from code in C#?
(from a C# application on the Biztalk server...)

Thanks in advance

Lars Mathiesen
Devdutt Patnaik

2004-11-18, 7:46 am

Yup, all you need to do is look up the right place in the registry.
I've put up the code-snippet on my blog.
http://mindfever.home.comcast.net/2...er-db-name.html
Regards
Dev
"Lars Mathiesen" <mathiesen.lars@gmail.com> wrote in message
news:86b76ddd.0411180448.1691bdce@posting.google.com...
> Hi
>
> Is it possible to find the Biztalk SQL Server name from code in C#?
> (from a C# application on the Biztalk server...)
>
> Thanks in advance
>
> Lars Mathiesen



Mike Watson

2004-11-19, 7:46 am

i think that you can also get this information from the biztalk wmi classes
take a look @
ms-help://BTS_2004/SDK/htm/ebiz_sdk_wmi_reference_core_stxe.htm

cheers,
mike watson

"Lars Mathiesen" wrote:

> Hi
>
> Is it possible to find the Biztalk SQL Server name from code in C#?
> (from a C# application on the Biztalk server...)
>
> Thanks in advance
>
> Lars Mathiesen
>

Balaji Thiagarajan

2004-11-19, 5:48 pm

It's recommended to use WMI classes than accessing the registry directly.
Take a look at
ms-help://BTS_2004/SDK/htm/ebiz_sdk_wmi_msbts_msgboxsetting_cpiv.htm

"MsgBoxDBServerName" property will return the name of the SQL Server where
the MessageBox setting database is located.

--
Balaji Thiagarajan
MCP (BizTalk)
http://biztalkbits.blogspot.com
--


"Mike Watson" <MikeWatson@discussions.microsoft.com> wrote in message
news:0A11CAA5-9116-46DB-B23A-46F83891E905@microsoft.com...
> i think that you can also get this information from the biztalk wmi

classes[vbcol=seagreen]
> take a look @
> ms-help://BTS_2004/SDK/htm/ebiz_sdk_wmi_reference_core_stxe.htm
>
> cheers,
> mike watson
>
> "Lars Mathiesen" wrote:
>


Bingzheng Zu[MSFT]

2004-11-22, 5:48 pm

Check this registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Bi
zTalk
Server\3.0\Administration\MgmtDBServer

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com