| Author |
SQL Schema not getting Generated
|
|
|
| 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
| |
| Joerg Fischer 2007-02-19, 7:16 am |
| 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
>
| |
|
| 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...
>
>
|
|
|
|