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
- You are here:
-
Home
-
Q&A
-
Q&A
-
PowerBuilder
- sql connective way in powerbuilder
-
william yau
- PowerBuilder
- Friday, 9 July 2021 05:48 AM UTC
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
- Page :
- 1
There are no replies made for this question yet.
However, you are not allowed to reply to this question.
However, you are not allowed to reply to this question.
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.