Discussions tagged SQL Server

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...
It used to be that you could put "TRACE SNC" into the DBMS field in an ini file, and that would work to start a trace going when the application was launched.  However, when I do that in PB 2019, I get "DBMS TRACE SNC is not supported in your install...
Hi, How do I the easiest way install the new "Microsoft OLE DB Driver for SQL Server" Would it be enough to simply copy the single dll (msoledbsql.dll) into ../system32 (or the 32bit version into SysWOW64 for 32 bit pb apps) ? This link explains t...
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 ...
Hi, I have a couple Infomaker reports that I've converted from Oracle to SQL Server. I am using SNC SQL Native Client as the connection type for both and have deployed the EXEs to my users' machines. The EXEs both work fine for me on my computer and...
  • Page :
  • 1