Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

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

Jump to bottom

odbc_kwargs need ';' as separator from password for sqlalchemy engine URL #131

Open
windiana42 opened this issue Jun 27, 2023 · 0 comments
Open

odbc_kwargs need ';' as separator from password for sqlalchemy engine URL #131

windiana42 opened this issue Jun 27, 2023 · 0 comments

Comments

@windiana42
Copy link
Contributor

windiana42 commented Jun 27, 2023 •
edited
Loading

When passing odbc_kwargs["encrypt"]="no" to bcpandas.sqlCreds, it is appended to the connect string after the password without a separator. Workaround that creates working sqlalchemy engine but does not work with bcp executable: sqlCreds(password=password+";", odbc_kwargs=dict(encrypt="no"))
windiana42 added a commit to windiana42/bcpandas that referenced this issue Jun 28, 2023
@windiana42
add failing tests for issues yehoshuadimarsky#130 yehoshuadimarsky#131
bee88a0
windiana42 added a commit to windiana42/bcpandas that referenced this issue Jun 28, 2023
@windiana42
add failing tests for issues yehoshuadimarsky#130 yehoshuadimarsky#131
f1bfe33
windiana42 added a commit to windiana42/bcpandas that referenced this issue Jun 28, 2023
@windiana42
append semicolon ";" for PWD just like Trusted_Connection
2763cc3 
fixes yehoshuadimarsky#131

Disclaimer:
I currently don't have a test environment that can execute tests with
`@pytest.mark.usefixtures("database")` and thus some failing tests
related to yehoshuadimarsky#131 might not be fixed as claimed by this commit message.
borchero pushed a commit that referenced this issue Jul 12, 2023
@windiana42
propose solution for issues #130 #131 (#133)
bd61a32
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@windiana42