Crystal Reports not showing all ODBC options?

Posted on 2012-09-07
Last Modified: 2012-09-13
Had been using Crystal Reports XI, but moved to a different server running Windows Server 2008 R2 and SQL Server 2008 R2 (64-bit).  Updated the database on the new server and everything looks fine; however, when I go into one of my Crystal Reports it asks me to connect to the database, I choose ODBC and even though I created a new ODBC connection to my updated database, I do not see it in the list of options?  I see the other ODBC connections listed there, but not the new one I just created?  I go back into ODBC and sure enough, it is right there?  What am I doing wrong, why can I not see my new ODBC connection in CR XI R2?  Thank you.
Question by:WJM
    LVL 100

    Expert Comment

    CR XI is strictly 32-bit.  Make sure you used the 32-bit ODBC when you created the connection.

    CR XI cannot use a connection created by the 64-bit tools.


    Author Comment

    Just to be clear. The original reports were created using Crystal Reports running on a 32 bit Win XP system with a 32 bit SQL server 2005 and a 32 bit SQL odbc driver. The new system is a 64 bit OS  with 64 bit server running SQL 2008 R2.

    Are you saying I need to install a 32 bit SQL driver on the 64 bit OS?  Thank you
    LVL 100

    Accepted Solution

    UNderstood.  CR XI can only use 32-bit database connections.

    •The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.


    Author Comment

    Absolutely brilliant, that was it, had no idea there was both a 64-bit AND 32-bit version of the ODBC program.  Once I added it into the 32-bit version Crystal Reports picked it up right away, thank you so much.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now