sfu-db / connector-x

Fastest library to load data from DB to DataFrames in Rust and Python
https://sfu-db.github.io/connector-x
MIT License
1.95k stars 154 forks source link

RuntimeError: Timed out in bb8 #329

Open WheaeSong opened 2 years ago

WheaeSong commented 2 years ago

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

wangxiaoying commented 2 years ago

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.