Discussions tagged SQL Server

We are updating a MS SQL Server Database using a datawindow with Modified Columns used as the Update Criteria.  We are always getting a failure "Row changed between retrieve and Update"  (PB 2017 R3) A datetime column in the database seems to be the...
Hi Guys I've a table "flusso_ccic" and a datastore in PB2019 R2 on it No column identity, just the key from some columns I converted to a Model on Snap Develop R2 and Retrieve works fine, but If I try to Run a Create from a rest Client the query f...
Issue: Extremely slow query performance using ADO.NET connection to a SQL Server 2016 database using Appeon PB v2019 b2082. Querying ~700 rows from SQL Server 2016 DB into a grid datawindow which is taking approx 2-3 minutes to complete (from compil...
We  are thinking of migrating our PB Classic application (2017 build 1769) from DB2 v11 to Microsoft SQL Server 2016. Currently we connect to DB2 via ODBC. Any suggestions on what to do? Are they any tools that can help? Will native connection be bet...
Hi. My application has started pop up a message box on some data fetches. The message is "Select error: SQL State = 22005 ... Invalid character for cast specification" This may have started when I changed the connection to a newer SQL server. The ...
Hi, currently we are using Powerbuilder 2017/R3 Build 1858 in connection with SQL-Server (2005 - 2017)! We defined a field with NVARCHAR(MAX) in a table. We try to select this field. SQLNCLI9/10/11: Regarding parameter PBMaxTextSize: field NVARCHA...
  Hello, We have a  funcionality that creates dynamically DW the PB function SyntaxFromSQL, in this way dwsyntax_str = sqlca0.SyntaxFromSQL(sqlsyntax, "style(type=grid)", s_err) messagebox('table',dwsyntax_str) The messagebox is showed below for ...
Hi Team, We are using  SQL Server 2012 database to connect one of the Power builder 8.0 application. I have used below connection settings to connect for SQL server 2012. SQLCA.DBMS = "SNC"SQLCA.LogId = "sqluser1"SQLCA.LogPass = "password123"SQLCA...
This is the server we are using The application loads. After the password is entered these are the messages that appear and I believe in this order.   This is AEM data source. There is only 4 items that appear in the ODBC Data Source dropd...
We are currently trying out a trial version of PB 2019.  We are running against a SQL SERVER 2016 DB. Using the IDE we're able to connect, retrieve and update to the database.  When the .EXE is built we can only connect and retrieve from the DB.  No ...
Hello  I have several datawindows coming from an old application with graphic SQL written win Powerbuilder outer Join syntax (*= or =*). For example: select student.name, student_email.email from student, student_email where student.id *= student_e...
I am getting an error when exporting a datawindow using the C# Model Generator to a snapdevelop web api.  When I open the C# Model Generation window I am asked to select/setup a database connection profile which I am able to do.  The test connection ...
Hi All, We have numerous SQL Server Data Sources defined in our Appeon Powerserver AEM, to connect to various SQL Server Database. In our Mobile App, we use the Cachename to connect our SQLCA object to the DB. We now have a requirement to display ...
Hello all, I'm a longtime (more than 22+ years) PowerBuilder developer. We have upgraded to PowerBuilder 2017 R2 through Appeon. I have a question about the support for “Impersonation” using a different Windows AD System account after logging into ...
because of the need to disable TLS 1.0, i'm moving to the latest sql driver that supports tls 1.2 (unless anyone has better suggestions) SQLCA.DBParm = "ConnectString='DSN=" + ls_dsn + ";UID=" + sle_userid.text + ";PWD=" + ls_password +"',DelimitIde...
I have just changed our application to use a DSN-less connection to ODBC, and I am struggling with how to trap an incorrect password condition.  Previously (our current production code), we had an OLE DB connection.  We have a login screen, and if th...
Hi All, We have just realized that the Native SQL Server driver in Powerbuilder has Multiple Active Result Sets (MARS) enabled by default.  We haven't really noticed any issue except that every time the application connects, it uses 2 connections.  ...
Hello I'm migrating a PB2017 application to support datatype from CHAR to NCHAR and I have problems using SNC connection migrating from  PB 6.5 and Native MS SQL driver. This is the connection string: SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"SQL...
I need the ODBC Driver for SQL Server so I can use encryption TLS 1.2.  I've encountered two problems with inserting and updating datawindows.  I have tables and columns where there is a column on a table that cannot be null but has a database defau...
Dear supporter:        As we deploy Powerbuilder application with SNC connection for SQLSERVER2017, few PC encountered error message below to indicated that the SNC not connected, as we download and installed SQLserver SNC driver 2008, and deploy t...
  • Page :
  • 1