Discussions tagged SQL Server
Powerbuilder 2017/R3 SQL-Server NVARCHAR(max) cut after 32766 characters
- Resolved
- Issue
- Last updated was 1 month ago
- Andreas Steinhauser replied 1 month ago
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...
updatable table in dynamic datawindow (Powerserver Web Version)
- Issue
- Last updated was 2 months ago
- Juan Pedro Sanz Diez replied 2 months ago
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...
Running PowerBuilder 2019 Universal. Cannot connect to current database
- Issue
- Last updated was 3 months ago
- Arthur Foux replied 3 months ago
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...
PB 2019 can Save to SQL SERVER 2016 using IDE but not runtime?
- How-to
- Last updated was 3 months ago
- Karl Wooley replied 3 months ago
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...
C# Model Generation Error - SQL Server
- Issue
- Last updated was 4 months ago
- Thomas Rolseth replied 4 months ago
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 ...
Powerserver Data Source (MSSQL) Disablebind
- How-to
- Last updated was 5 months ago
- Zhao Kai replied 5 months ago
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 ...
"Impersonation" using different Windows AD System account
- How-to
- Last updated was 6 months ago
- Kim Berghall replied 5 months ago
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 ...
changing to ODBC for sql server 17. application/debugger crashes on selectblob
- Issue
- Last updated was 6 months ago
- Chris Low replied 6 months ago
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...
How to suppress ODBC login window after incorrect password?
- Resolved
- How-to
- Last updated was 6 months ago
- Jonathan Meltzer replied 6 months ago
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. ...
PB2017 Migration problem with SNC connection
- Resolved
- Issue
- Last updated was 9 months ago
- Luca DG replied 9 months ago
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...
ODBC Driver 17 for SQL Server problems with updating datawindow
- Resolved
- Issue
- Last updated was 10 months ago
- Chad Bailey replied 9 months ago
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...
Uploading Blob to MS SQL Server
- Resolved
- How-to
- Last updated was 11 months ago
- Marco Meoni replied 11 months ago
Hi,
I'm having an issue uploading a image Blobs to a MS SQL Server and can't figure out where I'm going wrong (Using Powerbuilder 2017 R3, both in Desktop App and Appeon Mobile).
The Upload Blob is working and creating the database records but it l...
Inserting Blob into MS SQL database from Appeon Mobile?
- Resolved
- How-to
- Last updated was 1 year ago
- Zhao Kai replied 1 year ago
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...
Migrating Applications from ASE to MS SQL Server
- Advice
- Last updated was 1 year ago
- Chris Pollach replied 1 year ago
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...
Comment in DW SQL prevent the Dw to retrieve in Powerserver
- How-to
- Last updated was 1 year ago
- Zhao Kai replied 1 year ago
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
...
Retrieve data in datawindow
- Resolved
- How-to
- Last updated was 1 year ago
- Appeon Support Team replied 1 year ago
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...
- Page :
- 1