Skip to Content
0
Former Member
Apr 22, 2009 at 12:46 PM

Crystal Reports 2008 and SQL 2005 database not displaying all tables

23 Views

I have one database (Juris) on a SQL 2005 server. When I connect to the database using the ODBC connection and Crystal 2008, I'm only able to view about 120 tables in the database expert.

I also have Crystal version 8.5 as well and I have no problems seeing all the tables in the same database, using the same ODBC datasource.

I have tried the registry fix on the NTablesMax key and it did not help.

Just to give some other background. I can connect to large a SQL 2000 database with Crystal 2008 and all tables are visible.

I am only having the issue with Crystal 2008 and the SQL 2005 database.

Any guesses??

Thanks.

Aaron