Forum Discussion

danielpaduck's avatar
danielpaduck
Icon for Helper III rankHelper III
2 years ago

ODBC Connection Error On Gateway - URL was ot property formatted

I am working with a client that is using ODBC to do a data connection.  I have been able to set up the ODBC in my own testing gateway and can use it for refreshes but when I set the ODBC connection on the client's production tenant, I am seeing the following:

 

 

Not sure how to troubleshoot this one because I set up the connector the same way on my own tenant and it worked.  Also, I confirmed the ODBC connector is running correctly on the client's server. 

Need Help

3 Replies

  • danielpaduck's avatar
    danielpaduck
    Icon for Helper III rankHelper III
    2 years ago

    The gateway is installed on a local server.  I did not set it up but I will check if the user set it up as a personal or standard gateway.  Thanks! 

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi danielpaduck 

    Where is the Gateway installed? is it a personal Gateway or The standard Gateway?

    If it is personal Gateway then it won't work.

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Icon for Community Support rankCommunity Support
    2 years ago

    Hi danielpaduck ,

     

    Has your issue been resolved so far? Are you troubleshooting the problem based on the solution ideas provided by aj1973 ? If the issue is not resolved at this time, can you provide more information for our reference? This will better help you deal with the issue.

    Looking forward to your reply.

     

    Best Regards,
    Yulia Yan

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.