Discussions tagged SQL Server
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
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...
Uploading Blob to MS SQL Server
- Resolved
- How-to
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...
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
...
Retrieve data in datawindow
- Resolved
- How-to
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...
Data Source for SQL statement starting with "WITH"
- Resolved
- How-to
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...
SQL Server and PBMaxBlobSize in PB 2017 R2
- Resolved
- Issue
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 doesnt.
We are not closing the pr...
Stored Procedures and transactions
- Resolved
- Issue
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 didnt 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 ODBC co...
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...
Find Questions by Tag
.EXE
.NET 6.0
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET DataStore
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
AI
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Asynchronous Methods
Authentication
AutoBuild
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Build
Button
C#
C# Class Importer
C# Editor
C# Model generator
Calendar
Camera
Certificate
Chrome
Citrix
Class
Client
Client/Server
Cloud
Cluster
Collection
COM
Command Line
Compiler
Compression
Computed Field
Configuration
Controls
Cookies
Cordova
Crash
Cross-Platform
Crosstab
CSharpAssembly
CSharpObject
CSS
CSV
Cursor
Data
Database
Database Driver
Database Painter
Database Profile
Database Provider
DataObject
DataSource
DataStore
DataStore (C#)
DataStore (PS)
DataType
DataWindow
DATE
DATETIME
DB2
Debug
Debugger
Debugging
Deployment
Design
DLL
DO-WHILE
Dockable
Docker
Documentation
DOUBLE
Download
DragDrop
Edge
Edit Style
Editor
Elevate Conference
Email
Embedded SQL
Emulator
Encoding
Encryption
Enhancement Request
Entity
Entity Framework
ERP
Error
Event
Event Handler
Event Handling
Excel
Exception
Export
Expression
External Functions
F#
Field
File
File Access
Filter
Firefox
Firewall
Font
FOR-NEXT
Foreground
Format
Function
Garbage Collection
GeoLocation
Git
Graph
HANA
Hash
Header
HTML/5
HTTP/S
HTTPClient
Icon
IDE
Identity
IIS
IMAPI
Import
InfoMaker
Inheritance
Installation
Integer
IntelliSense
Interface
Internet
Internet Explorer
iOS
IPA
iPad
iPhone
IWA
J#
Java
JavaScript
JBoss
JDBC
JOIN
JSON
JSONGenerator
JSONParser
Kestrel
Label
Lambda
Large File
LDAP
Library
License
LINQ
Linux OS
Load Balancing
Localization
Localized PBVM
Log In
Log Out
Logging
LONG
LONGLONG
macOS
MAPI
Maps
MDI
Memory
Memory Leak
Menu
Merge
MessageBox
Messagging
Method
Migration
MIME TYPE
Mobile
Model
ModelStore
ModelStore (C#)
MSOLEDBSQL
Multi Threading
MVC
MySQL
n-Tier
Namespace
NativePDF
NVO
OAuth
ODATA
ODBC
Office
Offline
OLE
OLEDB
Online
Open Source
OpenAPI
OpenSSL
Oracle
OrcaScript
Other
Outlook
Output
Package
Parameter
Patch
PayPal
PB Classic
PB Native
PB.NET
PBC
PBD
PBDOM
PBG
PBJVM
PBL
PBNI
PBORCA
PBVM
PBX
PDF
Performance
Permission
PFC
Picture
Pipeline
Play Store (Google)
Plugin
Popup
Port
POST
PostgreSQL
PowerBuilder
PowerBuilder (Appeon)
PowerBuilder (SAP)
PowerBuilder Compiler
PowerBuilder Runtime
PowerClient
PowerScript (PS)
PowerScript IDE
PowerScript Migrator
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
PowerServerLabel
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Rich Text
Roadmap
RPC
Runtime Packager
SaaS
Scaffolding
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SMTPClient
SnapDevelop
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
SqlModelMapper
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
TabbedBar
TabbedView
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
Theme
TIME
Timer
TLS/SSL
Tomcat
TortoiseGit
TortoiseSVN
Transaction
Transparency
Trial
Trigger
TRY-CATCH
TX Control
Type
UI
ULONG
UltraLite
Uninstall
Unit Test
Unit Testing
UNIX OS
Update
Upgrade
Upload
URL
User Center
User Object
UWP
Validation
VARCHAR
Variable
Versioning
Visual Studio
Visual Studio Code
VM
Voice
Warning
WCF
Web API
Web Extensions
Web Service
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom