Cant install the xgboost package
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
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.