1. Kwadwo Boahene
  2. PowerBuilder
  3. Wednesday, 09 May 2018

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

Miguel Leeuwe Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 11 May 2018
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Wednesday, 9 May 2018
  2. PowerBuilder
  3. # 2
  • Page :
  • 1


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