Hi ValerieH, 

Crystal Reports 2020 is a 64-BIT Version only.. if you create a 32-BIT DSN it will not show up in Crystal Reports 2020.

Can you create the System DSN in 64-BIT ODBC and see if it shows up?

Regards,

DCrampton

yes i figured that part out but it still didn't work.  What does seem to have worked is to set the default db in the 64 bit ODBC and in options select show both name and desc, tables view system tables for data explorer.  Still confirm it works to do set db location and verify db with existing reports but at least I can now write a new report

Hi ValerieH there is an easy trick to fix this.  Always select the Connection String option and you will always be able to define your own settings, regardless of the ODBC driver version or age of Crystal.

1. Select ODBC (RDO) then Enter Connection String, paste in your connection string (example below) and click Next:

Here is the Connection String I'm using in this example:  

Driver={ODBC Driver 17 for SQL Server};Server=Sage300Demo;Database=SAMINC;Trusted_Connection=yes;Encrypt=No;

2.  You can now fill out any details you want:

Hi ValerieH there is an easy trick to fix this.  Always select the Connection String option and you will always be able to define your own settings, regardless of the ODBC driver version or age of Crystal.

1. Select ODBC (RDO) then Enter Connection String, paste in your connection string (example below) and click Next:

Here is the Connection String I'm using in this example:  

Driver={ODBC Driver 17 for SQL Server};Server=Sage300Demo;Database=SAMINC;Trusted_Connection=yes;Encrypt=No;

2.  You can now fill out any details you want: