BizTalk Server General - DB functoid MDAC problem

Author

DB functoid MDAC problem

2006-03-25, 11:37 am

I'm running BizTalk 2006, with SQL 2005 on XP SP2. In a simple map I'm trying to use the Database Lookup functoid on a SQL table but the system is giving me the following error...

The .Net Framework OleDb Data Provider requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 0.0.0.0 was found currently installed.

However, if I run Microsoft's compchecker utility it reports "the following product releases were matched: MDAC 2.8 SP1 on Windows XP SP2".

Where does the functoid look to get it's version information ? (maybe there's an incorrect registry setting somewhere?? )

Any ideas?

Richard