Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: CR2011 ODBC Shows No Databases - FIXED! Post Reply Post New Topic
Author Message
bainsteven
Newbie
Newbie
Avatar

Joined: 15 Mar 2012
Location: United Kingdom
Online Status: Offline
Posts: 5
Quote bainsteven Replybullet Topic: CR2011 ODBC Shows No Databases - FIXED!
    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":
 
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.


Edited by bainsteven - 16 Mar 2012 at 12:10am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.