Skip to Content
0

Universal connection with excel in design studio

Mar 27 at 10:38 AM

47

avatar image
Former Member

hi

I created a universal connection using odbc and publish this to BO server. When I use this universal connection in the design studio and press edit query specification I get this error

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

Design studio version: Release 1.6 SP5 Patch 3 (Version: 16.5.4)

10 |10000 characters needed characters left characters exceeded

Which version/SP of the BI platform are you using?

0

Hello Ali,

Have you created a 32-bit ODBC or 64-bit ODBC?

Thanks,

Chandrasekhar

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Mar 27 at 10:41 AM
0

did you create the same ODBC setup at BO server level?

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Yes, I placed the excel file on my BO server using the remote desktop and created the setup of odbc 32 bit driver with

the path to that excel file on BO server. when I try to create a relational connection directly in the repository resource in

IDT and choose odbc driver from generic it doesn't show my data source name in the dropdown list.

0

try with creating ODBC 64 bit also and see.

0
Former Member

I have 32bit os at BO server so i can only use 32 bit odbc. what i need to do now

0

BO 4.x only supports 64bit server OS. I don't think you can run design studio with BOXI3.1 or older releases.

0
avatar image
Former Member Mar 29 at 12:01 PM
0

can you please describe the steps of making ODBC setup at the BO server level

Share
10 |10000 characters needed characters left characters exceeded