I am trying to connect Skyward Database( Progress Database ) to MS SQL Server. What am I doing to connect? First Setup an ODBC connection to the Progress database in the ODBC Administrator in the System DSN. ( In System DSN, I am selecting ODBC driver for SQL server ). During setup, I am entering IP address on the server name. After that, I test my connection, it gives an error: Connection was not establishing. I don't know why is not connecting I am entering hostname correctly.
After that click on configured driver
After that, if I test this connection. its failed.
if i select other drivers datadirect SQL server
after that, i clicked on test connect it shows error that verify hostname and port
Please help me to connect skyward database and one more thing skyward is hosted on another server which is cloud-based.