WCF Service Hosted In IIS Unable to Connect to SQL Server and display In SharePoint Online External List

I have Hosted a WCF service in IIS and I am using SharePoint designer 2013 to connect to BCS of SharePoint online.
I am able to create the external content type and external content list but when I access the external list I am getting the below error

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)

I have given all the required permission in SQL server to make it accessible and have checked it its accessible

I have hosted the same WCF service which is hosted in IIS in Azure App Service and its working fine and the data is getting pulled and being displayed in External list

below is my web config of WCF Service

enter image description here

Can you please help me

Thank you
Syed Shadab Mohammed

php – How to modify the WooCommerce shop page to tweak the display price without affecting the actual price under the hood?

The woocommerce shop I am working on imports product price as “£ per g”, this is correct for the calculation. On the shop page my client would like the price to be displayed as “£ per 100g” so I need to multiply the price by 100. In functions.php I have the following snippet which lets me change what is displayed (as you can see, I have already edited the text to display correctly), does anyone provide help on how to translate this import price to display price?

add_filter( 'woocommerce_get_price_html', 'wb_change_product_html' );
    // Change and return $price_html variable using the $price and weight amount
    let a = 10
    function wb_change_product_html( $price ) {
        $price_html = '<span class="amount">' . $price . ' per 100g </span>';   // change weight measurement here
        return $price_html;
    add_filter( 'woocommerce_cart_item_price', 'wb_change_product_price_cart' );
    // Change the cart prices with $price variable and weight amount
    function wb_change_product_price_cart( $price ) {
        $price = $price . ' per g'; // change weight measurement here
        return $price;

I’m sure that there’s a quick fix here! I have also added a screenshot of the import columns so that the price change I’m looking for can be seen.

enter image description here

google sheets – How do I display data from cells, but skip over the blank cells?

I have a list of scores, and I need to display them concisely. How do I read a long row of cells only some of which have scores in them, and print those scores out?

Example: https://docs.google.com/spreadsheets/d/1nPTBFXaIgpruPgNoWFSBUL2yKaibjeNJNExhnHVr8LE/edit#gid=0

I tried using a combination of arrayformula and if’s, but failed pretty terribly : ]

Display category name , category posts and create pagination using ajax [closed]

Display category name , category posts and create pagination by clicking on category name the related category posts need to show using ajax

webcam – Why doesn’t my Windows 10 laptop recognize the iSight camera of my Apple Cinema Display?

I have a Windows 10 laptop(a Lenovo X1 Thinkpad Carbon) with an Apple Cinema Display used as an external monitor. Up until now I have had no trouble selecting either the webcam on the Windows laptop or the iSight camera on the Cinema Display when I am using Zoom, WebeX, or other applications. Now all of a sudden the computer no longer recognizes any camera other than the one on the laptop even though the Cinema Display is still working and the microphone on the Cinema display is working as well. I have rebooted the computer, unplugged the Cinema Display and plugged it back in, disconnected and reconnected the cable from the display to the computer, and I still can’t see the camera any more. Any suggestions?

Filebrowser 8.x-2.2 module display changes

Directory listing node (by Filebrowser 8.x-2.2 module) problems:

  1. In grid display the sorting is not working. It is always ascending, even after changing the default settings; 2. The width of the grid changes nothing; 3. The grid orientation has only ‘horizontal’ option.

html – Sistema de blocos do ‘display: flex’ não funciona igual ao ‘display:grid’

        @import url(https://fonts.googleapis.com/css?family=Open+Sans);

        body {
            font-family: "Open Sans";

        .footer-store-info {
            display: flex;
            grid: auto / repeat(4, 25%);
            flex-wrap: wrap;

        .footer-store-info div {
            flex-grow: 1;

        .footer-store-info div:nth-of-type(5) {
            grid-column-end: span 4;
            flex-grow: 4;
            /* max-width: 100vw; */

        .footer-store-info div:nth-of-type(6), .footer-store-info div:nth-of-type(7) {
            grid-column-end: span 2;
            flex-grow: 2;

        .footer-store-info h3 {
            color: #606060;
            font: normal normal bold 20px/27px;

        .footer-store-info p {
            color: #606060;
            font: normal normal bold 300 20px/27px;
<div class="footer-store-info">
        <div class="duvidas">
            <p>Como Comprar</p>
            <p>Troca e Devolução</p>

        <div class="institucional">
            <p>Quem somos</p>
            <p>Termos e Condições</p>
            <p>Politica de Privacidade</p>

        <div class="minha_conta">
            <h3>MINHA CONTA</h3>
            <p>Minha Conta</p>
            <p>Meu Carrinho</p>
            <p>Meus Pedidos</p>

        <div class="loja_segura">
            <h3>LOJA SEGURA</h3>
            <img src="https://pt.stackoverflow.com/" alt="Comodo SSL Certificate">
            <img src="https://pt.stackoverflow.com/" alt="Correios">
            <img src="https://pt.stackoverflow.com/" alt="Google Safe Browsing">

        <div class="formas_pagamento">
            <h3>FORMAS DE PAGAMENTO</h3>
            <img src="https://pt.stackoverflow.com/" alt="VISA">
            <img src="https://pt.stackoverflow.com/" alt="MasterCard">
            <img src="https://pt.stackoverflow.com/" alt="American Express">
            <img src="https://pt.stackoverflow.com/" alt="Diners Club International">
            <img src="https://pt.stackoverflow.com/" alt="PagSeguro UOL">
            <img src="https://pt.stackoverflow.com/" alt="Boleto">

        <div class="sac">
                Segunda a sextas das 8h ás 18h
                Sábado das 8h ás 13h

        <div class="dados_bandeirante">
            <h3>DADOS XXXXXXXXXXXXXXX</h3>
                Razão Social/Nome: R. XXXXXXXX
                CNPJ: XXXXXXXXXX
                Av. XXXXXXXXXXXXXXXX

display – What is the best way to connect a mid 2012 macbook pro to a new ultra wide 4K external monitor?

What is the best way to connect a mid 2012 macbook pro to a new ultra wide 4K external monitor? I know most of the monitors suggest using USB C but that doesn’t exist in my macbook pro so trying to figure out the best option (that doesn’t require ordering a new laptop)

8 – Display price in add to cart form BEFORE add to cart button

I spent weeks on trying to find a clean solution using the commerce-product.html.twig template but to no avail. The problem is the fact that the variation fields and add-to-cart button are packed together into one component (product.variations) in a way that is difficult to decompose. I cannot think of a way to insert the price in there somewhere. Someone should create an issue about this.

Here is a hacky CSS-workaround.

First, create some space above the add-to-cart button:

.commerce-order-item-add-to-cart-form .form-actions {
   margin-top: 4em;

Now place the price div into the created space:

article .field--type-commerce-price {
   position: absolute;
   bottom: 2.5em;

This also works when the price is updated.

Still looking for a cleaner solution.

display – Kensington SD4000 / Displaylink USB Hub not working with MacOS 10.15.6

I have a Kensington SD4000 USB Hub which I’m using with a Samsung U28E590 4k monitor.

And actually I have a seperate ASUS USB Hub with a another 4K monitor, and this is working fine.

This had been working fine up until a few days ago, which I assume coincides with MacOS update.

Now, the screen and computer seem to not detect each other. I don’t think the monitor has a problem as it works when I plug it into the ASUS hub.

I have installed the most recent Displaylink driver here.

This article here suggests looking at your info in the System report.

There is no mention of a display adapter in my USB devices.

enter image description here

Other people suggest putting a check on DisplayLinkUserAgent in System Preferences / Security and Privacy. However DisplayLink isn’t in any of the options there.

Any suggestions for fixing this?