We have a SQL Server procedure with 20K lines of code. We will execute the procedure 18 times and syntax is  created dynamically from PowerBuilder. Attached the dynamic query. If the query is executed from SSMS there is no issue, it is inserting int...

Not a question...  If you are converting from SQL Anywhere to SQL Server, be aware that Powerbuilder and SQL Server don't communicate dates well. If you have a date parameter you are passing in SQL, embedded or in a datawindow/datastore like so:  ...

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 trying to improve the performance of our application, we have a couples of Embedded SQLs and Datawindow retrieves called one after another. so to improve the performance, we moved all the SQL DB calls in a PowerServerLabel Merge statement whi...

I am trying to save a datawindow definition to SQL Server Varchar(Max) column, using UPDATEBLOB and the command runs without error, but the data saved is severely truncated. Using ODBC, SQL Server 2022, and PB 2022 R3 Build 3356. lblb_DWSyntax = Blo...

  I'm using SQL SERVER 2014 I nead Ignore this error . GROUP BY with Aggregate Functions SLQSTAT = 42000 My problem is while executing this query select empId, empName, empstate, sum(empsalary)from emp group by empId, empName ; Result : COLUMN em...

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

Using SQL Server and Powerbuilder 2022 R2 build 2819, I found another bug: If I have the following: decimal ldec_valuelong ll_id ll_id = 1 ldec_value = 7.99 UPDATE my_table      SET my_old_price = CASE WHEN :ldec_value <> my_old_price then...

I have a stored procedure in SQL Server: CREATE PROCEDURE [GROUP1].[test_return]( @OUTVALUE integer OUT ) AS begin      SET @OUTVALUE = 999999;     RETURN end In Powerbuilder, I've set up a DECLARE and EXECUTE statement: long ll_result DECLARE te...

Hi there,Currently we use ODBC to connect to SQL Server 2019/2022, but we want the best possible performance and as such we're looking for the best practice in this regard. We're using Powerbuilder Version 2022, Build 1878. Thank you in advance for...

Hi   pb 2022r3 win10 sql 15 All, still trying to connect to a sql server rather than my normal SQL Anywhere.   I am trying to save a PB datetime field back to the SQL server database and I am getting an error SQLSTATE = 22007Microsoft SQL Serve...

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

Sql Server 2019  PowerBuilder 2019 R3 build 2728 I'm using ODBC connection  I have a datastore, I change data and then do an update lds_post_dates.setitem(i, "column_name", ll_value)ll_rv = lds_post_dates.update()   The base table for the datas...

Hello!I have the problem that I have to call the MS SQL Server stored procedure sp_set_session_context to set a context variable. Unfortunately this does not work with the PowerServer. The PowerServer always gives me the message 'PowerServer.Api.Se...

Hi, We have a standalone PB2019 application which is hosted in Citrx and uses the SQL Authentication. But now we want to use the windows authentication using a functional ID (BOX id) but this can't be achieved using SQL Native Client. Could any on...