Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 22, 2016 at 04:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 04:42 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 22, 2016 at 05:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Dec 22, 2016 at 06:26 PM

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

    Add comment
    10|10000 characters needed characters exceeded