Hi,
Can the 2004 sql adapter's conn string be dynamically assigned based on a pr
omoted property of the incoming message?  I would like to use such a scalabi
lity option, if it exists, to route to individual client's' databases.
Thanks

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]

Thank you Vipul, but I am not sure I understand.  I did look into the BTS Ad
min SQL Adapter node, which allows me to configure default connection criter
ia 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 messag
e to a particular client's database.  There could (hopefully) be hundreds of
 these clients, each with their own database on my server.
John

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]