connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

RuntimeError: Timed out in bb8

Open WheaeSong opened this issue 3 years ago • 1 comments

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?

image

WheaeSong avatar Aug 12 '22 01:08 WheaeSong

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.

wangxiaoying avatar Aug 17 '22 04:08 wangxiaoying