• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • issue connecting an app from an specific environment.

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

Resolved issue connecting an app from an specific environment.

  1. How-to
0
Votes
Undo
  1. Albert van Bochove
    Albert van Bochove
  2. PowerBuilder
  3. Wednesday, 13 September 2023 21:06 PM UTC

Hello all, 

I have an app buidlt in PB2022 that runs perfectly in one machine and in the other one does not get authorized my user, I am using an ODBC connection to get into the db, the connection is configured the same in both environments and in one machine opens ok and in the other machine I get the issue to connect to the db. I have tried to connect from  the environment where does not work properly ping to the sqlserver , ok, test ODBC Data source connection ok, is there somewhere else I can check in the config of the powerbuilder  that could help me?

thanks in advance

Single Sign on within PB 2022
POwerbuilder 2022 R2 SMTPClient username/password ...
Responses (2)
Albert van Bochove
Albert van Bochove Accepted Answer Pending Moderation
  1. Thursday, 14 September 2023 20:38 PM UTC
  2. PowerBuilder
  3. # 1

Cris, the  ODBC connection is ok, I have tested it and runs succesfully, my app is buildt for 32 bits and I am using the 32 bit ODBC administrator, so eep it out. Thanks for your  idea.  but is very strange, the same app is running in Windows 11 Enterprise (this is the machine in question) and in windows server 2019 , this is the only diference I notice and it is working ok in windows server, can this maybe something that cares?

 

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 20 September 2023 20:14 PM UTC
Hi Albert;

Wow .. I have never seen of heard of that happening using that setting. Very weird! :-(

FWIW: Personally, I would "dump" ODBC and use a native SS DB driver ( I always do). ODBC is middle-ware and fraught with issues.

Regards ... Chris
  1. Helpful 1
Albert van Bochove
  1. Albert van Bochove
  2. Thursday, 21 September 2023 18:26 PM UTC
do you have a link where to learn to use the SS DB driver?



I still will continuing tryng with my ODBC. let us see how far can I get.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 21 September 2023 20:20 PM UTC
Hi Albert;

As a quick check, change the code in your App from ...

SQLCA.DBMS = "ODB" // to ....

SQLCA.DBMS = "MSO"

Then run your App from the PB IDE and see if the SP issue is resolved.

Regards .. Chris

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 13 September 2023 21:19 PM UTC
  2. PowerBuilder
  3. # 2

Hi Albert;

  Since you are using ODBC .. then you can start the ODBC Admin utility on the machine in question. In the ODBC Admin you can actually test the SS connectivity from there. If that does not work, then the ODBC layer (aka DSN) would be your problem & not your App. Also, the ODBC is bit sensitive. So make sure that the DSN is of the same bitness as your App's EXE.  HTH

Regards ... Chris

Comment
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.