CaliberRM 2008SP1 Datamart extraction to SQL Server fails after upgrading to latest patch
When running datamart in the command prompt you receive the following error:
FATAL ERROR: Cannot open connection with SQL server, connection string.
COM error code:800a0e7a
Description:Unknown error 0X800A0E7A
Description: Provider cannot be found. It may not be properly installed
Resolution is to use the SQL native client dll in ODBC:
The new datamart extractors use the SQL native client driver, this message appears if the user doesn’t have the native client SQL driver and dlls installed. The ODBC is liekly to be pointing to the older SQLsrv32.dll instead of the new SQLNCL10.dll.
You can download SQL Server 2008 Native Client here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
You can download SQL Server 2005 Native Client from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en