|
Home > Archive > BizTalk Server General > December 2004 > sql adapter question
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 question
|
|
| Tim B. 2004-11-30, 5:49 pm |
| Just getting started with using the sql adapter and have 2 questions. thanks.
1. Since the wizard (add adpater) creates a new orcestration every time you
run it  Is there a way to move the port types from one orchestration
to another ?? I can't see why one would want a seperate orchestration every
time ? Is there a reason that it works this way ?
2. Is there a way to dynamically configure the database conection string ?
We like to use dynamic ports and config files, where possible, to accomodate
moving code from test -> QA and PROD. URLs and db connection strings are
easily manged in the config files without having to worry about using any gui
tool or deployment script to manuaolly set up properties on each biztalk
server.
any ideas ?
Tim
| |
| Darrin Curtis [MSFT] 2004-12-01, 5:51 pm |
| Tim,
For issue 1, you can look at
http://www.msdn.microsoft.com/libra...y/en-us/operati
ons/htm/ebiz_prog_adapt_jqsl.asp for instructions on how to combine the
output from different runs on the Schema Wizard. A new orchestration is
created by default to avoid possible naming collisions.
For issue 2, SQL Adapter does support dynamic send, but you are only able
to change the address (that is the server and database you are connection
to). The table or SP the port is configured to use would need to be present
in the database you connect to and the credentials the Adapter use are the
'Send Handler' credentials setup through the MMC.
HTH
Thanks
Darrin
--------------------[vbcol=seagreen]
thanks.[vbcol=seagreen]
you[vbcol=seagreen]
orchestration[vbcol=seagreen]
every[vbcol=seagreen]
?[vbcol=seagreen]
accomodate[vbcol=seagreen]
gui[vbcol=seagreen]
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
| |
| Tim B. 2004-12-01, 5:51 pm |
| ,Darrin,
Thanks the link for the first question is clear.
on the second - I think thats a yes ?
(what I'd like to change dynamically isn't the sql, its the connection info
- the server name in particular.)
if so, how can I access the "address" and change it
is it something similiar to the way a dynamic smtp port can be changed --
EmailPort(Microsoft.XLANGs.BaseTypes.Address) == "Mailto:???"
"Darrin Curtis [MSFT]" wrote:
> Tim,
>
> For issue 1, you can look at
> http://www.msdn.microsoft.com/libra...y/en-us/operati
> ons/htm/ebiz_prog_adapt_jqsl.asp for instructions on how to combine the
> output from different runs on the Schema Wizard. A new orchestration is
> created by default to avoid possible naming collisions.
>
> For issue 2, SQL Adapter does support dynamic send, but you are only able
> to change the address (that is the server and database you are connection
> to). The table or SP the port is configured to use would need to be present
> in the database you connect to and the credentials the Adapter use are the
> 'Send Handler' credentials setup through the MMC.
>
> HTH
>
> Thanks
> Darrin
> --------------------
> thanks.
> you
> orchestration
> every
> ?
> accomodate
> gui
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>
| |
| Darrin Curtis [MSFT] 2004-12-01, 5:51 pm |
| Tim,
Yes, you change the address property like you show below, but use use the
SQL format specifying the SQL Server and database.
Thanks,
Darrin
--------------------[vbcol=seagreen]
<5afuOx91EHA.3200@cpmsftngxa10.phx.gbl>[vbcol=seagreen]
info[vbcol=seagreen]
http://www.msdn.microsoft.com/libra...y/en-us/operati[vbcol=seagreen]
able[vbcol=seagreen]
connection[vbcol=seagreen]
present[vbcol=seagreen]
the[vbcol=seagreen]
questions.[vbcol=seagreen]
time[vbcol=seagreen]
string[vbcol=seagreen]
are[vbcol=seagreen]
any[vbcol=seagreen]
biztalk[vbcol=seagreen]
rights.[vbcol=seagreen]
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
|
|
|
|
|