MS SQL server is running with TCP/IP protocol. I need an example of how to set the URL. I have the IP address of my network. I can also set the listening port of the MS SQL server. Currently, I need some help just to add the external database. Thanks in advance.
Hey,
If you need help adding an external database the following links should help.
Corvid: Adding and Deleting an External Database Collection
Corvid: Working with External Database Collections
External Database Collections API
Hope this helps!
Dara | Corvid Team
Unfortunately, it doesn’t help. I need to know why the fetch failed. It’s an issue with the URL.
The documentation is good enough for the adapters and the flow. But, my problem is that I’m not able to make the connection. I mentioned the URL as the IP address of the SQL server. I made all ports available, but I can’t see in the SQL log that WIX is trying to connect.
So, I can’t use the external DB and I’m about to take a decision to not use WIX.
Hey,
You are provided the steps to generate the URL within a link to GitHub in one of those articles when it mentions setting up your SPI Endpoints.
In case you missed that you can go here and follow the steps to generate the URL that you need.
Dara | Corvid Team
Thanks for your reply, but I’m not intreetsed in Gogle cloud SQL. I have an instance installed in my computer. In the SQL configuration managment I configured the TCP/IP address and the port 1433. I also configured a fix internal IP address for my computer (10.0.0.10).
I though the port where the SQL server instance is listening should be enough. But maybe the URL in WIX should contain both the IP address of my router plus the internal address. In that case I don’t know how to write the address.
Was this ever resolved?
I am at an absolutely frustrating impasse with the same scenario.
I use local hosting to test and prove, before any instances are deployed.
Since this is a home network I would much rather not register the IP and set up SSL just for the dev. I also have zero desire to deploy cloud base UNTIL dev is complete.
summary: The editor should NOT block an IP based URL from being used as the endpoint for an external DB.
Unfortunately, not resolved. I gave up.
That’s a shame.
The interface accepted the connection for me this evening so long as the server accepted https, even without placing a domain over the IP. Still a pain to add encryption and handling to a local db. WIX would benefit to either update their adapter examples to include CA handling OR update the interface to not require ssl.
Either way the adapter example needs to be updated for more current promise handling.