Forum Discussion

jacschZA's avatar
jacschZA
Advocate I
7 years ago
Solved

SQL setup - Direct Query

Hi,   We are sruggling with getting a Direct Query Connection to a SQL database on premis. We can complete a LOAD of data from the same SQL database, but when using Direct Query for the exact same ...
Need Help
jacschZA's avatar
jacschZA
Advocate I
7 years ago

v-cherch-msft  thanks for the response!

 

What we ended up trying and what worked was specifying the server name with 'TCP:' as a prefix, and then instead of using a port number at the end of the server name, used the actual name, and this seems to work now for both Direct Query and with the Gateway.

 

 

Any idea why this may have been the case?

 

Jacques

  • jacschZA's avatar
    jacschZA
    Advocate I
    7 years ago

    v-cherch-msft Thats it, the comma instead of the double colon works as well.

     

    Dont understand what it does differently, but it solves my query.