Discussions tagged SQL Server

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...
Hello, PB 11.5, SQL Server 2012 Express, Windows Server 2012 R2 (in server) and Windows 7 (in clients)Also SQL Server 2000 is there to view old data. Every day at a particular time (between 3.00 to 3.30 pm), Powerbuilder application gets disconnect...
I'm using SnapDevelop 2019R3 Build 2703. I cannot connect to MS SQL Server. I get network connectivity error and a timeout. I can connect to the same database using PB IDE on the same Wind 10 PC. I've checked that required protocols are enabled o nt...
I have an application that I upgraded from Powerbuilder 8.0 to 2019 R3. We also upgraded from Sql Server 2008 to Sql Server 2019. I have noticed that when a datawindow has a db column with a checkbox style top and the column is type Bit, the value d...
I select a field declared as nvarchar(nmax) from a table in sqlserver using an odbc connection (even with a native driver). The result from the select is truncated if the value in the column has more then 32676 character. I use Power Builder 2019R2. ...
Good morning, I got a problem with some of my crosstabs datawindows, when i do a retrieve my crosstab starts blinking and after that the application automatically close. If somebody can help me with this issue.    Do you know what is happening ? ...
Hi Folks, My application is on PB 2017 R2 and its running on windows server 2012 R2 OS. Application is connecting with local DB which is in SQL anywhere and remote database which is in SQL server. This application is basically fetching the files fr...
Hi;     I recently modified an Infomaker form (using 2019 r2) to connect to a SQL Server database rather than Oracle. The form is used so people can add new users to roles. I am assuming it was made in the one-to-many type because it is supposed t...
Dear PowerBuider Programmers, this might emerge as a philosophical question, but I still hope to get some answers: PowerBuilder allows many different ways to access Microsoft SQL Server databases from classic (client/server) PB windows applications...
  • Page :
  • 1