Discussions tagged SQL Server
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 - Row changed between retrieve and update
- Advice
- Last updated 2 weeks ago
- mike S replied 2 weeks ago
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...
pb2022 r3 datawindow insert and update
- Resolved
- How-to
- Last updated 1 month ago
- Andrew Davis replied 1 month ago
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...
Failed to parse the statement sp_set_session_context
- How-to
- Last updated 1 month ago
- Alex Peters replied 1 month ago
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...
Connection is busy with results for another command
- Resolved
- Issue
- Last updated 2 months ago
- Tim Bruce replied 2 months ago
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"...
How to achieve windows authentication for functional ID for SQL Server in Standalone PB2019 Application?
- How-to
- Last updated 3 months ago
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...
Why do I keep getting a DB error on an Insert statement?
- Resolved
- Advice
- Last updated 5 months ago
- Brage Mogstad replied 5 months ago
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...
Migrating from SAP ASE -> MS SQL, which DB driver to choose from?
- Resolved
- Advice
- Last updated 5 months ago
- Trevor Holyoak replied 3 months ago
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 with SQL Server db query slow
- Resolved
- Advice
- Last updated 6 months ago
- Miguel Leeuwe replied 6 months ago
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...
Connectivity issue PBApp Driver SQL Native Client 11.0
- Issue
- Last updated 7 months ago
- Sivaprakash BKR replied 7 months ago
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...
POWERBUILDER 2019 SQL SERVER 2019 PROCEDURE ERROR 999
- Resolved
- Misc
- Last updated 8 months ago
- Luiz Marques replied 8 months ago
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...
Can't connect local SQL server 2019 Express
- Resolved
- Issue
- Last updated 8 months ago
- Chris Pollach @Appeon replied 8 months ago
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...
Cast as XML sql stmt crashes IDE
- Resolved
- Advice
- Last updated 9 months ago
- Tim Bruce replied 9 months ago
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...
Cannot retrieve stored procedure result set #2 in Powerbuilder report
- Issue
- Last updated 9 months ago
- Chris Pollach @Appeon replied 9 months ago
Hi,
In Powerbuilder 2022, I have a report fetching data from a MS SQL stored procedure returning two result sets. This works fine when connected to a SAP ASE database, but after migrating to MS SQL, it looks like only the first result set from the p...
PowerServer C# Project DBConnectionProfile DBPARM values
- Resolved
- How-to
- Last updated 9 months ago
- Jim Nesbitt replied 9 months ago
I'm converting a Powerbuilder application to PowerServer so it can operate using the SaaS model.
I've been following the guidelines in this video.
Creating a SAAS Application with PowerServer 2022
https://www.youtube.com/watch?v=a5U4XblFJbA&ab...
MSOLEDBSQL19 - Cannot create new connection
- Resolved
- Advice
- Last updated 10 months ago
- Brett Weaver replied 10 months ago
Hi There
I have been using the new MSOLEDBSQL19 to attach to sql server. I have come across an annoying limitation. My application allows users to define new parts of a document by instantiating a tab page which has a datawindow on it. These pages n...
Hello,
I've been playing with the PS Server Management Console and noted this under SQL performance:
CacheName:LB_KFxxxx, Test Sql:select top 1 * from sysobjects, Time Consuming(ms):22, Expect time-consuming(ms):30
CacheName:LB_Rexxx, Test Sql:s...
Demo database ODBC not showing in connections list
- Issue
- Last updated 11 months ago
- Miguel Leeuwe replied 7 months ago
Like the title says, I'm having a problem with the tutorial where I started with all the demo files except for the database file as far as I could see. Either that, or when trying to connect to the ODB ODBC Database Profile PB SQLServer V2022 it just...
how can i get max code with out duplicate for saving at the same second
- How-to
- Last updated 1 year ago
- mike S replied 1 year ago
iam working with pb11.5
iam creating invoicing application
i want to get max code in header table
ihave a problem when multi pcs save the invoice at the same second the two invoices take same Code
how can i resolve this this there is another w...
PB 2022 connectivity error with SQLOLEDB
- Resolved
- How-to
- Last updated 1 year ago
- Roland Smith replied 1 year ago
Hi Experts,
******************************************************************
Database Versions: Microsoft SQL Server 2014/Microsoft SQL Server 2019
******************************************************************
I have upgraded my existing ...
- Page :
- 1