Skip to Content
author's profile photo Former Member
Former Member

DBD: Error while trying to load the transport provider for odbc. Failed to load the library. System error: The specified module could not be found.

Hello Everyone,

We are getting an error while trying to create an Universe via Microsoft -> MS Analysis Services 2014 -> OLEDB for OLAP Provider under Connection in UDT -"DBD: Error while trying to load the transport provider for odbc. Failed to load the library. System error: The specified module could not be found." We have installed BI 4.1 SP05 in our system. As per earlier posts in scn in BO XI 3.x this issue used to be for improper installation of Integration KIT but in our scenarion Integration KIT is within the BO 4.1 package so no seperate installation is required. Moreover I have checked whether all the driver is present under file: "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers" and seems everything is fine. But still I am getting this error. One important point is we could use IDT because in IDT still we don't have option to connect with 'Microsoft Analysis Services - 2014 (XMLA)' as we are using Microsoft Analysis Services 2014 version.

Kindly help if anyone has faced the same problem with SAP BO 4.1.

Thanks and Best Regards,

Ghosal

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 16, 2015 at 12:12 PM

    Hello,

    looks like the classis "middleware missing" failure. Did you installed the MS SQL Native Client 12.0 in 32 Bit on the Machine where the UDT is running?!

    Regards

    -Seb.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 17, 2015 at 12:32 PM

    Hello Everybody,

    The problem is solved now after installing "OLEDB drivers from SQL Server 2012 Feature Pack". We had OLEDB drivers that comes directly from SQL Server but that did not worked out in our case.

    Thanks for your support.

    Best Regards,

    Ghosal

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.