Skip to Content
author's profile photo Former Member
Former Member

Change connection from OLE DB to ODBC

Information Design Tool 4.1


Version: 4.1 Support Pack 5 Patch 10

Change connection from OLE DB to ODBC

I need to change my db connection to ODBC in order to use the feature Multi subnet fail over

Relevant dsn’s have been created on both the app server and the machine I’m working from and connect without issue.

I am able to edit the connection, apply the change to ODBC. Test successfully and save.

The issue arises when I view through the data foundation. Expanding the connection supplies the following error:

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

Similar issue occurs If I try to show tables values

To note:

In order to test further I created a new project, connection and data foundation attaching to the required DB using OBDC. I’m able to create a new data foundation and when expanding the DB connection am presented with the standard view of schemas and table. I can select those, bring into to the DF and view table values etc

Is there a parameter I can assign to the ole db connection to allow Multi subnet fail over?

Is there another way I can change the connection from ole db to odbc ?

Any help is much appreciated



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 21, 2016 at 12:18 PM

    After changing the connection drivers have you recreated the connection shortcut in the project folder?

    If you will do the connection short cut it will ask to overwrite the connection.Overwrite the connection and try.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Amit,

      I’d tried that, but the same issue occurred. In the end I reimported the universe and connection in order to start afresh, edited the connection and followed your steps. Behaviour works as expected and the DB can be queried

      Many thanks


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.