Skip to Content

Universal connection with excel in design studio

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 27, 2018 at 10:41 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2018 at 12:01 PM

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

    Add comment
    10|10000 characters needed characters exceeded