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,

[ Post a follow-up to this message ]

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,

[ Post a follow-up to this message ]

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 h
ow
> 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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]