Problem
An error occurs when you use web client to extract content from documents to which 3D models .zvf and .mdb2 files are attached. The software displays the following error:
Unable to connect Access database with provided OleDB Provider
at SPF.Common.SPFException..ctor(Int32 pintClientNumber, Int32 pintServerNumber, String[] pstrParameters, Exception& pobjInnerException) in F:\A1\5\s\SPF\Common Projects\Common\SPF\Common\SPFException.vb:line 31
at SPF.Common.SPFException..ctor(Int32 pintClientNumber, Int32 pintServerNumber) in F:\A1\5\s\SPF\Common Projects\Common\SPF\Common\SPFException.vb:line 15
at Intergraph.SPFN.Common.PreProcessor.Classes.Fusion3DReaderHelperClass.ReadCategoryFromMDB(String pstrMDBFilePath, String pstrConnectionString) in F:\A1\5\s\SPF\Common Projects\Intergraph.SPFN.Common\PreProcessor\3D PreProcessor\Fusion3DReaderHelperClass.vb:line 406
at Intergraph.SPFN.Common.PreProcessor.Classes.Fusion3DReaderHelperClass.ReadDataFromMDB(String pstrMDBFilePath, String pstrConnectionString) in F:\A1\5\s\SPF\Common Projects\Intergraph.SPFN.Common\PreProcessor\3D PreProcessor\Fusion3DReaderHelperClass.vb:line 216
at Intergraph.SPFN.Common.PreProcessor.Classes.Fusion3DReaderHelperClass.GenerateXmlContentFile(String pstrFilePath) in F:\A1\5\s\SPF\Common Projects\Intergraph.SPFN.Common\PreProcessor\3D PreProcessor\Fusion3DReaderHelperClass.vb:line 130
Content files generation failed
Solution
The error occurs because Microsoft.ACE.OLEDB.Provider.12.0 provider fails to connect to the Microsoft Access database engine installed on the SmartPlant Foundation application server. In order to avoid this error, we recommend you to:
-
Install Microsoft Access database engine 2010 (64-bit) instead of (32-bit) version on the SmartPlant Foundation application server.