03-22-2017 10:42 AM - edited 02-03-2024 10:08 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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+";'"
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.