|
Home > Archive > BizTalk Server Applications Integration > May 2005 > SQL Adapter Connection String
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 Connection String
|
|
|
| Hi,
I am trying to set up the sQL adapter in BTS 2004 to do an insert using
dynamic SQL. I have identical tables in several client databases for
recording payments. The sproc that inserts into these tables retrieves the
proper database name to prepend to the execute string based on a field in the
incoming message. This "dynamic routing sproc" basically just passes the
input parameters' data to an insert sproc in the target database. Using the
actual target database insert sproc, I can generate a XSD for use with the
SQL Adapter. I can then change the name of the sproc to call so that I am
calling my dynamic routing sproc. How do I alter the DB connection string
the SQL Adapter will use at runtime? Thanks.
JT
--
John
| |
| WenJun Zhang[msft] 2005-05-06, 7:47 am |
| Hi John,
For dynamic SQL port, you can change its uri in your orchestraion:
Port_1(Microsoft.XLANGs.BaseTypes.Address) =
"SQL://servername/database/InstanceId"
Only some properties(parts of connection string) can be changed in
this way but there is no attribute of the full string.
Thanks.
Best regards,
WenJun Zhang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
|