Skip to Content
0

CR 2013 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Dec 22, 2016 at 04:22 PM

86

avatar image

When I try to use a Universe in CR for Enterprise 2013 I receive the following error:

I am connecting to a oracle database and have a 32 user DSN for the data source. I do not have a microsoft dsn set up as I am not connecting to a microsoft database

I am able to view raw data for the universe in the information design tool.

I don't know what I am missing.

Thank you

dwolm.png (47.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vitaly Izmaylov
Dec 22, 2016 at 04:38 PM
0

Do you have a 64 bit Oracle Client installed on the same Server? Usually it is required for Webi reports, so many users have both 32 and 64 bits. If you have then I would suggest to create a 64 bit DSN with exactly the same name and then test again.

Share
10 |10000 characters needed characters left characters exceeded
D Winkelman Dec 22, 2016 at 04:42 PM
0

unfortunately we only have the 32 bit client installed on the server

Share
10 |10000 characters needed characters left characters exceeded
Dell Stinnett-Christy Dec 22, 2016 at 05:25 PM
0

Unlike the "classic" Crystal functionality on the BI Platform, Crystal for Enterprise processing is 64-bit. So, you have to have the 64-bit client installed on the server and you have to have a 64-bit ODBC connection created for it. You need the 32-bit client wherever you are developing the reports in Crystal for Enterprise, but the 64-bit version to run them on the platform.

Also, from MUCH experience (@20 years...), I HIGHLY RECOMMEND that you use the native Oracle driver for Crystal instead of ODBC - it's much more stable and efficient.

-Dell

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Also, you have to use a universe that was created in the IDT (.unx). Old-style .unv universes won't work with Crystal for Enterprise.

-Dell

0

can I just have the 64 bit client installed in the server that already has the 32 bit client?

0

Yes. I have done that for several of my clients. As has been mentioned above, you'll also need to create a 64-bit ODBC System DSN (it should have the same name as the 32-bit DSN) on the the server after you install the 64-bit client.

-Dell

0
Vitaly Izmaylov
Dec 22, 2016 at 06:26 PM
0

Yes, you can install 64 bit client side by side with 32 bit client.

Share
10 |10000 characters needed characters left characters exceeded