Symantec Access Management

Expand all | Collapse all

CA ODBC Drivers

Jump to Best Answer
  • 1.  CA ODBC Drivers

    Posted 07-23-2018 04:26 PM

    Hi 

     

    We’re querying the ODBC connection on Risk Authentication using SQL Reporting Services. We got this very strange error:

     

     

     

    Please advise if we are allowed to do so?

     

    Regards



  • 2.  Re: CA ODBC Drivers
    Best Answer

    Posted 07-25-2018 06:08 AM

    SQL Server Reporting Services is a completely different solution that customers use for creating, publishing, and managing reports, then delivering them to the right users in different ways. It requires a license from datadirect.

     

    Would recommend you to use SQL Management Studio to get the db output from Risk Auth DB.



  • 3.  Re: CA ODBC Drivers

    Posted 08-08-2018 05:58 AM

    Thanks renar01,

     

    Are you saying we cannot connect to the CA Riskminder Oracle DB with SQL Reporting services WITHOUT a datadirect licence? And should import the data into Microsoft SQL ?



  • 4.  Re: CA ODBC Drivers

    Posted 08-09-2018 06:11 AM

    Hi Francois,

     

    Yes, Webfort, Riskfort and UDS are having license to use Data Direct.

    You can SQL Management Studio and connect to your database and query the database to get the data.

     

    Thanks,
    Sharan



  • 5.  Re: CA ODBC Drivers

    Posted 09-12-2018 12:25 PM

    The DSN you are using for the connection has been configured using the "Arcot DataDirect SQL Server Wire Protocol" driver.  You would need to use a DSN which was configured with the "SQL Server" driver to establish a connection with SQL Reporting Services.