Discussions tagged ADO.NET
Unable to get ADO connection working using Access Token, please help.
- New
- How-to
- Last updated 21 hours ago
- Jostein Ullestad replied 16 hours ago
Hi
We face an issue related to ADO database connection and are seeking help resolving it.
PowerBuilder: 2022 R3 Build 3391
Visual Studio: 2022
DBMS: Microsoft Azure
In short, the issue is that any SQL command fails with SQLCode -1 and no SQL ...
DB Connection in 2022 R3 blocked by Norton 360
- Resolved
- Issue
- Last updated 2 months ago
- mike S replied 2 months ago
I am having a very serious issue with Norton 360 Data Protector blocking the latest build of my PowerBuilder 2022 R3 application executable file. I have turned off the Data Protector, I disabled Norton Auto-Protect and Smart Firewall, to no avail.
I...
Platforms: SQL Server 2022/PB 2022 32bit apps
We are considering a new attempt to upgrade from PB 2022 to R3, having abandoned the previous attempt to upgrade to R2, due to the hassle with .NET Desktop Runtime 6.0 on the client side. There are hund...
Stored procedure parameter by reference returns 0 instead of null
- Issue
- Last updated 4 months ago
- Erwin Anema replied 4 months ago
Hi all,
While upgrading a legacy application from PB17R3 to PB2022R3 I run into a reproducible issue with calling an MSSQL stored procedure which has an integer output parameter.The issue is that when the proc's output parameter is null, PB17R3 corr...
QUESTION: With the recent PowerBuilder 2022 R2 update of ADO.NET, is PowerBuilder now enforcing rules that were not previously enforced?
What is described below WAS NOT a problem with PowerBuilder 2022 R1...but with the release of PowerBuilder 2...
ADO.NET with 2022 R2 fails in deployment
- Resolved
- Issue
- Last updated 1 year ago
- Sverre Tvedt replied 1 year ago
Hi folks
I have upgraded to 2022 R2 and am testing deployment of our appliications using the latest runtime in IDE AND in the projects.Windows 10/64bit & 32 bit IDE/project I try to connect to MS SQL Server (2014)using the following transact...
Sybase.PowerBuilder.DataSource.Sharing.dll omitted - why ?
- Issue
- Last updated 2 years ago
- Chris Pollach @Appeon replied 2 years ago
Hi PowerSphere
Is there a reason the Sybase.PowerBuilder.DataSource.Sharing.dll is omitted when selecting the ADO.NET(ADO) database interface in the PowerBuilder Runtime Packager PB2021 1509?
Regards
Georgios...
Hi,
I just migrated my PB10.5 application to PB2021. Everything seems to be running great on the development machine including the database connection.
When I tried on a client machine, I realized that I needed to install VC++ 2010 runtime, which ...
Transaction ADO.NET Provider String
- Resolved
- How-to
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
Dear Team,
We are working on using Transaction for ADO.NET to connect Sybase database.
Could you guide us how to set up the DBParam for connection maximum number for Sybase?
ProviderString='value'The MaxConnect don't support ADO.NET with below...
Tableblob not working when MultipleActiveResultSets=FALSE
- Resolved
- Issue
- Last updated 3 years ago
- Brad Howie replied 3 years ago
I support a mature application using PowerBuilder 2017 R3 and SQL Server via ADO.Net.
Our user community recently requested we add signatures onto some of our datawindow documents. The 'tableblob' datawindow object seems perfect for this, but unfor...
MSSQL temporary tables (#) creation (AZURE) from Powerbuilder Web
- Misc
- Last updated 3 years ago
- Pierre Rene replied 3 years ago
Hi there,
Powerbuilder 12.5 classic application has no issues creating temporary tables in an Azure MSSQL database (account dbo user) but for some unknown reason... a deployed web application from PB 12.5 using the same connection parameters (user n...
Slow query performance using ADO.NET and SQL Server 2016
- Issue
- Last updated 4 years ago
- Miguel Leeuwe replied 4 years ago
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...
Why is there a different experience between the IDE and EXE?
- Advice
- Last updated 5 years ago
- Chris Pollach @Appeon replied 5 years ago
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...
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...
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...
ADO.NET - not able to set Application NAme
- Resolved
- How-to
- Last updated 5 years ago
- Georgios Papageorgiou replied 5 years ago
Hi Powersphere
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...
How do I connect to a SQL Server in Powerbuilder 2017 with ADO.NET?
- Issue
- Last updated 6 years ago
- Ken Guo @Appeon replied 6 years ago
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 ...
Hi.
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...
- Page :
- 1