Print Page | Close Window

Cannot see Views in database expert

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=1713
Printed Date: 06 Apr 2025 at 7:34pm


Topic: Cannot see Views in database expert
Posted By: vijayk
Subject: Cannot see Views in database expert
Date Posted: 19 Nov 2007 at 11:17am
Hi:
 
I cannot see views when i am trying to mainframe database. Is there a setting that needs to be enabled..?
 
I did check the setting under File --> Options --> Database --> Data Explorer -->Views.
 
Thanks
Vijay


Replies:
Posted By: BrianBischof
Date Posted: 19 Nov 2007 at 11:23am
You did what you needed to do for the settings. I'm thinking that the ODBC driver isn't exposing them to Crystal. Is it an older database? Do you have the latest ODBC drivers? Also, it's probably best to not use OLE DB in this circumstance.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: vijayk
Date Posted: 19 Nov 2007 at 11:53am

Thanks for the reply Brian. I have a IBM DB2 7.2 Client installed on my machine. Do you think It's the version.?

Thanks
Vijay
 

Posted By: BrianBischof
Date Posted: 19 Nov 2007 at 12:53pm
Unfortunately, I'm a SQL Server guy and don't know compatibility issues with other databases. But problems like this are typically related to functionality within the database driver. So I would check for version updates or new drivers if possible. Also, I do know that people who use OLE DB often have their problems resolved when switching to the ODBC driver.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: vijayk
Date Posted: 20 Nov 2007 at 6:23am
But, Why am i able to see the list of views fine in Business Objects, eventhough i am using the same driver for both Business Objects and crystal.
 
Thanks
Vijay


Print Page | Close Window