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 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 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...

Hi all my fellow PB entusiasts  :-)   What PowerBuilder database interface (oledb,odbc, etc..) do you recommend to use to connect realiably to SQL Server  from a classic windows PowerBuilder application. I'm running up to 50 instances of the same ...