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