Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 22, 2017 at 03:26 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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