Forum Discussion

josalm's avatar
josalm
Copper Contributor
Nov 25, 2021

Azure Function can't connect to azure sql database

Hi.
I'm trying to connect my azure function to my azure sql database. When trying connection.open() it gives the following error.
Executed 'ClientID2' (Failed, Id=22ad8465-45f5-4fff-ba90-f0ff7d0ee465, Duration=5895ms)
[2021-11-25T10:49:57.575Z] System.Private.CoreLib: Exception while executing function: ClientID2. Microsoft.Data.SqlClient: The type initializer for 'Microsoft.Data.SqlClient.TdsParser' threw an exception. Microsoft.Data.SqlClient: Could not load file or assembly 'System.Text.Encoding.CodePages, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.

It runs on .net 5.0 framework, but not in .net core 3.1 .

[FunctionName("ClientID2")]
        public static async Task<IActionResult> Run(
            [HttpTrigger(AuthorizationLevel.Function, "get", Route = null)] HttpRequest req, ILogger log)
        {
            string requestBody = string.Empty;
            try
            {
                log.LogInformation("Function process");

                using (SqlConnection connection = new SqlConnection(Environment.GetEnvironmentVariable("Connection_Database")))
                {
                    connection.Open();

 Packages installed:

 

Can anyone point me in the right direction?

Best regards

No RepliesBe the first to reply

Resources