Avatar of mumblesnz
mumblesnz
Flag for Australia asked on

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

I receive this error when I connect the Report Builder3.0 to my reporting sever manager.
Report runs fine until i make the connection. Same occurs if I run the report from the report manager.

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
----------------------------
Cannot create a connection to data source 'dsDataSource1'. (rsErrorOpeningConnection)
----------------------------
An error has occurred during report processing. (rsProcessingAborted)

I expect this is due to either the 64bit server OS or the SQLServer standard version I have installed?
SSRSDB Reporting ToolsMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
David Todd

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
David Todd

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mumblesnz

ASKER
Yes i am. found the isse and have to generate a 64bit driver for the odbc. Thanks.
David Todd

Hi,

If my answer is 100% correct and on the money, why only a B grade? You didn't supply me with enough other information as to expand much more beyond that.

Regards
  David
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck