Data Service Designer issue

[former_member203809]

Hi,

From a Client Machine, using the data service designer tool I'm trying to access the local repository the below error pop-ups.

The ODBC connection is dynamic and test connection is success.

DS Version : 4.1 SP 2

Database : Microsoft SQL 2008

In server, I'm able to access the data service designer tool and the repository. However, on outside local machine its not working. Please assist me on this.

Thank you.

[Former Member]

I think I sow this case in a pl sql tutorial. Sry but don't remember the solution but it was mantioned there.

[former_member189153]

Hi Vijay,

This is related to ODBC Call issue from client machine, Follow the below steps to fix this issue.

1. Go to Control Panel->Administrative Tools->Data Sources (ODBC)

2. Create a DNS for your Database and then try.

Regards

M Ramesh

[former_member203809]

Hi Ramesh,

I've already established that.

[former_member189153]

hi,

Hope it works fine. if yes, Please close the thread.

[former_member205887]

Did you check if you are able to connect to this repository database from Sql Server Management studio ?

[former_member203809]

Yes, I'm able to do that.

[Former Member]

Looking at the screenshot you are able to login to BODS and unable to login to the local repository. search the sap notes, there may be sql server DLL files that you need to put in some of the folders. I've had similar connection problems but its been a while. the BODS designer doesn't have files necessary to connect to the BODS Local repository on SQL server.

Thanks,

Ashok

Search is our friend.