Hello,

We found the mapper of limited use for mapping complex scenario's and
decided to write the stylesheet by hand.
This works fine, but now we need to connect to a database.

By default, the following namespaces are supported in the msxsl:script tag:
System  System classes.
System.Collection  Collection classes.
System.Text  Text handling classes.
System.Xml  Core XML classes.
System.Xml.Xsl  XSLT classes.
System.Xml.XPath


But when connecting to a SQL DB, the System.Data namespace is needed.

Obviously, we added a reference to this namepace at project level, but we
keep
getting an error when testing the map, stating that the Data, Reader,Command
etc...could
not be found.

Any suggestions would be gretaly appreciated,
Philippe

[ Post a follow-up to this message ]

You need to do what a linked functoid does - not what the inline functoids
do. You need to create a namespace that calls a .NET method and then call
the method, and give the mapper a CustomExtension Object xml file.

Add the Database Lookup functoid to a map - view the XSLT you should get the
idea.

--
Jon Flanders [DevelopMentor]
http://staff.develop.com/jfland/
http://www.develop.com/courses/biztalk
"Philippe Van der Stighelen" <jobs@genuine.be> wrote in message
news:%23vnQ3G6EFHA.3120@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> We found the mapper of limited use for mapping complex scenario's and
> decided to write the stylesheet by hand.
> This works fine, but now we need to connect to a database.
>
> By default, the following namespaces are supported in the msxsl:script
> tag:
>      System  System classes.
>      System.Collection  Collection classes.
>      System.Text  Text handling classes.
>      System.Xml  Core XML classes.
>      System.Xml.Xsl  XSLT classes.
>      System.Xml.XPath
>
>
> But when connecting to a SQL DB, the System.Data namespace is needed.
>
> Obviously, we added a reference to this namepace at project level, but we
> keep
> getting an error when testing the map, stating that the Data,
> Reader,Command
> etc...could
> not be found.
>
> Any suggestions would be gretaly appreciated,
> Philippe
>
>

[ Post a follow-up to this message ]