We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Python
python: 3.11.8 connectorx: 0.3.2
Microsoft SQL Server (MSSQL)
Pandas and/or Polars
Authentication works with the SQL Alchemy engine but not ConnectorX with the same connection url
I have a username with the following special character: \
I have a password with the following special characters: !`>]
I am URL encoding both of them with quote_plus.
quote_plus
N/A
from sqlalchemy.engine import URL, create_engine driver_string = 'FreeTDS' db_username = "my\\username" db_password = r'my_special_password_`!]>' db_username_url = quote_plus(db_username) db_password_url = quote_plus(db_password) port = 1433 tds_version = 'auto' connection_url: str = ( URL .create( drivername="mssql+pyodbc", username=db_username_url, password=db_password_url, host=server, port=port, database=database, query={"driver": driver_string, "TDS_Version": tds_version, "UseNTLMv2": "Yes"} ) .render_as_string(hide_password=False) ) # This works my_engine = create_engine(connection_url) my_engine.connect() # This doesn't work cx.read_sql(connection_url, "SELECT 1", return_type='polars')
ERROR tiberius::tds::stream::token] Login failed for user my\username'. code=18456
The text was updated successfully, but these errors were encountered:
No branches or pull requests
What language are you using?
Python
What version are you using?
python: 3.11.8
connectorx: 0.3.2
What database are you using?
Microsoft SQL Server (MSSQL)
What dataframe are you using?
Pandas and/or Polars
Can you describe your bug?
Authentication works with the SQL Alchemy engine but not ConnectorX with the same connection url
What are the steps to reproduce the behavior?
I have a username with the following special character:
\
I have a password with the following special characters:
!`>]
I am URL encoding both of them with
quote_plus
.Database setup if the error only happens on specific data or data type
N/A
Example query / code
What is the error?
The text was updated successfully, but these errors were encountered: