Discussions tagged SQL Server
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...
Hi all
PB 2022 R3 Windows 10 SQL Express 15
I have always used SQL Anywhere for my database however I have a new project that requires me to connect to a SQL server database
Can you confirm what i am getting is normal - i thought you could just co...
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...
Hi
I hope someone can help, I am having a weird error - with the simplest of datawindows and programmes
I have just installed pb2022 R3 - on windows 10
I have it connected to SQLexpress database - v14.
I have a very very simple 2 column table...
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...
Sql Server 2019
PowerBuilder 2019 R3 build 2728
app.ini connection (server X'd out)
DBMS="ODBC"DBParm = "ConnectString='DSN=XXXXX',ConnectOption='SQL_INTEGRATED_SECURITY,SQL_IS_ON', MsgTerse='Yes',DisableBind=1,DelimitIdentifier='No',TrimSpaces=1"...
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...
Hi all,
I'm trying to create a revision to form. The dw object and control are identical... I'm just changing a couple of values and changing the row status to NewModified! to force an INSERT instead of an UPDATE.
// Create new Workorder
ll_New...
Hi,
After developing for more than 25 years on a Sybase (SAP ASE) database, we are migrating to MS SQL. We are using the native ASE interface for our database connection. We have some large Powerbuilder applications that rely heavily on this databas...
PowerBuilder version: 2019 R3 Build 2779
SQL Server 2019
ODBC Driver 17 for Sql Server
I have a query that returns 109 rows in 2 seconds in Management Studio but takes upwards of 30 seconds in db painted within Powerbuilder. Are there any setting...
Hi everyone!
I currently have a issue when mi PB app is communicating with driver SQL Native Client v11.0, when try to make the connection I received the following message:SQLSTATE = 1S00Microsoft SQL Server Native Client 11.0Invalid connection s...
Good Afternoon,
I have done a PowerBuilder 2019 R3 migration for a client. I was using the DBMS=SNC SQL Native Client(OLE DB) and everything was working fine. The client decided to move to SQL server 2019. They use a lot of configurati...
Hi,
I have installed PB 2022 R2 and MS SQL Server 2019 to a Windows 2019 server on Azure.
While installing PB I could not connect to SQL server to install demo database.
Now same problem when I try to create Power Server Project.
From PB IDE I ca...
PowerBuilder version: 2019 R3 Build 2779
SQL Server 2019
ODBC Driver 17 for Sql Server
Can you cast to XML in PowerBuilder? This stmt crashes the IDE. txt is a varchar(max)
SELECT cast(txt as xml) into :ls_string from documents where doc_id = 1...
- Page :
- 1