on 03-26-2020 6:21 AM
Hi
I have a relational connection at IDT which uses MS SQL Server 2016 OLEDB driver and I have the driver installed at both my client machine as well as BO server.
I don't see any problem while creating single source universe on top of this connection in IDT but when I choose to create Multi Source Universe at data foundation layer, I could see the below error which stops me to proceed further.
"The network layer OLEDB and database MS SQL Server 2016 is not a valid supported connectivity"
Any thoughts to help me out on this please?
(Screenshot attached)
Thanks
Shankar
There are changes to the OLE DB support. For 2016 Sql Server it is not certified for 4.2 sp7. However, you can probably use the same driver, but when creating a connection, select Sql Server 2014. in Bi 4.2 SP8 the ole driver must be updated for support. check the PAM for your version here: https://apps.support.sap.com/sap(bD1lbiZjPTAwMQ==)/support/pam/pam.html?smpsrv=https%3a%2f%2fwebsmp2...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.