RE: How to set connection options for BT adapter for SQL?
From: Shaheer Abubucker (shaheera_at_online.microsoft.com)
Date: 02/16/04
- Next message: Shaheer Abubucker: "RE: BizTalk messaging service account"
- Previous message: paul: "BizTalk messaging service account"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Feb 2004 22:19:13 GMT
Hello,
You need hotfix Q814661 (Cannot Use Parameters Greater than 128 Characters
in Length). The article is located at
http://support.microsoft.com/?id=814661. If you install this hotfix,
QUOTED_IDENTIFIER will be set to OFF.
You will need to open a support incident with Microsoft to obtain this
hotfix but you will not be charged for a hotfix request.
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/default.aspx?scid=/servicedesks/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:46:08 +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: <u8nOvXF5DHA.1596@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.biztalk.server
| NNTP-Posting-Host: msk1447.msk.internet2.ru 217.25.84.119
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.
phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.biztalk.server:8944
| X-Tomcat-NG: microsoft.public.biztalk.server
|
| 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'...
|
|
|
- Next message: Shaheer Abubucker: "RE: BizTalk messaging service account"
- Previous message: paul: "BizTalk messaging service account"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
