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...
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 ...
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...
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...
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...
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
...
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...
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...
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...
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...
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...
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...
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