Issue: Extremely slow query performance using ADO.NET connection to a SQL Server 2016 database using Appeon PB v2019 b2082.
Querying ~700 rows from SQL Server 2016 DB into a grid datawindow which is taking approx 2-3 minutes to complete (from compil...
I have an application that has been successfully migrated to PB 2017 R2.
When I execute the application via the IDE I have no issues, I am able to navigate - pull data and even insert into new content.
I am successful in deploying the complete appl...
I have approached this issue in the past without success. I am hoping that I can provide A LOT more information and someone can point me in the right direction.
I have a client/server application that has been upgraded to PowerBuilder 2017. I am wan...
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.
Regarding parameter PBMaxTextSize: field NVARCHA...
I try to connect to informix server from ws deployed on IIS and sqlerror is Transaction Not Connected.
When i try to create connection from app everything is ok.
Params in transaction is the same.IIS install on the local machine.
Where is the prob...
When i connect to SQL Server 2017 i'm not able to set the Application Name.
Currently the "sp_who2" says ".Net SqlClient Data Provider"
I tried to set DBParm to
"Application Name=Client" / "App='Client'" / "ApplicationName...
Hi Guys & Gals
I'm deploying to a brand new windows machine a pb2017r2 exe using ADO.NET.
Dot Net 4.5 is installed
I have run the msi installer generated by the package installer and copied over my exe and I'm getting the following e...
Hi there,I used to use Powerbuilder 12.5 classic ,I'm trying to use PB 2017,I have 2 questions
#1 How do I connect to a SQL Server with ADO.NET within Powerbuilder 2017,cuz 64 bits application is no more support OLE DB connection within ...
Right now, our application is set up to connect to the SQL Anywhere 16 database via ODBC (defined in System DSN).
However, I've been thinking about using ADO.net instead.
But is there any better performance in using ADO.net inst...
I am trying to connect to Ms sql database with ADO.net driver ( the app is pb 2017 version , on windows 10 , 64 bit .)
I did put all the needed dll files with the exe file directory ( and i tried with installing the msi file cre...