• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1121
  • Last Modified:

Crystal Reports not showing all ODBC options?

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.
0
WJM
Asked:
WJM
  • 2
  • 2
1 Solution
 
mlmccCommented:
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.

mlmcc
0
 
WJMAuthor Commented:
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
0
 
mlmccCommented:
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.

http://support.microsoft.com/kb/942976

mlmcc
0
 
WJMAuthor Commented:
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.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now