Skip to Content

SAP Design Studio 1.6 - data source name not found and no default driver specified

Jan 31 at 12:00 AM


avatar image


I'm trying to achieve a task that is to create a application/dashboard using Design Studio 1.6 fetching data through a UNX Universe. My BI version is BI 4.1 SP6 running on windows 2008 server. I have installed the SAP Design Studio BIP addon on the BI server. The Design Studio client is installed on another machine which has no connectivity issues to the BI server. I ran rich client and was able to generate a report but Design Studio is throwing out following errors when accessing the same efashion universe. Im not able to understand what is it that Im doing in correctly. I already created a odbc 32 bit driver to establish connection between the client machine and the BI server. I have mentioned the UNC path in the ODBC Connection and Universe Designer, rich client, Information Design Tool are working fine fetching data locally. So does Design Studio use 64 bit ODBC connections? or is there something else that I'm missing?

This error message is displayed when I select objects from "Edit Query Specification"

Then the second error message displayed is after selection of an object from the universe and when I hit refresh to see the data.

Any help resolving this is much appreciated, thanks



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arijit Das Jan 31 at 06:36 AM

A 64 bit client tool uses 64 bit ODBC. Did you check creating the data source in 64bit ODBC in your local system ?

10 |10000 characters needed characters left characters exceeded
Samique Tanweer Feb 03 at 06:03 AM

Hi Arijit,

Thanks for your reply, I created a 64 bit odbc connection in my local system. Since this connection is to connect to Access database file (efashion.mdb) therefore I first had to install "AccessDatabaseEngine_X64" after that I was able to create a 64 bit ODBC connection. I named the new odbc connection on my local machine as the same name as the 32 bit odbc connection but that didnt help becuase in IDT I cant use the 64 bit odbc connection.

Even if I create a 64bit odbc connection, the Information Design Tool is a 32 bit tool so it will work with the 32bit ODBC connection. So I'm now wondering how would a 64bit odbc connection work with the Design Studio at all becuase I need Design Studio to connect to the UNX universe but the universe only uses 32 bit odbc driver not 64 bit odbc driver?


Show 3 Share
10 |10000 characters needed characters left characters exceeded

Funny thing is I am able to create a query in design studio on Island Resort Marketing universe(unx) which is also using 32 bit odbc drivers/connection. However with efashion universe(unx) which also uses 32 bit odbc connection, Im not able to create a query in design studio!!!

Samique Tanweer

Probably this blog will help you understand how a unx universe uses 64 bit connection once published in BI Platform.


Thanks for sharing this!