Print Page | Close Window

CR2011 ODBC Shows No Databases - FIXED!

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15898
Printed Date: 28 Apr 2024 at 6:58pm


Topic: CR2011 ODBC Shows No Databases - FIXED!
Posted By: bainsteven
Subject: CR2011 ODBC Shows No Databases - FIXED!
Date Posted: 16 Mar 2012 at 12:08am
Hiya Guys,
 
I've just solved my own problem 20-seconds before posting the question!  Smile  So thought I'd post the solution here:
 
PROBLEM:  Connecting to an MS SQL Server database via Database Expert (using either an "ODBC (RDO)" or "OLE DB (ADO)" connection) shows no available databases in the dropdown (even when creating the same ODBC connection via "Administrative Tools -> Data Sources" is successful);
 
SOLUTION:  Update CR2011 with "Support Package 1":
( http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm - http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm );
 
Hope this helps someone - I was pulling my hair out!
 
Possible cause is installing MS SQL Server 2012 on your local machine... this updated my Native SQL Driver to "11.0" - and then trying any other Native Drivers (ie: "10.0" and previous) wouldn't work.
 
Cheers,
 
Steve.


Print Page | Close Window