|
Home > Archive > BizTalk Server General > February 2006 > Creating SQL ports fails! BTS 2004
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 |
Creating SQL ports fails! BTS 2004
|
|
| Mike R 2006-02-22, 5:57 pm |
| Hi,
I have a SQL database running on server x. In the database I have 3 or more
storedproceedures. I want to execute these in BT.
I created my first port and recieve location with no issues, however, I then
tried to add a second SQL port and it complained about the URI needing to be
unique. How do I achieve this is I need to run the SPs from the same
database on the same server?
Thanks
Mike (confused)!
| |
| Leonid Ganeline 2006-02-22, 5:57 pm |
| Look at the article in BTS Help "Configuring a SQL Receive Locaton".
You should change the URI manualy. It's the trick of the SQL adapter. There
are a lot of them.
--
Regards,
Leonid Ganeline
BizTalk developer
Vancouver
http://geekswithblogs.net/leonidganeline
===================================
"Mike R" <noreturnaddress@hotmail.co.uk> wrote in message
news:dthsq9$hc6$1$830fa7a5@news.demon.co.uk...
> Hi,
>
> I have a SQL database running on server x. In the database I have 3 or
> more storedproceedures. I want to execute these in BT.
>
> I created my first port and recieve location with no issues, however, I
> then tried to add a second SQL port and it complained about the URI
> needing to be unique. How do I achieve this is I need to run the SPs from
> the same database on the same server?
>
> Thanks
>
> Mike (confused)!
>
| |
| Mike R 2006-02-22, 5:57 pm |
| Thanks Leonid, that did the trick
"Leonid Ganeline" <leo_gan_57@hotmail.com> wrote in message
news:%23eArd5%23NGHA.208@tk2msftngp13.phx.gbl...
> Look at the article in BTS Help "Configuring a SQL Receive Locaton".
> You should change the URI manualy. It's the trick of the SQL adapter.
> There are a lot of them.
>
> --
>
> Regards,
>
> Leonid Ganeline
> BizTalk developer
> Vancouver
> http://geekswithblogs.net/leonidganeline
> ===================================
>
>
> "Mike R" <noreturnaddress@hotmail.co.uk> wrote in message
> news:dthsq9$hc6$1$830fa7a5@news.demon.co.uk...
>
>
|
|
|
|
|