Hi

I am using Biztalk 2006 and VS .Net 2005.
When I Add Generated Items -> Sql Adapter -> Receive port -> Specify
Select au_fname from authors for xml auto,elements

I don't get any message and no schema is generated.

In event viewer the following message is logged :
The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be
found. The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer. You may be abl
e
to use the /AUXSOURCE= flag to retrieve this description; see Help and
Support for details. The following information is part of the event: Unable
to open shim database version registry key - v2.0.50727.00000.

Can you help me what must be the problem?

Thanks
Raj

[ Post a follow-up to this message ]

Hi,

Try to use the following SQL statement in the wizard:
au_fname from authors for xml auto (exclude the elements)

The Event Log entry should have nothing to do with the problem you are
facing.

Have you installed all necessary prerequisites? Is the SQL server a local
instance or remote?

Sincerely

Joerg Fischer
BizTalk MVP

"Raj" <Raj@discussions.microsoft.com> schrieb im Newsbeitrag
news:C15F6CF7-FD89-4E8B-830D-DDFA2A01054A@microsoft.com...
> Hi
>
> I am using Biztalk 2006 and VS .Net 2005.
> When I Add Generated Items -> Sql Adapter -> Receive port -> Specify
> Select au_fname from authors for xml auto,elements
>
> I don't get any message and no schema is generated.
>
> In event viewer the following message is logged :
> The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be
> found. The local computer may not have the necessary registry information
> or
> message DLL files to display messages from a remote computer. You may be
> able
> to use the /AUXSOURCE= flag to retrieve this description; see Help and
> Support for details. The following information is part of the event:
> Unable
> to open shim database version registry key - v2.0.50727.00000.
>
> Can you help me what must be the problem?
>
> Thanks
> Raj
>

[ Post a follow-up to this message ]

Hi

I tried with the  Select au_fname from authors for xml auto (exclude the
elements)
but still the schema is not getting generated.

I have local copy of Sql Server 2000.

Th following prerequisite are installed :
ADOMD.NET.msi
ADOMD.Net-KB893091-v8.00.0991-x86.EXE
dotnetfx.exe
mdac_typ.exe
msxml6.msi
owc11.exe
SQLServer2005_ADOMD.msi
sqlxml.msi

Am i missing some prerequistie or some service packs ?

Thanks
Rajeev
"Joerg Fischer" wrote:

> Hi,
>
> Try to use the following SQL statement in the wizard:
> au_fname from authors for xml auto (exclude the elements)
>
> The Event Log entry should have nothing to do with the problem you are
> facing.
>
> Have you installed all necessary prerequisites? Is the SQL server a local
> instance or remote?
>
> Sincerely
>
> Joerg Fischer
> BizTalk MVP
>
> "Raj" <Raj@discussions.microsoft.com> schrieb im Newsbeitrag
> news:C15F6CF7-FD89-4E8B-830D-DDFA2A01054A@microsoft.com... 
>
>

[ Post a follow-up to this message ]