BizTalk Server Applications Integration - BizTalk Adapter for SQL generates SQL-queries with double quotes

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > February 2004 > BizTalk Adapter for SQL generates SQL-queries with double quotes





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 BizTalk Adapter for SQL generates SQL-queries with double quotes
Semenov RS

2004-02-08, 8:41 am

How to configure AIC SQLPipeline Class properties to force it to use a
single quotes for string data type
(or maybe to set QUOTED_IDENTIFIER option to OFF value)?

The query in SQL Profiler is like that:
Audit Login
-- network protocol: TCP/IP
set quoted_identifier on

SQL:BatchCompleted EXEC BalState_Add @system="BBMS", @debit_credit="DB",
@unique_id="5189314", @doc_type="1", @dat_pp="2002-10-01",
@value_date="2002-10-01", @nom_pp="45"

As you can see, first AIC SQLPipeline sends command SET QUOTED_IDENTIFIER
ON and than, uses double quotes for strings.


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com