Connecting Crystal 2020 to SQL database on Microsoft SQL Server Management Studio

[DellSC]

I have data on a SQL server that I cannot see when establishing a connection through the Marxmeier ODBC connection. On the MS Server Management Studio, I can see the dbo datasets/tables. When I start a new report in Crystal 2020, create a new database connection, I can see the Tables and Views category, but there are no data base objects. I am wondering if there is a driver I need to install to make them available? Or why I cant see the datasets I need to create a report.

[DellSC]

What version of SQL Server are you connecting to? What is the "Marxmeier ODBC connection"? What version of Crystal are you using?

-Dell

[former_member1096675]

These are the views I am trying to access

I am able to connect thru the ODBC to the sql server, but these views are not showing

[former_member1096675]

SQL Server Management Studio v17.1

The ODBC is just a data source administrator. Allows Crystal to connect to data source

These are the two data sources on the SQL server