Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ODBC Error while connecting to a Local repository from Data Services Designer

Hi,

I just did a fresh install of Data Services SP3 on windows server 2008 with repository database of MS SQL Server 2008 R2.

After the installation I configured the Job server and added 2 local job server and 1 central job server from Data Services server manager and created two repository in CMC. After successfully establishing connection from CMC when I logged into the data sevices management console it says no repository found.

So I even restarted the SIA and still the problem exists.

While connecting from Data Services designer I can see both the repositories but while connecting to repository it fails to connect. It says a error mesage

ODBC Call to the Data Source Failed. Notify the customer Support (BODI-1112172).

I checked the notes and found KB 1514119

It says Resolution

Install the Microsoft SQL Server 2008 Native client on the machine where the DS or IS Job Server.

However there has been the native client SQL Server 2008 R2 already installed. So I uninstalled the client and reinstalled it. Still the same error exists.

Please suggest what can be the next steps to try. Attached the error message.

Tags:
Former Member
Former Member replied

The Version is BODS 4.0 SP3. I have followed all the steps you mentioned but still the issue exists.

I created a new database using a new mySQL instance and then created the repository on top of it.It now works.Still don't know what was wrong originally.

Resolving the thread.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question