Discussions tagged SQL Server

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...
My application currently uses the following to set a variable for use by a MS SQL Sever 2014 database trigger.  This does not work in PowerServer.  Is there a workaround of some variety?   ls_SQL = "Declare @TheUser VARCHAR(128)  SET @TheUser='" + ...
PB 2019 R2 Build 2279 We have a problem using application roles with ODBC driver for SQL Server and the SELECTBLOB function: First we connect to the sql database using "ODBC Driver 17 for SQL Server" (or 13), then we activate application role by ex...
Which highest version of MS SQL Server is officially supported by PB 2019 / PB 2019 R2?   Anyone use PB 2019 with SQL 2019 ? (which driver do you use ~ OLE DB / Native driver ?)   Thanks  ...
As a workaround for the problem with embedded SQL calling a stored procedure with an OUTPUT parameter (which I reported earlier this week), I used a remote procedure call. I am using PB19 on W10, SQLNCLI11 and SQL Server 2016. The remote procedure c...
I'm in the process of migrating our PB 12.5.2 applications to PB19. I'm using the SQLNCLI11 provider. Have just run into the following error upon executing a stored procedure. SQLDBCode 179SQLErrText:SQLSTATE = 42000Microsoft SQL Server Native Clien...
PB 19 Build 2082 SQL SERVER 2017   Upgrading our driver from SQLOLEDB to MSOLEDBSQL and now get issues w/ SQL's DBPARAMBINDINFO.     PROBLEM: MSOLEDBSQL conflicts w/ the Now() function in that the driver only wants 3 milliseconds instead of No...
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...
  • Page :
  • 1