1. william yau
  2. PowerBuilder
  3. Friday, 9 July 2021 05:48 AM UTC

HI guru

 

do you know what is best connective way connect sql server 2016 using powerbuilder 2019 r3 

 

(1) SNC

(2) odbc

(3) OLE DB

 

is sql server 2016 not support snc ?

 

William 

william yau Accepted Answer Pending Moderation
  1. Friday, 9 July 2021 10:36 AM UTC
  2. PowerBuilder
  3. # 1

ne more information
I choose this two connection
QLSYS.DBParm = "PROVIDER='SQLNCLI11',DATASOURCE='" + SQLSYS.ServerName +"',PROVIDERSTRING='database=" + SQLSYS.DataBase + "'"
SQLSYS.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='" + SQLSYS.ServerName +"',PROVIDERSTRING='database=" + SQLSYS.DataBase + "'"
still shows following error in embedding sql

Comment
  1. Sivaprakash BKR
  2. Friday, 9 July 2021 11:41 AM UTC
Try

SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='computername\instancename',PBMaxBlobSize='100000',PBMaxTextSize='100000',PROVIDERSTRING='Database=database'"



Or



SQLCA.DBMS="SNC SQL Native Client(OLE DB)"

SQLCA.Database=database

SQLCA.LogId=sa

SQLCA.LogPassword=pass

SQLCA.AUTOCOMMIT=True

SQLCA.Lock="RC"

SQLCA.DBParm = "Database='database',Provider='SQLNCLI10'"



Both works for me.
  1. Helpful
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Friday, 9 July 2021 07:23 AM UTC
  2. PowerBuilder
  3. # 2

Hello,

PB 2019 R3 got MSOLEDBSQL driver, which is better IMO.

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.