Skip to Content
0

Can't connect to a file DSN

Jan 10, 2017 at 06:44 PM

38

avatar image

When I try to set up and ODBC connection from Crystal reports 2016 by selecting a file DSN I created in MS Access 2016 I get the following error message:

Sap Crystal Reports Failed to open the connection. Details: IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

Both applications are 32bit. I have done this successfully before with earlier versions of both softwares.

Any direction on this would be appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vitaly Izmaylov
Jan 10, 2017 at 10:20 PM
0

According to Supported Platforms document MS Access 2016 is supported for ODBC connection only on SP 03 and higher. See below:

Make sure the version number of your CR 2016 designer is 14.2.3... or higher


Share
10 |10000 characters needed characters left characters exceeded
Michael Hardy Jan 12, 2017 at 11:12 PM
0

Thanks! That was very helpful. I was running SP 02 and installed SP 03 and 3 related patches to make it work.

Also had to install MS Access Data base engine 2010. Apparently Access 2016 package doesn't include an ODBC driver for itself.

Share
10 |10000 characters needed characters left characters exceeded