Skip to Content

Getting error, while creating 64 bit connection in IDT

Hi,

I can create 64 bit odbc for SQLServer database and cannot create universe in IDT. While creating 64 bit odbc connection, I am getting the error message below:

[Microsoft ODBC Driver Manager] The specified DSN Contains an architecture mismatch between the Driver and Application

ODBC and IDT on the same machine.

Thanks,

Jyothi

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2016 at 06:07 AM

    Hi Jyoti,

    The above error occurs when you create a 64-bit ODBC DSN on a system, and try to connect to this DSN from IDT. Now IDT being a 32-bit application cannot connect to the 64 bit DSN. Hence the architecture mismatch error is displayed by IDT.

    On your local system you will need to create a 32 bit DSN of the same name. For creating the 32 bit DSN open the 32-bit ODBC data source administrator from the following location (on a 64-bit Windows system): C:\Windows\SysWOW64. Here you'll find odbcad32.exe file. Here you need to create a DSN of the same name.

    Hope this helps.

    Regards,

    Niraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 07:45 AM

    Hi Jyothi,

    All BO Client Tools are 32-bit, so UDT and IDT and Webi Rich Client will only use 32-bit drivers and 32-bit DSN's

    You can create both 32-bit and 64-bit DSN on the same machine if you have multiple applications which require either 32-bit or 64-bit drivers.

    Hope it Helps!

    Regards,

    Adil

    Add a comment
    10|10000 characters needed characters exceeded

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.