Skip to Content
avatar image
Former Member

Information Design Tool OLE DB Connection Switch to ODBC Connection

Hi,

Our universes were using OLE DB connection to SQL Server 2008 but having dead lock issues, so we decided to switch to ODBC connection.

I edit the existing connection to use ODBC drivers. Check the integrity in business layer and it is working great. But under data foundation, when I right click--> Change Qualifier/Owners. I got the following message:

"No owner in the database exactly matches '(owner name)'

Make sure that your database accepts the owner and/qualifier that you entered.

Do you wish to proceed anyway with your changes? "

I am not sure what exactly it means, since the business layer works fine, is there additional changes I have to make under data foundation?

Thanks in advance for any suggestions!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 17, 2014 at 12:16 PM

    Hi..Please check whether you have access for

    • SQL server
    • selected tables or views in the Data Foundation


    Add comment
    10|10000 characters needed characters exceeded

    • HI

      We have encountered issue when applying OLEDB, we have created OSS message was created to get resolved and meanwhile we set up and ODBC connection to continue our universe and report activities  and a switch to OLEDB will be made once all the issues are resloved.