Question Re: Connecting Crystal 2020 to SQL database on Microsoft SQL Server Management Studio in Technology Q&A

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

former_member1096675 — Tue, 02 Aug 2022 15:39:44 GMT

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.

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

DellSC — Tue, 02 Aug 2022 15:43:36 GMT

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

-Dell

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

former_member1096675 — Tue, 02 Aug 2022 17:12:59 GMT

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

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

former_member1096675 — Tue, 02 Aug 2022 17:15:23 GMT

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