cancel
Showing results for 
Search instead for 
Did you mean: 

Information Design Tool OLE DB Connection Switch to ODBC Connection

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member4998
Active Contributor
0 Kudos

Hi..Please check whether you have access for

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


Former Member
0 Kudos

Hi Screenivasulu,

I have access for both SQL server and Data Foundation. I noticed it happens only when the owner is not "dbo".....I am trying to understand if OLE DB and ODBC treat qualifier and owners differently?

Thanks,

Kan

former_member4998
Active Contributor
0 Kudos

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.