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.

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

db_odbc: Login failed for user ''. #21

Open
sdmcallister opened this issue Sep 29, 2023 · 0 comments
Open

db_odbc: Login failed for user ''. #21

sdmcallister opened this issue Sep 29, 2023 · 0 comments

Comments

@sdmcallister
Copy link

I have two DSNs for mssql. One uses Integrated authentication and works, while the other uses SQL Server Authentication and gives an error (shown below). I've tested both connections and they work from the odbc data source administrator. I've also tried adding the user name and password and db to the open function.

I'm on Windows 10.
Driver is SQL Server Native Client 11.0

import db_connector/db_odbc

var db2 = open("mssql","" ,"", "")
echo "works"
db2.close()

var db = open("mssql_nim","" ,"", "")
db.close()
Warning: 01000 [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'Datawarehouse'.
works

Error: 28000 [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ''.
db_connector-0.1.0-05c335ec678614b973d8a80651971e0719045d14\db_connector\db_odbc.nim(524) open
db_connector-0.1.0-05c335ec678614b973d8a80651971e0719045d14\db_connector\db_odbc.nim(176) dbError
Error: unhandled exception: ODBC Error [DbError]

Also, is it possible to silence the Warning msg?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant