Re: Second SQL adapter on the same database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Peter,

Have a look at
http://groups.google.nl/group/microsoft.public.biztalk.general/browse_thread/thread/a8ab7a1648f1eb3b/76b5b75abb846796?lnk=st&q=Address+should+be+unique+for+receive+location++SQL&rnum=1&hl=nl#76b5b75abb846796.

This will help you solve the problem.

HTH,

*** Dijkstra

On Aug 21, 1:18 pm, "Peter Bradley" <pbrad...@xxxxxxxxxx> wrote:
We recently implemented a BTS 2006 application that obtained data via a
stored procedure from a particular remote SQL Server 2000 database via a SQL
adapter.

We are now on the point of implementing another one that gets data from the
same database (using a different stored procedure, of course), but when I
point it to the live data it will not create the receive location because it
says that there is already one using the same connection string. How can I
connect two or more SQL adapter receive locations to a database, and how can
I configure them each to use a different stored procedure?

The error message I'm getting is:

"Address should be unique for receive location 'CimisSqlReceive Location'.
Address 'SQL://cimislivedb/cimis' is already present for
'ItregSqlReceiveLocation'. (Microsoft.BizTalk.ExplorerOM)"

Cheers

Peter


.

Quantcast