Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: ODBC Connection only Showing Functions Post Reply Post New Topic
Author Message
wmertz
Newbie
Newbie
Avatar

Joined: 11 Jan 2010
Location: United States
Online Status: Offline
Posts: 1
Quote wmertz Replybullet Topic: ODBC Connection only Showing Functions
    Posted: 11 Jan 2010 at 8:43am
I am having a problem when trying to attach a new connection via ODBC.  When I select the schema, I am only seeing functions in the list, not views, tables, etc.  At one point in time it was fine, but something has changed.  My DBA says it is nothing on his side, I can see the tables and views via other programs using the same ID, and I have tried re-installing Crystal (on version 10).  Nothing seems to help.  Anyone have any ideas on where to look/what to change?
 
Thanks in advance for the help!
 
wendy
IP IP Logged
Jodi
Newbie
Newbie
Avatar

Joined: 22 Jan 2010
Location: United States
Online Status: Offline
Posts: 1
Quote Jodi Replybullet Posted: 22 Jan 2010 at 8:39am

Hi Wendy,

 

The same thing happened to my ODBC connections a few weeks ago when I got a new computer.  I have version XI, but in case it could be the same solution, here’s what fixed it on my machine:

 

In the Database Expert, under Available Data Sources, right click on the database symbol for your data source.  Select Options, and check all the checkboxes in the Data Explorer area.

 

Hope this helps.

Jodi

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.031 seconds.