connector-x
connector-x copied to clipboard
RuntimeError: Timed out in bb8
What language are you using?
Replace this text with the Rust or Python.
What version are you using?
Replace this text with the version.
What database are you using?
e.g. PostgreSQL, MySQL
What dataframe are you using?
e.g. Pandas, Arrow
Can you describe your bug?
Give a high level description of the bug.
What are the steps to reproduce the behavior?
If possible, please include a minimal simple example including:
Database setup if the error only happens on specific data or data type
Table schema and example data
Example query / code
I use pandas to connect like this, it is normal,
from mssql import connect
host = 'host'
port = '1433'
user = 'use'
password = 'pwd'
database = 'AIS20180930224051'
conn = connect(host=host, port=port,user=user, password=password,database=database,charset='utf8')
df = read_sql(sql_str,conn)
but when I try to use connector X to connect, the following error occurs:
conn = 'mssql://use:pwd@host:1433/database?encrypt=true&trusted_connection=true'
What is the error?

Hi @WheaeSong , the error means that connectorx cannot connect to your database. It seems like the database in your connection string should be AIS20180930224051 instead of database. Also, if you are using azure database, then currently we do not support active directory authentication on it: #308.