This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 0%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Azure Percept Reference solution for Voice Control Inventory Management has errors in accessing the SQL database.
Trying out the reference solution in the below link-
https://github.com/microsoft/Azure-Percept-Reference-Solutions/tree/main/voice-control-inventory-management
documentation link :
https://learn.microsoft.com/en-us/azure/azure-percept/voice-control-your-inventory-then-visualize-with-power-bi-dashboard
Getting the following error when testing the function app at step 2->7->d. of the documentation.
Error: ****Result: Failure Exception: ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "Stock" requested by the login. The login failed. (4060) (SQLDriverConnect)')****
The username and password given in the CRUD.py file are correct. Still the error.
ODBC Driver 17 is also installed.
A comprehensive Azure platform with added security for creating edge artificial intelligence solutions.
An Azure relational database service.
Could please try to reset the Server admin password and then update the password on the CRUD.py file accordingly?
On the firewall settings of the Azure SQL database:
Please allow Azure services to access the database.
To connect to Azure SQL Database using Power BI please consider the steps provided here.
Hope this helps.
Hello @AlbertoMorilla
Thank you for you response to the issue.
I tried the steps as mentioned in the answer and encountered a new error which I am pasting below.
Error: Result: Failure Exception: AttributeError: module 'azure.functions._abc' has no attribute 'SqlRow'
PS: The images you add as part of your answer are not visible in any browser.
Awaiting your response.
Thank You!!
This was my answer @vinit sawant
@vinit sawant About the new error:
Error: Result: Failure Exception: AttributeError: module 'azure.functions._abc' has no attribute 'SqlRow'
Please try the solutions provided in GitHub.
@vinit sawant let me know if you read this.
Hello @Alberto Morillo , I tried the solution in the provided in GitHub.
After making those changes, I returning back to the original error for which the question was asked.
Error : Result: Failure Exception: ProgrammingError: ('42000', '[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot open database "Stock" requested by the login. The login failed. (4060) (SQLDriverConnect)')
Kindly help with a turn around.
Awaiting your response.
Please try to create the whole solution in the "Europe West" region. Create on that region the Azure Function and the Azure SQL database.
Hello @Alberto Morillo , did the changes you mentioned. re-created resources in Europe-west.
Encountering a new Error:
Error: **Result: Failure Exception: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)') **
Please remeber to do the changes on the Firewall that I showed on the images of my first reply.
Hi @Alberto Morillo , I did the following changes on firewall as well. Still getting the "Login Timeout Error"
On the GitHub thread the last user comments say on East US and Europe West the issue was fixed. It seems changes on the Azure platform are creating this bug but users recently are reporting the issue was fixed on those regions.
which Github thread, can you please paste the link to that thread as a comment
Hello @Alberto Morillo Which Github thread, can you please attach link to the thread
This the Github thread.
@Alberto Morillo , The github thread explains about the previous error.
Now i am getting another error as i mentioned in the comments above.
Mentioning error again.
Encountering a new Error:
Error: Result: Failure Exception: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
That is not the error that you originally posted. It is now a timeout error not a login failed error.
@Alberto Morillo exactly yes.
Getting timeout error.
Can you please help me solve that error.
It is better to create a separate question (a new forum thread) for the new error.