Discussions tagged SQL Server
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...
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...
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...
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...
Hi Experts,
******************************************************************
Database Versions: Microsoft SQL Server 2014/Microsoft SQL Server 2019
******************************************************************
I have upgraded my existing ...
Hello,is anyone using Azure managed databases (PaaS) with PowerBuilder or PowerServer applications?
Which database product do you use exactly?
Would love if anyone could share their experiences, use cases and opinions on suitability for production ...
Hi,
what are the plans for supporting MS SQL Server 2022 and Versions of the MSOLEDBSQL19 newer 19.0.0?
According to the PB Help only MS SQL Server Versions up to 2019 are supported and only the MSOLEDBSQL19 Driver Version 19.0.0 is supported.
...
MultiSubnetFailover is ignored when added to DBParm string.
We are trying to connect PowerBuilder 2021 application running on AppStream to AWS sql server - SQL 2016.
Roughly doing:
DBMS=MSO
SQLCA.DBParm = ls_dbparm + ",MultiSubnetFailover=true"
...
Hello
We use SQL server, DB. I installed Powerbuilder 2022, but there was some glitch during installation and the example database was not installed.
I want to run the Google Charts demo locally against a SQL Server DB.
Is a sample database for ...
Hi all, have a happy new year!
I could not find another way to post an enhancement request for future PB versions, so I'll leave it here. If there is a better way to do so, please let me know.
We develop and maintain a quite large c/s application (...
Our applications use Dynamic SQL Type 4 to execute SQL server select statements and stored procedures which return a single row.
We use Dynamic SQL Type 4 as we have a user object that executes the SQL and does all the necessary checking. It return...
Hi all ,
I am running a c/s app on the client pc ( pb 2017r3 win10/11 ) .
The app connecting directly to a MSSql db located on a remote server over the Internet.
I am using SNC SQL Native Client(OLE DB) / MSOLEDBSQL in my SQLCA.DBParm .
My ...
Does the .Net DataStore product support generating a C# .Net DataStore API service from a SQL Server View DataWindow Object DataSource that will update the SQL Server View?...
Hi all,
we were checking our databases using the various sp_Blitz procedures (First Responder Kit) and we discovered something we had hints before:
SELECT statements produced by our PowerBuilder (2017 using SNC) application's datawindows create lot...
Hi all,
this is a shot in the dark...
I have installed sp_BlitzFirst to a customer of ours in order to get some metrics and check on performance on his SQL Server.
They are running SQL Server 2019 and their databases are on compatibility level 120...
Hi,
our PB 2017 application cannot connect to SQL Server database via SNC when the machine's TLS is 1.3.
We recompiled the application using PB 2021 and it still cannot connect.
What changes are required in order for a PB application to work/conne...
Hi Appeon,
I would like to know if Powersever 2020 build 2703 has an issue with connecting with MS SQL 2019?
I have published an application but needs ms sql 2019 for database but I cant connect as powerserver reports:
The same sql ...
We are in the process of migration from PB09 to PB21.
PB09 app is using .ini with following :
DBMS=MSS Microsoft SQL Server 2016
ServerName=XXXXXXXDatabase=DDDDDDBParm=Secure=1AutoCommit=true
UserID=USERPassword=USER
How do I need to change app ...
I have a client with about 10 or so 'super' users who often work remotely. When they need to use the application (PB 2021), they RDP into a Windows 2019 Server desktop, launch the app that is deployed there and go about their daily work. The applic...
- Page :
- 1