search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.2k stars 21.36k forks source link

Doc Issue: Wrong description in "SQL connection string" section for Java, JavaScript and Python in the page "Azure SQL bindings for Azure Functions overview" for Azure Function. #124472

Open rikat-ms opened 3 hours ago

rikat-ms commented 3 hours ago

This is feedback issue for the following doc. There is no feedback section to create an issue for the page, I create this here directly.

Document:

Issue:

There is "SQL connection string" section in this page. It describes connection options which are available for Microsoft.Data.SqlClient. This description is correct only for C# or PowerShell because Microsoft.Data.SqlClient can be used in .NET Framework or .NET applications. However, this section is displayed event though either of Java, JavaScript or Python is selected. This causes users to implement the connection options which described in this section in their application and results application to fail.

Request:

Prepare the correct descriptions for Java, JavaScript or Python for "SQL connection string" and make this page to display correct description depending on the selected language.

Additional Information:

For Java or JavaScript, Microsoft JDBC Driver for SQL Server can be used to connect to SQL Server. The following document describes connection string. https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver16 Note that there is no pooling feature in JDBC driver and users must use a third-party library.

For Python, the third-party driver "pyodbc" with Microsoft ODBC Driver for SQL Server can be used to connect to SQL Server. https://learn.microsoft.com/en-us/sql/connect/python/pyodbc/python-sql-driver-pyodbc?view=sql-server-ver16 Here is an example of connection string. https://learn.microsoft.com/en-us/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-ver16#prerequisites

ManoharLakkoju-MSFT commented 2 hours ago

@rikat-ms Thanks for your feedback! We will investigate and update as appropriate.