“Datasource not found… error 80040154″ When Setting Up Customer Databases in Ideagen Smartforms Server

  Who is this article for?  

  Ideagen Smartforms users configuring versions older than 10.1.

  Understanding of Windows server is required.

When configuring a new customer with Ideagen Smartforms Server and clicking “Test Datasource, the following error appears:

“Datasource not found.: Retrieving the COM class factory for component with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} failed due to the following error: 80040154.”

Problem

The library file “sqldmo.dll” was not registered during Ideagen Smartforms Server Installation. The file “sqldmo.dll” provides a library for interacting with SQL Server. If Ideagen Smartforms Server was installed on a machine with SQL Server installed, the Ideagen Smartforms Server installation should install and register “sqldmo.dll”.

Solution

Use regsvr32 to register “sqldmo.dll”, by default located in “c:\inetpub\wwwroot\MFS\bin\”.