MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Connection String to Connect to SQL Server from PowerBuilder

Published on 29 May 24
0
0

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
This blog is listed under Data & Information Management Community

Related Posts:

Powerbuilder Developer

 

PowerBuilderSQL

 

MS SQL

 

MS SQL PowerBuilder

 
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url