Symptom
When running reports to the queue, the following error occurs:
"The specified DSN contains an architecture mismatch between the Driver and Application statement: Open Connections Native Error: 0"
"The specified DSN contains an architecture mismatch between the Driver and Application statement: Open Connections Native Error: 0"
Cause
The ODBC connection was pointing to the default 64 bit system32 folder.
Resolution
Removed ODBC connection on 64 bit in admin tools and added ODBC connection to windows\syswow64.
Also check network service, anonymous user and queue user had full control in sharing and permissions folder to the Queue folder on reporting server.
Check queue user was not a part of the User group but is part of the Admin group. Remove anonymous/IUSR user from the User group if this user is in the Admin group.
- The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
- The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.
Also check network service, anonymous user and queue user had full control in sharing and permissions folder to the Queue folder on reporting server.
Check queue user was not a part of the User group but is part of the Admin group. Remove anonymous/IUSR user from the User group if this user is in the Admin group.
Article Type
Product Info
Product Line
Millennium
Product Module/Feature
Reporting
Product Version
2013.5
Database Engine
SQL Server 2008 R2
Ranking