|
Home > Archive > BizTalk Server Applications Integration > May 2004 > Dynamically Assign 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 |
Dynamically Assign SQL Adapter Connection String?
|
|
|
| Hi,
Can the 2004 sql adapter's conn string be dynamically assigned based on a promoted property of the incoming message? I would like to use such a scalability option, if it exists, to route to individual client's' databases.
Thanks
| |
| Vipul Goyal [MS] 2004-05-11, 8:21 pm |
| Hi,
You can set the ...baseTypes.Address context property of the port.
DynamicSQLport(Microsoft.XLANGs.BaseTypes.Address) =
"SQL://DBServerName/DatabaseName/InstanceID" where InstanceID is anything
that you’d like in order for the URI to be unique;
The SQL Adapter does not support the full connection string as a context
property. However, you can set the SQL Send Handler properties as the
default values for dynamic sends.
You should be able to set the server name and database name at runtime and
have the remaining connection string properties retrieved from the Send
Handler Config. From the BTS Admin Console snap-in, expand the Adapters
node and in turn expand the SQL Adapter node. Click on the Send Handlers
folder and then right click on the desired host instance which appears in
the result pane. Select properties from the context menu, then select the
properties tab from the popup dialog. You should then be able to configure
default values for dynamic sends.
Thanks,
Vipul Goyal
Microsoft
This posting is provided "AS IS" with no warranties,and confers no rights.
| |
|
| Thank you Vipul, but I am not sure I understand. I did look into the BTS Admin SQL Adapter node, which allows me to configure default connection criteria for the adapter. I am not sure how this helps me, however. Essentially, I will be receiving EDI th
at has a Receiver ID. Based on that receiver ID, I want to route the message to a particular client's database. There could (hopefully) be hundreds of these clients, each with their own database on my server.
John
| |
| Vipul Goyal [MS] 2004-05-17, 11:41 am |
| Hi,
I think in your case it should be possible . What is possible is to change
the "ServerName" and the "DatabaseName" at run time but all the
other peices of the connection string will be used which are set in the
adapter properties( like windows Auth or specific user) for a dynamic
SQL port. What I meant is that there is no context property available
which can take the complete connection string at run time. But the
ServerName
and the database name can be set at run time.
Thanks,
Vipul Goyal
|
|
|
|
|