Skip to content

Cant install the xgboost package #92

Open

Description

@danihello22

using the current examples I cant install the package.

import sqlmlutils
connection = sqlmlutils.ConnectionInfo(server="name,port", database="dbname", uid="accname", pwd="accpwd")
sqlmlutils.SQLPackageManager(connection).install("XGBoost")

the error I am getting:

Traceback (most recent call last):
File "C:\Users\engserveradmin\AppData\Roaming\Python\Python37\site-packages\sqlmlutils\sqlqueryexecutor.py", line 65, in execute_query
self._cursor.execute(query, params)
pyodbc.Error: ('01000', '[01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()). (10054) (SQLPutData); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation. (11)')

I've tried to download the files manually but I am getting the same error

Activity

  1. monamaki commented on Nov 2, 2021

    @monamaki

    Hello,
    Can you please provide us with the version of the SQL server, sqlmlutils, and python you run this against?

    Also, could you please elaborate on which files you have tried to download manually? sqlmlutils package or XGBoost?

    For getting the version of SQL Server: select @@VERSION

    For getting the version of Python runtime on SQL Server:

    EXECUTE sp_execute_external_script
      @language = N'Python',
      @script = N'
    import sys
    print(sys.version)'
    

    Please take a look at our MSDN doc as it has more information than the GitHub readme file and try to follow guidelines from there: https://docs.microsoft.com/en-us/sql/machine-learning/package-management/install-additional-python-packages-on-sql-server?view=sql-server-ver15

    For one thing, the version of the python client you use should be the same version as the python runtime in the SQL server.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions