We have a problem with Universes on SQL Server.
Previously we had BI 4.0 Platform on Windows, there were no problems with creation universes using SQL Server.
Recently we moved BI 4.0 Platform to Linux.
When we try to create a report using existing universes, which were moved from windows system using LCM, Webi shows this message:
Database error: (CS) "DBDriver failed to load : /home/bobj/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64/libdbd_mssql.so (libodbc.so: cannot open shared object file: No such file or directory)" . (IES 10901) (WIS 10901)
I conducted some research on that and found out that is ODBC driver problem on Linux. But information how to resolve it varies from one source to another.
I don't want to mess up system, that's why asking how to resolve this problem properly.
Our system BI Platform 4.0 SP5 with patch 5. Client tools also SP5 with patch 5.
Any help and suggestions will be appreciated.