Skip to Content
0

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Feb 10, 2017 at 12:02 PM

173

avatar image

Hi,

could anybody give me a step by step explanation how can I solve mentioned problem?

When I'm trying to run qery on default 4.2 universe ( monitoring TrendData Universe)datatrend.jpg . I get the following error error2.jpg

I have found an article in here, but I don't know how to do this.

datatrend.jpg (89.8 kB)
error2.jpg (151.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Feb 10, 2017 at 12:06 PM
0

check attached link and follow mentioned steps.

https://archive.sap.com/discussions/thread/3496124

Share
10 |10000 characters needed characters left characters exceeded
Amit Tewatia Feb 10, 2017 at 12:39 PM
0

Hi Lukasz,

As per the article, User DSN is used instead of System DSN which means only the User who created that DSN connection can use it. Follow below steps to resolve this.

1. Create System DSN specifying the same ODBC connection.

select driver as per your system

2.Change the connection in designer for the Universe to use new ODBC connection (system DSN)

3. save and export Universe

Regards,

Amit T


dsn.jpg (122.2 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
1. Create System DSN specifying the same ODBC connection.

Hi I guess that I do not have enough experience to do this. Simply can't configure it in an approprate way? Could you help me bit?

0

Hi Lukasz,

Please follow the steps mentioned in link below. This shall resolve your issue.

https://archive.sap.com/discussions/thread/3496124

Regards,

Amit T

0