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

Resolved Connecting to DB2 using SSL

  1. Issue
0
Votes
Undo
  1. Kwadwo Boahene
    Kwadwo Boahene
  2. PowerBuilder
  3. Wednesday, 9 May 2018 15:11 PM UTC

Hi ALL,

          How do i connect to DB2 using SSL in Powerbuilder 2017 (1769)? Currently I connect to DB2 using this connection string ==>SQLCA.DBParm = "Connectstring='DSN=xxxxx;UID=yyyyy;PWD="+ls_pwd+"'"+",CommitOnDisconnect='No',Date=' \''yyyy-mm-dd\'' ',DateTime=' \''yyyy-mm-dd-hh.mm.ss.ffffff\'' ',Time=' \''hh:mm:ss\'' ',PacketSize=38000,Async=1"

 

the xxxx is the databasename and UID is the userid and ls_pwd is the password. This has been working from PB6 through 17 and now I am being told to connect using SSL - change of company policy. How is done?

 

KB

Can not use Source control
PSR files from PB 10 to Appeon infomaker
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 9 May 2018 15:28 PM UTC
  2. PowerBuilder
  3. # 1

Hi Kiwado;

     SSL support is all part of the ODBC realm and not PB`s.

The SSL setup is outlined by this MSDN post.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 11 May 2018 10:27 AM UTC
  2. PowerBuilder
  3. # 2

I might be wrong, but I don't think it will be possible to specify ssl attributes in an ODBC connection.

You can download a PB 12.5 dbparm connection guide here: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc33820.1250/pdf/dbparm.pdf   It's old, but might help you on the right path. If anyone knows of a more recent version that info would be welcome.

Take a look at connecting to DB2 using JDBC or "native driver" (if powerbulder supports that one, the native driver would be best).

(we use a Tibero database, which is not supported by Appeon and cannot use SSL in an ODBC connection. We have to use JDBC in which we specify protocol=TCPS instead of the default protocol=TCP. It works great (once you've figured out the connection string).

An example of our Tibero dbparm connection string: 

PBCatalogOwner='CREDIT',Driver='com.tmax.tibero.jdbc.TbDriver',URL='jdbc:tibero:thin:@(description=(protocol=tcps)(address=(host=RX-DEV-0X)(port=1234))(DATABASE_NAME=my_database))',PBNewSPInvocation='Yes',DisableBind=1,DelimitIdentifier='No',TrimSpaces='No'

NOTE:

the "(address= .... " is normally only necessary for specifying a list of clustered hosts. We don't have a clustered database, but we still had to use it to be able to specify the "protocol" parameter.

 

HIH

MiguelL

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.