microsoft / sqlmlutils

Utility functions for easier usage of SQL Server Machine Learning Services
Other
32 stars 33 forks source link

Cant install the xgboost package #92

Open danihello22 opened 2 years ago

danihello22 commented 2 years ago

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

monamaki commented 2 years ago

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.