BizTalk Server Applications Integration - SQL adapter missing dependancies on delpoyment server.

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > March 2006 > SQL adapter missing dependancies on delpoyment server.





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 SQL adapter missing dependancies on delpoyment server.
AL

2006-02-26, 10:47 am

Hi

I have BizTalk server deployed and connecting to a SQL 2000 server. This
server has SP3a and SQLXML3 installed on it.

I am using the SQL Adapter to send data to a database on the same SQL
server. The problem I encounter is the messages sent to the adapter fail with
the following error:

Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5740
Date: 22/02/2006
Time: 02:37:56
User: N/A
Computer: CHQLACSRV
Description:
The adapter "SQL" raised an error message. Details "File or assembly name
Microsoft.Data.SqlXml, or one of its dependencies, was not found.".

I was prompted to install MDAC before I could complete the BizTalk
installation, which I completed. I think I may have installed a version high
than what I was prompted for, however it did then allow me to complete my
BizTalk installation.

I've seen a post about deploying SQLXML which I tried, with no success.

Any help would be appreciated.

Thanks in advance
Al
Jan Eliasen

2006-02-26, 10:47 am

On Thu, 23 Feb 2006 23:45:28 -0800, "AL"
<AL@discussions.microsoft.com> wrote:

>The adapter "SQL" raised an error message. Details "File or assembly name
>Microsoft.Data.SqlXml, or one of its dependencies, was not found.".

Have you installed the SOAP Toolkit?

--
Eliasen Jr. representing himself and not the company he works for.

Private email: jan@eliasen.dk

"Ford," he said, "you're turning into a penguin. Stop it."
AL

2006-03-03, 6:17 pm

Hi

I tried to install the SOAP toolkit and was prompt to Repair. I did this and
still had the same result.

I then uninstalled SOAP and SQLXML, reinstalled MDAC 2.8, SOAP and SQLXML.
Doing this has fixed the problem.

Many thanks

Al

"Jan Eliasen" wrote:

> On Thu, 23 Feb 2006 23:45:28 -0800, "AL"
> <AL@discussions.microsoft.com> wrote:
>
> Have you installed the SOAP Toolkit?
>
> --
> Eliasen Jr. representing himself and not the company he works for.
>
> Private email: jan@eliasen.dk
>
> "Ford," he said, "you're turning into a penguin. Stop it."
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com