Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: ODBC Connection Post Reply Post New Topic
Author Message
--cavsix--
Newbie
Newbie


Joined: 24 Mar 2010
Online Status: Offline
Posts: 2
Quote --cavsix-- Replybullet Topic: ODBC Connection
    Posted: 24 Mar 2010 at 8:01am

Hi.

 

I have a little problem with my connection between CR XI and the server...

 

I'm just doing the ODBC and all is working

 

But when I go to CR and try to make a new report the ODBC connection only display a number of tables from A to M... but my tables finish on SY..

 

I have all access on SQL in fact I have installed the enterprise manager and query analyzer on my local pc... and I see all the tables...

 

Can you help me?
IP IP Logged
Yudi
Newbie
Newbie


Joined: 03 Aug 2009
Online Status: Offline
Posts: 13
Quote Yudi Replybullet Posted: 24 Mar 2010 at 11:52am
Hi cavsix
 
What the database server you use and is your odbc driver updated till last version ??
 
based on my experience (i use CR XI, Mysql5, mysql odbc5), it is also related to the option you have made in your connection (dsn).
 
For example, when i choose to display tables and views (option inside data explorer box), the DSN will show the "Add Command" menu and the list of all tables and views. But when i choose to display tables, views and stored procedures, the DSN will only show the "Add Command" menu and the list of all stored procedures. It doesn't show the list of table/view anymore
Thanks And Regards
Yudi Purwanto
http://yudio.net/
IP IP Logged
--cavsix--
Newbie
Newbie


Joined: 24 Mar 2010
Online Status: Offline
Posts: 2
Quote --cavsix-- Replybullet Posted: 29 Mar 2010 at 6:54am
thanks for your answer but doesn't work i have the same number of tables.. in fact i can't see the views that i have created.
 
Regards
IP IP Logged
Inanimate
Newbie
Newbie
Avatar

Joined: 30 Oct 2013
Location: Australia
Online Status: Offline
Posts: 1
Quote Inanimate Replybullet Posted: 31 Oct 2013 at 1:27pm
Hi, I sure it's a bit late for the original poster, but if anyone else stumbles on this thread I worked out how to do this.

If you right click on your data source and select Options

you can add a table filter and restrict the list of tables being displayed by entering a string in the
"Table Names Like" field.

There are also options here to display/not display Tables, Views and Stored Procedures etc.

Edited by Inanimate - 31 Oct 2013 at 1:28pm
IP IP Logged
jms493
Newbie
Newbie


Joined: 11 Apr 2012
Location: United States
Online Status: Offline
Posts: 3
Quote jms493 Replybullet Posted: 09 Dec 2015 at 6:39am
I have the same exact problem. This just started this morning. Both users of Crystal can only see to table M. Very Strange.
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.