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

Unable to connect to database with backslash in MSSQL host

Open Sergfalt opened this issue 5 months ago • 0 comments

What language are you using?

Python

What version are you using?

0.4.3

What database are you using?

MSSQL

What dataframe are you using?

Arrow

Can you describe your bug?

Unable to connect to MSSQL database with hostname = msdb.d8\dev (example), when hostname without backslash connection is OK.

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

conn_mssql = f"mssql://{'user'}:{parse.quote_plus(password)}" + '@' + parse.quote('msdb.d5\dev') + f":{'1433'}/{'master'}"

tms = cx.read_sql(conn_mssql, """ select * from table """, return_type="arrow")

What is the error?

Invalid domain character.

Sergfalt avatar May 26 '25 13:05 Sergfalt