Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cant install the xgboost package #92

Open
danihello22 opened this issue Oct 12, 2021 · 1 comment
Open

Cant install the xgboost package #92

danihello22 opened this issue Oct 12, 2021 · 1 comment

Comments

@danihello22
Copy link

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
Copy link

monamaki commented Nov 2, 2021

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
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants