Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

FRESH DATA FROM DATABRICKS

Hi everyone,   I would like to refresh data, the source from 1 sandbox DataBricks (not created by me but I have permission rights) but this message occurs: OLE DB or ODBC error: [DataSource.Error]...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,
    Based on your description and the error information provided, the SSL validation failure appears to be the root cause of the problem. This usually happens when the server's SSL certificate does not match the hostname specified in the connection or the certificate is not trusted by the customer's system.
    To solve this problem, you can try the following steps:
    First, make sure that the server hostname specified in the connection string matches either the CN (common name) entry or the DNS name entry in the Subject Alternative Name field of the server SSL certificate. Secondly, SSL validation failures can also be due to the system not trusting the certificate. You may need to add the server's SSL certificate to your system's trusted certificate store.
    You can refer to the following documents for more information
    ssl - Adding Self Signed Certificate to trusted root certificate store using Command Line - Super User


    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly