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
Comment
- Armeen Mazda @Appeon
- Friday, 9 July 2021 07:26 AM UTC
https://docs.appeon.com/pb2019r3/whats_new/MS_SQL_Server_enhancements.html
There are no comments made yet.
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
- Sivaprakash BKR
- 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.
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.
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.
However, you are not allowed to reply to this question.