Discussions tagged OLEDB
1) My PowerBuilderapplication crashing whenever user leaves it idle for sometime, this started happening after SQL Transaction object DBMS changed from MSS to MS Native Client, what could be the reason?2) Which is the preferred connecivity for PowerB...
Hi Team,
Thank you in advance for your help on this. We have migrated PowerBuilder Windows application from PB 2017 to PB 2022 R3. We made this migration to enable application to use tls 1.2. We are connecting windows application to Microsoft SQL Se...
Error "DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
- How-to
- Last updated 6 months ago
- Chris Pollach @Appeon replied 6 months ago
We are attempting to transition from ODBC to MSOLEDBSQL Version 19.3.3, but when we try to connect our Transaction, we get the error in the title of this post:
"DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
This is from ...
PB 2022 connectivity error with SQLOLEDB
- Resolved
- How-to
- Last updated 1 year ago
- Roland Smith replied 1 year ago
Hi Experts,
******************************************************************
Database Versions: Microsoft SQL Server 2014/Microsoft SQL Server 2019
******************************************************************
I have upgraded my existing ...
Hi Appeon,
I am doing the migration from SQL Anywhere to MS SQL Server Database
PB2019R3
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
when I run the application and try to save the changes from the screen I am getting the below error
...
Hi Folks,
My application is on PB 2017 R2 and its running on windows server 2012 R2 OS. Application is connecting with local DB which is in SQL anywhere and remote database which is in SQL server.
This application is basically fetching the files fr...
MS OLE DB driver - deploying connection strings
- How-to
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
We've been using the old SQL Server ODBC driver (SQLSRV32) for a long, long time now, and now it's finally time to update to a new driver. We originally looked at replacing it with the ODBC Driver 17 and that seems to work well and supports all the m...
Comparison of methods accessing SQL Server from PowerBuilder
- Advice
- Last updated 3 years ago
- Roland Mühlberger replied 3 years ago
Dear PowerBuider Programmers,
this might emerge as a philosophical question, but I still hope to get some answers:
PowerBuilder allows many different ways to access Microsoft SQL Server databases from classic (client/server) PB windows applications...
highest version of MS SQL Server officially supported by PB 2019
- Resolved
- Issue
- Last updated 4 years ago
- Michael Kramer replied 4 years ago
Which highest version of MS SQL Server is officially supported by PB 2019 / PB 2019 R2?
Anyone use PB 2019 with SQL 2019 ? (which driver do you use ~ OLE DB / Native driver ?)
Thanks
...
Information Required [ Appeon PowerBuilder 2019 Datatype Blob ]
- How-to
- Last updated 4 years ago
- Michael Kramer replied 4 years ago
I am working on some of features available in Appeon (PowerBuilder 2019) for upgrading from the old version. I need some information/help for the following topics
Converting Blob into string
I am encrypting the plain text using “SymmetricEncryp...
Powerbuilder 2019 - MS SQL Server - DB Error - SPs not returning values
- Resolved
- Advice
- Last updated 4 years ago
- John J replied 4 years ago
Hi All,
I'm trialing PowerBuilder 2019 to upgrade an existing application currently on PB9. Did an auto upgrade using PB2019 and everything compiled well. Modified the code block to connect to MS SQL 2014 DB using OLE DB (I assume thats the best cho...
Powerbuilder 2017/R3 SQL-Server NVARCHAR(max) cut after 32766 characters
- Resolved
- Issue
- Last updated 5 years ago
- Andreas Steinhauser replied 5 years ago
Hi,
currently we are using Powerbuilder 2017/R3 Build 1858 in connection with SQL-Server (2005 - 2017)! We defined a field with NVARCHAR(MAX) in a table. We try to select this field.
SQLNCLI9/10/11:
Regarding parameter PBMaxTextSize: field NVARCHA...
Power builder Classic and TLS 1.2 How to ?
- How-to
- Last updated 5 years ago
- Chris Pollach @Appeon replied 5 years ago
Our Enter Price Users Power builder 2017 only the classic Power builder. We have to disable TLS 1.0 and TLS 1.1 on the servers that host our SQL server data base. We are facing issues with as we are using SQLOLEDB connection.
I came to know from v...
SQL Syntax Error With OleDatabaseBlob Control
- How-to
- Last updated 5 years ago
- Shenn Sellers replied 5 years ago
PB 2017 R3 is generating an SQL Syntax Error at run time when trying to retrieve a blob column in a data window. I'm using MySQL 5.7.24. The message is a sqlstate = 37000, 1064. The partial syntax is: "You have an error in your SQL...near ': blob...
How to make 64-bit application use OLE DB successfully?
- Issue
- Last updated 5 years ago
- Roland Smith replied 5 years ago
I have migrated code from PB 10.5 to PB 2017R3, and the migration went fine - no errors. Now I am building the code as a 64-bit pCode application, and the build is fine, but when I do a database connection in the app (using OLE DB), I get a message...
64 bits executable and accessing Excel data
- Resolved
- Issue
- Last updated 7 years ago
- Chris Pollach @Appeon replied 7 years ago
My application is developed in PB 12.5 and migrated successfully to PB 2017. However there is a functionality to upload Excel files into a SQL Server DB. The code is :
ltr_excel = CREATE TRANSACTION
ltr_excel.DBMS = "OLE DB"
ltr_excel.Aut...
- Page :
- 1