I have to assume that the SQL Client was installed on the BizTalk server since it requires access to SQL Server. Are you using SQL Native client?
My Database Lookup functoid looks like this:
- xpath statement created when I dragged a line from the input field.
- String Left Trim (or String Concatenate) that holds the "File Name=C:\…\…uld" statement
- USER_TYPE (Table name)
- USER_TYPE_ID (Column name)
The Value Extractor then looks like this:
- Database Lookup
- USER_TYPE_ID
Of course this just confirms that the ID value I have is in the table, a very simple example. One thing I wanted to be clear on is the fact that all these funcoid links are in the correct order. If you verify this, then it might me a good idea to grab any standard SQL patches from Microsoft Update. I'd make sure any SQL and SQLXML updates are present.