Discussions tagged SQL Server

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...
Hello, I'm working in one of our customer's office, with a Powerbuilder 2019 R3 connected to a SQL Server 2016 database. When I try to modify the Update Properties of a datawindow after adding a new column, it says that the table cannot be found. An...
Hi All. We've noticed that the query below, that appears in the pdobd.ini file (both in PB17 and PB21) SelectDefault='select y.name, x.text from syscomments x, syscolumns y where x.id = y.cdefault and y.id = OBJECT_ID(''&TableOwner.&TableNa...
Hi Appeon, I am doing the migration from SQL Anywhere to MS SQL Server Database  PB2019R3 Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) when I run the application and try to save the changes from the screen I am getting the below error    ...
Hi, How to encrypt (TLS 1.1 or 1.2) Database connection from PowerBuilder application? PB Version: 2017R3 SQL Client: SQL Native Client (sqlncli11) DB Server : MS SQL SERVER 2016 If it is not supported in PB2017, Please let me know whether is it...
I've deployed a PB application to PowerServer 2021.  The application uses SQL Server for the backend database and is hosted on a remote AWS web server running IIS.  The deployment process went fine and I can launch the app w/o issue using the CAL.   ...
I am getting a datawindow error when retrieving a datawindow that is part of a tab page on a window.  See attached image to view the error.  The database is SQL Server and the application has been been deployed to PowerServer 2021.  The datawindow ha...
Hi I have a desktop application developed in PB2017 R3. It is connecting to the MS SQL database thru ODBC with connection string as below: SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = TrueSQLCA.DBParm = "ConnectString='DSN=dsn_name;UID=xyz;PWD=abc',Commi...
I am having issues running a lightweight PB application called CRH that has been deployed to a remote Amazon AWS server.  The app was built with PB 2021 build 1288 and uses SQL Server for the database.  The deployment goes fine and I can download and...
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 ...
Hi All, I have a Stored procedure in SQL Server 2019 which is using TRY CATCH for error handling instead of "RAISERROR" but this is not throwing a response back when SP is called from PowerBuilder using "Stored Procedure Update" functionality.  If ...
Just posting some advice in case someone else stumbles onto an issue like this. The SQLSTATE = 42000 a catch all basin for everything under the sun from Microsoft can lead you in circles. Here's another gotcha. When using a PB 2019 R3 application w...
Hi, I'm testing PB & Power Server 2021 with MS SQL Server 2019 Express. Both Windows and SQL server authentication are enabled. I have some odd behaviour and problems while connecting my database from PowerServer (from PB both authentication me...
Hi, Good morning. Is there a way to create a Datawindow with this statement. It really doesn't care if it's embebbed or not. DB: Sql Server IDE: PB 2019 R3   I'm doing this because the crosstab which do this, doesn't work and I'm looking for way...
  • Page :
  • 1