Data Connectivity: ODBC Connection

ODBC Connection

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=9484
Printed Date: 01 May 2024 at 9:27pm

Topic: ODBC Connection

Posted By: --cavsix--
Subject: ODBC Connection
Date 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?

Replies:

Posted By: Yudi
Date 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/ - http://yudio.net/

Posted By: --cavsix--
Date 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

Posted By: Inanimate
Date 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.

Posted By: jms493
Date 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.