ODBC connection in machine learning service script not working

Schipperijn, Peter 0 Reputation points
2024-03-19T22:07:54.15+00:00

We run python and R scripts using machine learning services in the database on a Managed Instance. Lately on one of our instances the connection fails. We try exactly the same connection on another instance and with other apps, e.g. Import/Export Wizard and it works fine. Both instances are running the same version and compat level.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CosmogHong-MSFT 22,466 Reputation points Microsoft Vendor
    2024-03-20T01:59:12.5033333+00:00

    Hi @Schipperijn, Peter

    What's the error message like?

    Please refer to this tech doc to troubleshoot connect errors, which are provided in order of the issues from simple to complex.

    And it is recommended that you gather the information listed in this doc before proceeding with the actual steps to troubleshoot the error.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments