cancel
Showing results for 
Search instead for 
Did you mean: 

What is the best way to connect a 64-bit Powerbuilder app to SQL-Server?

0 Kudos

Hi everyone!

What is the best way to connect a 64-bit Powerbuilder app to SQL-Server?

I have a 32-bit app which uses PBOLE126.DLL, as far as i know there's no 64-bit equivalent to this .dll file. I need to make it an 64-bit app because it requires more than 4Gb memory. I only need the solution to support SQL-Server.

If possible I want to minimize the dependencies of additional installations, such as SQL-management etc

Accepted Solutions (1)

Accepted Solutions (1)

luisdarui
Active Contributor
0 Kudos

Hi Martin,

Can you connect with your PowerBuilder application through ODBC? You can create a DSN for SQL Server and access it through ODBC 32-bits.

Once you install the SQL Server Native Client or ODBC Driver 11 or 13 for SQL Server, you have the option to add a data source from SQL Server.

0 Kudos

Yes, that's the same conclusion I got to.

I noticed PBODB126.DLL (which is the ODBC dll), and everything went very smooth.

dbparm = "ConnectString='Driver={ODBC Driver 13 for SQL Server};QuotedId=No;TrustServerCertificate=Yes;Encrypt=Yes;UID="+uid+";PWD="+pwd+";SERVER=" + servername + ";Database="+database+";'"

Answers (0)