Connection String to Connect to SQL Server from PowerBuilder

There are multiple ways that we connect to SQL Server from Appeon PowerBuilder.Below will explain the ways in which we connect to SQL Server.

1/ ODBC

This way you can use the default SQL Server Driver that comes with the windows machine

[PBAPP] DBMS=ODBC DBParm="ConnectString='DRIVER={SQL Server};SERVER=;DATABASE=;PORT=1435;PROTOCOL=TCPIP;UID=;PWD=';PBNewSPInvocation=YES,CallEscape=NO"

2/ SQL Native Client

For using this you should have SQL Native client installed in your machine. This method supports till PB2017 and SQL Server 2019. For versions above PB2017, you much use the SQL OLEDB provider of 18.6 version or above.

[PBAPP] DBMS=SNC ServerName= Database= LogId= Logpass= DbParm='Database=,TrimSpaces=1,DBTextLimit=10000,DelimitIdentifier=1,PacketSize=8192,disablebind =1,staticbind=0,Host='

3/ SQL OLEDB Provider

Download path - Download Microsoft OLE DB Driver for SQL Server - OLE DB Driver for SQL Server | Microsoft Learn

[PBAPP] DBMS=MSOLEDBSQL SQL Server Database= ServerName= LogId= LogPass= DbParm=TrimSpaces=1,DBTextLimit='10000',DelimitIdentifier=1,PacketSize=8192,Database= Prompt=0