1

I am trying to reduce the loading times to extract a database from SQL SERVER. I have read a lot about this library but no matter how hard I have tried I have not been able to connect, can someone tell me if this is possible or guide me to configure it, thanks.

try using pyodbc config

Pythoneer
  • 319
  • 1
  • 16
J.alvear
  • 11
  • 1

1 Answers1

0

per this discussion, at least some support has been added

I used sqlalchemy's urlib to make urls: and since url objects do not have a split() method, I cast to string.

connection_url = str(sqlalchemy.engine.URL.create("mssql",database=database, host=servername,
                                              username=username,
                                              password=password,
                                              query = {'driver':'SQL Server'}))

I then used connectorx.read_sql(connection_url, 'select * from sys.databases') to validate the connection worked.

It worked for my system's sql server authentication database connections but failed to login for Windows Domain Authentication.

Isaacnfairplay
  • 217
  • 2
  • 18