IM002:[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified

[Adam_Alsop]

Hello all!

I am using SAP CR v14.09.1345 RTM Developer (yes, I know sadly it is 2011), but I believe I should be able to use XLSX (O365 Excel) files as data sources with the 64-bit ODBC driver.  I have configured the FILE DNS, however, when I try to use them, I am prompted for a login (username/pwd) and if not provided, I receive the above error.

Is there no way to use XLSX files with this version of CR?

Thanks!

--- Adam

[DonWilliams]

First issue is CR 2011 is 32 bit so you won't be able to connect to a 64 bit data source.

Second problem is the Repository is to connect to BO Enterprise's repository, where reports and other objects are saved.

So expand the ODBC connection and the DSN must be created using the 32 bit ODBC Admin tool.