Using Crystal, it works beautifully (THANK YOU!!).
However, when I try to get SSRS (2012r2) to create an ODBC datasource,
- I can can pick the same DSN that works in Crystal, hit test in that (ODBC) window and it succeeds,
- but then when I OK and go back to the datasource window and test, it fails:
** However, the first time, I only tested the first and thought all was well, so I went and created a query.ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- and if I hit Run inside the Query designer window, it returns data!
- But when I then go to actually run the report, it fails.
Any ideas?Cannot create a connection to datasource