cancel
Showing results for 
Search instead for 
Did you mean: 

failed to open the connection, Detail: IM002 [Microsoft] [ODBC Driver Manager]

Neuton
Newcomer

Accepted Solutions (0)

Answers (2)

Answers (2)

DonWilliams
Active Contributor
0 Kudos

Crystal Reports does not install DB Clients except the DataDirect one but you still need to create the DSN's.

So the error suggests you did not create a DSN, see the other post for possible solutions or contact Mongo support for assistance.

0 Kudos

Crystal Reports 2025 crashing after selecting the Atlas Mongo Data ODBC source could be due to compatibility issues or incorrect configuration. Here are some potential solutions:

- *Check ODBC Driver Version*: Ensure you're using the correct version (32-bit or 64-bit) of the MongoDB ODBC driver that matches your Crystal Reports installation. You can determine whether your version of Crystal Reports is 32-bit or 64-bit and download the corresponding ODBC driver.
- *Update ODBC Driver*: Try updating the MongoDB ODBC driver to the latest version, as updates often resolve compatibility issues.
- *Configure Access Mode*: Modify the registry settings for Crystal Reports to adjust the ODBC access mode¹:
- *Registry Path*: HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database
- *Create ODBC Key*: Right-click "Database" > New > Key > name it "ODBC"
- *Create AccessMode Value*: Right-click "ODBC" > New > DWORD value > name it "AccessMode" with a value of 0

- *Alternative Solutions*:
- *Use JDBC Driver*: Consider using a JDBC driver for MongoDB, which can be used with Crystal Reports. This involves adding the JAR file to the ClassPath and restarting Crystal Reports.
- *Check Bitness Compatibility*: Ensure the bitness of the Crystal Reports installation and SQL client access installation are the same.²
- *SAP Support*: If none of these solutions work, reach out to SAP support for further assistance, as they may be able to provid

e more specific guidance or patches.³

The error message points to an issue with the `atsql.dll` module, which is part of the MongoDB ODBC driver, suggesting the problem lies with the driver or its interaction with Crystal Reports.⁴