RE: [***SPAM***] [BizTalker] Reusing a SQL Adapter

[gregory.vandewiele]

Try this: http://support.microsoft.com/kb/842449

 

Br,

Gregory

 

From: biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx [mailto:biztalkerlist@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Bradley, Peter
Sent: dinsdag 21 augustus 2007 13:33
To: BizTalker@xxxxxxxxxxxxxxxxxxxxxx
Subject: [***SPAM***] [BizTalker] Reusing a SQL Adapter

 

I’ve also posted this to microsoft.public.biztalk.general.  So apologies for the cross posting, but I really need an answer quickly to this one, if possible.

 

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 application 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

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net

to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net