Discussions tagged SQL Server
MSS long execution time due to MS_SQLSERVER_SYNTAX in pbodbpbodb.ini file
- New
- Advice
- Last updated 3 days ago
- Chris Pollach @Appeon replied 1 day ago
Hi All.
We've noticed that the query below, that appears in the pdobd.ini file (both in PB17 and PB21)
SelectDefault='select y.name, x.text from syscomments x, syscolumns y where x.id = y.cdefault and y.id = OBJECT_ID(''&TableOwner.&TableNa...
Hi Appeon,
I am doing the migration from SQL Anywhere to MS SQL Server Database
PB2019R3
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
when I run the application and try to save the changes from the screen I am getting the below error
...
Encrypted connection from PowerBuilder 2017R3 to SQL Server 2016
- Resolved
- How-to
- Last updated 3 months ago
- Roland Smith replied 3 months ago
Hi,
How to encrypt (TLS 1.1 or 1.2) Database connection from PowerBuilder application?
PB Version: 2017R3
SQL Client: SQL Native Client (sqlncli11)
DB Server : MS SQL SERVER 2016
If it is not supported in PB2017, Please let me know whether is it...
PowerServer 2021 Transaction Error
- Issue
- Last updated 4 months ago
- Thomas Rolseth replied 4 months ago
I've deployed a PB application to PowerServer 2021. The application uses SQL Server for the backend database and is hosted on a remote AWS web server running IIS. The deployment process went fine and I can launch the app w/o issue using the CAL.
...
DateTime data type error with PowerServer WebAPI
- Issue
- Last updated 4 months ago
- Armeen Mazda @Appeon replied 4 months ago
I am getting a datawindow error when retrieving a datawindow that is part of a tab page on a window. See attached image to view the error. The database is SQL Server and the application has been been deployed to PowerServer 2021. The datawindow ha...
ODBC::Argument data type text is invalid for argument 1 of upper function.
- Resolved
- How-to
- Last updated 5 months ago
- Arnd Schmidt replied 5 months ago
Hi
I have a desktop application developed in PB2017 R3. It is connecting to the MS SQL database thru ODBC with connection string as below:
SQLCA.DBMS = "ODBC" SQLCA.AutoCommit = TrueSQLCA.DBParm = "ConnectString='DSN=dsn_name;UID=xyz;PWD=abc',Commi...
PowerClient and Cloud App Launcher Issue
- Resolved
- Issue
- Last updated 6 months ago
- Kai Zhao @Appeon replied 6 months ago
I am having issues running a lightweight PB application called CRH that has been deployed to a remote Amazon AWS server. The app was built with PB 2021 build 1288 and uses SQL Server for the database. The deployment goes fine and I can download and...
Hi,
I just migrated my PB10.5 application to PB2021. Everything seems to be running great on the development machine including the database connection.
When I tried on a client machine, I realized that I needed to install VC++ 2010 runtime, which ...
PB not showing response from TRY CATCH from SQL Server
- Resolved
- How-to
- Last updated 6 months ago
- Matt Balent replied 6 months ago
Hi All,
I have a Stored procedure in SQL Server 2019 which is using TRY CATCH for error handling instead of "RAISERROR" but this is not throwing a response back when SP is called from PowerBuilder using "Stored Procedure Update" functionality.
If ...
SQLSTATE = 42000 Microsoft SQL Server Native Client 11.0 Incorrect syntax near 'x' errors
- Advice
- Last updated 9 months ago
- Matt Balent replied 9 months ago
Just posting some advice in case someone else stumbles onto an issue like this.
The SQLSTATE = 42000 a catch all basin for everything under the sun from Microsoft can lead you in circles. Here's another gotcha.
When using a PB 2019 R3 application w...
Can't connect MS SQL Server Express from Power Server 2021
- Issue
- Last updated 9 months ago
- Julie Jiang @Appeon replied 9 months ago
Hi,
I'm testing PB & Power Server 2021 with MS SQL Server 2019 Express. Both Windows and SQL server authentication are enabled.
I have some odd behaviour and problems while connecting my database from PowerServer (from PB both authentication me...
Can i create a datawindow using a pivote dynamic query ?
- Resolved
- How-to
- Last updated 11 months ago
- John Fauss replied 11 months ago
Hi, Good morning.
Is there a way to create a Datawindow with this statement. It really doesn't care if it's embebbed or not.
DB: Sql Server
IDE: PB 2019 R3
I'm doing this because the crosstab which do this, doesn't work and I'm looking for way...
Disconnect at a particular time range everyday
- Issue
- Last updated 11 months ago
- John Fauss replied 11 months ago
Hello,
PB 11.5, SQL Server 2012 Express, Windows Server 2012 R2 (in server) and Windows 7 (in clients)Also SQL Server 2000 is there to view old data.
Every day at a particular time (between 3.00 to 3.30 pm), Powerbuilder application gets disconnect...
SnapDevelop Connecting to MS SQL Server
- Resolved
- Issue
- Last updated 1 year ago
- Sivaprakash BKR replied 1 year ago
I'm using SnapDevelop 2019R3 Build 2703. I cannot connect to MS SQL Server. I get network connectivity error and a timeout. I can connect to the same database using PB IDE on the same Wind 10 PC.
I've checked that required protocols are enabled o nt...
Checkbox in datawindow is not showing value
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
I have an application that I upgraded from Powerbuilder 8.0 to 2019 R3. We also upgraded from Sql Server 2008 to Sql Server 2019.
I have noticed that when a datawindow has a db column with a checkbox style top and the column is type Bit, the value d...
Select varchar(max) field on SQLServer return the value truncated
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
I select a field declared as nvarchar(nmax) from a table in sqlserver using an odbc connection (even with a native driver). The result from the select is truncated if the value in the column has more then 32676 character. I use Power Builder 2019R2. ...
Crosstab datawindow blinking and after that close the application
- Resolved
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 11 months ago
Good morning,
I got a problem with some of my crosstabs datawindows, when i do a retrieve my crosstab starts blinking and after that the application automatically close.
If somebody can help me with this issue.
Do you know what is happening ?
...
Hi Folks,
My application is on PB 2017 R2 and its running on windows server 2012 R2 OS. Application is connecting with local DB which is in SQL anywhere and remote database which is in SQL server.
This application is basically fetching the files fr...
Hi;
I recently modified an Infomaker form (using 2019 r2) to connect to a SQL Server database rather than Oracle. The form is used so people can add new users to roles. I am assuming it was made in the one-to-many type because it is supposed t...
Comparison of methods accessing SQL Server from PowerBuilder
- Advice
- Last updated 1 year ago
- Roland Mühlberger replied 1 year ago
Dear PowerBuider Programmers,
this might emerge as a philosophical question, but I still hope to get some answers:
PowerBuilder allows many different ways to access Microsoft SQL Server databases from classic (client/server) PB windows applications...
- Page :
- 1