Skip to Content
0

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

Mar 22, 2017 at 10:42 AM

99

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Luis Darui
Mar 22, 2017 at 03:26 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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+";'"
0