sqlmlutils icon indicating copy to clipboard operation
sqlmlutils copied to clipboard

Cant install the xgboost package

Open danihello22 opened this issue 4 years ago • 1 comments

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

danihello22 avatar Oct 12 '21 06:10 danihello22

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.

monamaki avatar Nov 02 '21 23:11 monamaki