Discussions tagged SQL Server

Hi, How are people copying files (images or other files) from Appeon Mobile apps to their server? I am trying trying to use UPDATEBLOB to store the image in the database but the below code is throwing the following error: "Error Code: 10999. Object...
Hi everyone,After almost 20 years we've decided to migrate all our applications from ASE to MS SQL Server.  We've been able to use SQL Server Migration Assistant to migrate the database and I'm looking at updating my Powerbuilder code to work with SQ...
Using MS SQL SERVERif in the SQL of the Datawindow there is a comment then when the retrieve() will not work and no error dysplay will be great if in the log after the deploy of the application is a warning  ...
How to retrieve datawindow in PowerServer Web? Below are my configuration: **Open event script of my window  if AppeonGetClientType() = 'PB' thenSQLCA.DBMS = "ODBC"SQLCA.AutoCommit = FalseSQLCA.DBParm = "ConnectString='DSN=PB Demo DB V2017R2 Unico...
DB Connection Issues w/ Mobile deploy w/ Native Microsoft SQL Server  Summary Have not been able to deploy as mobile application and go beyond the database connection. Have tried using native and ODBC and have failed numerous times. PB2017 Help con...
Hello, I am getting this error while I am trying to run the powerbuilder(Version 12.5) application. I make sure the data source name,user name and password is correct. But still I am getting this error. FYI - My SQL authentication mode is SQL and W...
I am creating a new datawindow using a SQL Select. Because of some limitations in SQLServer, I need start with a WITH  (Common Table Expression) I can't seem to get PowerBuilder to understand the result set and get no columns (Or PB Crash)   PB12.6...
We are connecting to SQL Server using ODBC Driver 11. Any embedded SQL using SELECTBLOB or UPDATEBLOB truncates data at 32K, which is the default for a SQL Server driver. I have been unable to modify the default size to 1 GB, either by setting PBM...
We are just converting our application from Oracle to SQL Server. When running stored procedures, sometimes running them twice in a row generates the "Procedure has already been executed" error and sometimes in doesn't. We are not closing t...
My app is running on SQL Server 2016 and PB 12.5. AutoCommit is set to False. I want to run a stored procedure that does some updates so I need to do a commit after. I also want any updates that were pending before the stored procedure was called ...
Microsoft says it no longer supports SQL Server Native Client and they didn't provide a new version with SQL Server 2016. I am wondering what the future is for connecting to SQL Server. I have PB 12.5.2 and SQL Server 2016. I am using an OD...
Any issues with BLOB or CLOB columns? Thanks, Brian Prom ...
Just converted from PowerBuilder 6.5 and the OUTPUT parameter is not working with SQL. I get the following error and any help would be appreciated: SQLSTATE = 42000 Microsoft SQL Native Client Cannot use the OUTPUT option when passing a constant to a...
Hi,  Our PowerBuilder (12.6 at the moment) app has used SQL Server Native Client to connect to SQL Server 2005, 2008R2 and 2012. The client now want so to move to SQL Server 2014 and 2016.  Microsoft appears to be confused and confusing in rega...
App connected to SQL Server uses 12.6 PFC and PB 12.6 classic and runs in IDE but once deployed it does not and behaves differently. Running in the IDE in the open event of the app gnv_app.pfc_open() fires in n_cst_steps_appmanager. When I deploy the...
Hi, we were told that the launch of SQL Server 2017 will be on 31 May 2017. Today we are on 2014. We want to skip 2016 version and jump directly to 2017 asap. When will Appeon Powerbuilder 2017 offical support Sql Server 2017. We know tha...
Hi,  I need your help. How can I import a file from a Filestream table and display it in Powerbulider.  I am using PB 12.5 and SQL Server 2016.  Thanks  ...
  • Page :
  • 1