|
Home > Archive > BizTalk Server General > July 2005 > BT 2004 database functoid 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 |
BT 2004 database functoid question
|
|
|
| I am curious as to what environment the database lookup functoid is based on.
Documentation states that it's based on ADO. Is that to be assumed as
ado.net, or the older ado? If memory serves me correct, ado.net connections
can come in two flavors - SQL server and OLEDB.
Bottom line is this: I have a connection string that looks at ODBC, and I'm
curious if I'm able to do this through the BT2004 functoid or if I need to
create a database functoid (or custom script) myself.
Thanks,
| |
| Jeff Lynch 2005-05-17, 5:50 pm |
| If you look at the xslt output created by the BTS2004 mapper you can see how
the database functoids work. The BTS2004 documentation (help file) also
explains this pretty well. You can also look at the C# code written by
VS.NET and see exactly what happens in the map. It uses the standard .NET
XML classes and the SQL OLEDB provider.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"BT" <BT@discussions.microsoft.com> wrote in message
news:B7B0BB57-00F0-4734-A39F-A98AB7C83C71@microsoft.com...
>I am curious as to what environment the database lookup functoid is based
>on.
> Documentation states that it's based on ADO. Is that to be assumed as
> ado.net, or the older ado? If memory serves me correct, ado.net
> connections
> can come in two flavors - SQL server and OLEDB.
>
> Bottom line is this: I have a connection string that looks at ODBC, and
> I'm
> curious if I'm able to do this through the BT2004 functoid or if I need to
> create a database functoid (or custom script) myself.
>
> Thanks,
| |
| Daniel 2005-07-22, 5:50 pm |
| Jeff, do you have any example about Custom DataBase Functoid ?
"Jeff Lynch" wrote:
> If you look at the xslt output created by the BTS2004 mapper you can see how
> the database functoids work. The BTS2004 documentation (help file) also
> explains this pretty well. You can also look at the C# code written by
> VS.NET and see exactly what happens in the map. It uses the standard .NET
> XML classes and the SQL OLEDB provider.
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://codebetter.com/blogs/jeff.lynch
>
>
> "BT" <BT@discussions.microsoft.com> wrote in message
> news:B7B0BB57-00F0-4734-A39F-A98AB7C83C71@microsoft.com...
>
>
>
| |
| Jeff Lynch 2005-07-22, 5:50 pm |
| I sure don't! I've been able to get by using the standard database functoids
without any problems.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"Daniel" <Daniel@discussions.microsoft.com> wrote in message
news:13BE6747-3A05-4D44-988A-8D05CEAAC52B@microsoft.com...[vbcol=seagreen]
> Jeff, do you have any example about Custom DataBase Functoid ?
>
> "Jeff Lynch" wrote:
>
|
|
|
|
|