|
Home > Archive > BizTalk Server Orchestration > June 2005 > sql adapter problem
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 problem
|
|
| Sharon 2005-06-23, 5:55 pm |
| hi guys,
I am new to Biztalk server 2004. I followed this article
http://msdn.microsoft.com/library/d...768ff245df1.asp
and use sql adapter to call a sql store procedure. but I got this error
message:
The adapter failed to transmit message going to send port
"http://SQLAdapterExplore.IssueSelect". It will be retransmitted after the
retry interval specified for this Send Port. Details:"The underlying
connection was closed: The remote name could not be resolved.".
I am the administrator to the database and the computer.
would you please help me out?
thanks
sharon
| |
| McGeeky 2005-06-23, 5:55 pm |
| When you configured the SQL port, did you click the "Test Connection"
button?
--
McGeeky
http://mcgeeky.blogspot.com
"Sharon" <Sharon@discussions.microsoft.com> wrote in message
news:0D754ADA-BDDB-4443-BE10-7079E3DD727F@microsoft.com...
> hi guys,
>
> I am new to Biztalk server 2004. I followed this article
>
http://msdn.microsoft.com/library/d...-us/BTS_2004WP/
html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp
> and use sql adapter to call a sql store procedure. but I got this error
> message:
>
> The adapter failed to transmit message going to send port
> "http://SQLAdapterExplore.IssueSelect". It will be retransmitted after the
> retry interval specified for this Send Port. Details:"The underlying
> connection was closed: The remote name could not be resolved.".
>
> I am the administrator to the database and the computer.
>
> would you please help me out?
>
> thanks
>
> sharon
>
| |
| Sharon 2005-06-23, 5:55 pm |
| thanks McGeeky.
yes, I did. It said: test connection succeeded.
"McGeeky" wrote:
> When you configured the SQL port, did you click the "Test Connection"
> button?
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "Sharon" <Sharon@discussions.microsoft.com> wrote in message
> news:0D754ADA-BDDB-4443-BE10-7079E3DD727F@microsoft.com...
> http://msdn.microsoft.com/library/d...-us/BTS_2004WP/
> html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp
>
>
>
|
|
|
|
|