'40002-IM002 Data Source Name Not Found And No Default Driver Specified Database Connection Error number 1.' in Report Server

Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.

Issue

'40002 - IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Database connection error number 1. RDO Error #0 IM002: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Accounting system registration not found for system type: 0' occurs in Report Server when sending a report to the queue.


Resolution

The problem is that there is an ODBC connection setup that is pointed from the Report Server to the data server, but it does not have the same name as the ODBC used in Designer.


For example, when I log into FRx and go to Company | Information | System Specific tab, I see my Data Source Name is Reporter. On the Report Server the ODBC I have set up is called ReportServer. This will cause the error. To resolve it create an ODBC on the Report Server that is also called eEnterprise7.

This article was TechKnowledge Document ID:28820

TechKnowledge Content

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×