Discussions tagged ADO.NET

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