Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Local PB copy connected to server DB

  1. How-to
0
Votes
Undo
  1. Robert Sawyer
    Robert Sawyer
  2. PowerBuilder
  3. Wednesday, 17 July 2024 16:18 PM UTC

I have a local copy of PB and a local copy of the DB. Of course, I can connect just fine by specifying the local connection string in my ini file.

To connect to the server and DB on our network, I have to go to a remote desktop connection - then I can see the network drives or I can connect to a server and DB.

But, I can't connect PB to the server on the network Is there a way to do so, so I can run PB locally but user the server DB?

PDFDocument object and GHOSTSCRIPT
Eliminate Queries against SYS.ALL_SYNONYMS with Po...
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 July 2024 16:56 PM UTC
  2. PowerBuilder
  3. # 1

Hi Robert;

  That is most likely due to a firewall issue. Your Network probably needs to open a "trusted" port in the firewall for your PB App (aka "white Hole") and your DBA will need to advise you if you can use a DNS name for the DB Server or use a specific IP address instead.  HTH

Regards .. Chris

Comment
Robert Sawyer
  1. Robert Sawyer
  2. Wednesday, 17 July 2024 17:06 PM UTC
So I could potentially use an IP address in the ini? Some for the local DB profile connection?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 17 July 2024 17:25 PM UTC
Yes, assuming that the INI value is being loaded into the SQLCA.ServerName property of the Transaction Object.

Note that some DB Client connectivity might require this value in the SQLCA.DBParm field as well

For a local DBMS - the "LocalHost" IP would be "127.0.0.1"

HTH
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.