Discussions tagged SQL Server

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...
Hello , we have applications written in PB 12.5 with SQl 2008R2 Databases. We want to udgrade to SQl 2012 and then to 2016 or 2017.  Which version of PB is compatible with this version of Sql ?...
Hello, We have discovered the following: using SNC (SQL Native Client, provider SQLNCLI11 of course), so when a table has datetime column in primary key and database compatibility level is set to, for example, 130 (SQL Server 2016), datawindow based...
We have a PB 2019 R2 application connecting to a SQL Server 2016 database using the old SQL Server driver (sqlsrv32.dll).  The OS is Windows 10 Enterprise.  The connection is scripted as follows:   SQLCA.DBMS = lsODBCTrace + "ODBC"SQLCA.LogId = ls_...
We have an intermittent issue where an alternate character set displays in a menu that is built dynamically.  The application is using PB 2019 R2 build 2353 and we connecting to a SQL Server 2016 database using SQL Server  Native Client.  When the ap...
Hi. I have struggled with getting the SQLCA properties set up correct to be able to have my users connect to data base with single sign-on/trusted connection. I'm on MS SQL Server. The problem boiled down to using correct value for SQLCA.DBMS. Than...
  • Page :
  • 1