Skip to content

Unable to connect to database with backslash in MSSQL host #809

Open
@Sergfalt

Description

@Sergfalt

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions