Unanswered: Help: How to connect Powerbuilder to a SQL Clustered Server?
We have an application that uses an INI file to connect to a SQL server. This works fine, until recently one of our client has clustered sql server. We installed our APP on one of the client machine running Win2K and the application failed to connect to the server.
To test if the client was able to connect to the server, I manually add an ODBC connection through Control Panel. Then on the server I set it as
10.115.14.124\SQL1. I then tested the connection and it worked fine.
I am using transaction for the connection. Here is the sample connection for the servername.
Transaction it_transaction = sqlca
it_transaction.servername = "10.115.14.124\SQL1"
I even changed this to
it_transaction.servername = "10.115.14.124\SQL1,1810"
There was a suggestion that I used the port hence I added 1810, but to no avail.