|
Home > Archive > BizTalk Server General > February 2004 > How to set connection options for BT adapter for SQL?
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 |
How to set connection options for BT adapter for SQL?
|
|
| Semenov RS 2004-02-08, 8:38 am |
| Who knows why adapter (AIC SQLPipeline) generates SQL for stored proc
invocation with double quotes, like this:
EXEC BalState_Add @payer_bank="bank "bank name" in city, city",
@payer="payer "payer name"", .....
If i could set the SET QUOTED_IDENTIFIER to OFF it will work fine or on
another hand, perhaps exists the AIC's configuration option wich tells it to
generate SQL queries with ANSI strings like 'string bla-bla-bla'...
| |
| Shaheer Abubucker 2004-02-08, 8:38 am |
| Hello,
You will need to get the hotfix found at
http://support.microsoft.com/?id=814661.
The hotfix description says it is for using parameters greater than 128
characters in length but also sets QUOTED_IDENTIFIER to off.
You will need to open a support incident for this, but Microsoft does not
charge you just to get a hotfix.
Thanks,
Shaheer Abubucker
Microsoft Biztalk Server Team
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| From: "Semenov RS" <romull@mail.ru>
| Subject: How to set connection options for BT adapter for SQL?
| Date: Tue, 27 Jan 2004 00:45:32 +0300
| Lines: 10
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <eoztbXF5DHA.2136@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.biztalk.general
| NNTP-Posting-Host: msk1447.msk.internet2.ru 217.25.84.119
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.
phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.biztalk.general:12540
| X-Tomcat-NG: microsoft.public.biztalk.general
|
| Who knows why adapter (AIC SQLPipeline) generates SQL for stored proc
| invocation with double quotes, like this:
| EXEC BalState_Add @payer_bank="bank "bank name" in city, city",
| @payer="payer "payer name"", .....
|
| If i could set the SET QUOTED_IDENTIFIER to OFF it will work fine or on
| another hand, perhaps exists the AIC's configuration option wich tells it
to
| generate SQL queries with ANSI strings like 'string bla-bla-bla'...
|
|
|
|
|
|
|
|