Discussions tagged SQL Server
Hi All,
I am using PowerBuilder 2022 R3 Build 3356 and MS SQL Server 2019 with the collation set to Latin1_General_100_CI_AI_SC_UTF8.
In a DataWindow, I have a column of type string with a length of 375. I have limited the users to type up to 375 c...
Advice related to character encoding - CharSet
- New
- Advice
- Last updated 3 days ago
- Chris Pollach @Appeon replied 3 days ago
Hi Gurus,
We are migrating our PowerBuilder Apps from Sybase ASE to SQL Server and we noticed that in Sybase, we have CharSet="iso_1" explicitly set as a DBParam.
Our new SQL Server is now has character encoding to "SQL_Latin1_General_CP1_CS_AS" wh...
PowerBuilder application connectivity to MS SQL Server through ODBC without DNS
- How-to
- Last updated 2 months ago
- Chris Pollach @Appeon replied 2 months ago
1) My PowerBuilderapplication crashing whenever user leaves it idle for sometime, this started happening after SQL Transaction object DBMS changed from MSS to MS Native Client, what could be the reason?2) Which is the preferred connecivity for PowerB...
Arabic charater not saving through datawindow
- Resolved
- How-to
- Last updated 3 months ago
- Parvejali Chodhary replied 3 months ago
Hi,
I have nvarchar column which i use to save Arabic strings. When i save text from datawindow it saves as '?????? ???? ??????? 125?*15'.
But from backend its saves fine and works.
Any solutions?
Tool Using PowerBuilder 2022 R2, MS SQL server...
SQL Server login issue with PowerServer Web App
- Issue
- Last updated 3 months ago
- Guillermo Tamburo replied 1 month ago
I apologize if this is a basic question, or if I leave out significant details, but this is my first time creating a PowerApp. I did search the forums and the web, but did not find a good answer.
I am creating a new PowerApp using Powerserver 2022...
SQL Server SP is not executed properly through PB but working fine in SSMS
- Resolved
- Issue
- Last updated 4 months ago
- Venkatesh Guptha replied 4 months ago
We have a SQL Server procedure with 20K lines of code. We will execute the procedure 18 times and syntax is created dynamically from PowerBuilder. Attached the dynamic query.
If the query is executed from SSMS there is no issue, it is inserting int...
Not a question...
If you are converting from SQL Anywhere to SQL Server, be aware that Powerbuilder and SQL Server don't communicate dates well.
If you have a date parameter you are passing in SQL, embedded or in a datawindow/datastore like so:
...
Hi Team,
Thank you in advance for your help on this. We have migrated PowerBuilder Windows application from PB 2017 to PB 2022 R3. We made this migration to enable application to use tls 1.2. We are connecting windows application to Microsoft SQL Se...
will PowerServerLabel Merge statements run SQLs parallelly(Async) on DB?
- Misc
- Last updated 6 months ago
- John Fauss replied 6 months ago
we are trying to improve the performance of our application, we have a couples of Embedded SQLs and Datawindow retrieves called one after another.
so to improve the performance, we moved all the SQL DB calls in a PowerServerLabel Merge statement whi...
SELECTBLOB and UPDATEBLOB not working
- Issue
- Last updated 6 months ago
- Chris Pollach @Appeon replied 6 months ago
I am trying to save a datawindow definition to SQL Server Varchar(Max) column, using UPDATEBLOB and the command runs without error, but the data saved is severely truncated. Using ODBC, SQL Server 2022, and PB 2022 R3 Build 3356.
lblb_DWSyntax = Blo...
Aggregate Functions or the GROUP BY clause :
- How-to
- Last updated 7 months ago
- Chris Pollach @Appeon replied 7 months ago
I'm using SQL SERVER 2014
I nead Ignore this error . GROUP BY with Aggregate Functions SLQSTAT = 42000 My problem is while executing this query
select empId, empName, empstate, sum(empsalary)from emp group by empId, empName ;
Result : COLUMN em...
Error "DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
- How-to
- Last updated 7 months ago
- Chris Pollach @Appeon replied 7 months ago
We are attempting to transition from ODBC to MSOLEDBSQL Version 19.3.3, but when we try to connect our Transaction, we get the error in the title of this post:
"DBMS MSOLEDBSQL SQL SERVER is not supported in your current installation"
This is from ...
Decimal values incorrectly passed to SQL Server as varchar
- Issue
- Last updated 8 months ago
- Bernhard Giesriegl replied 7 months ago
Using SQL Server and Powerbuilder 2022 R2 build 2819, I found another bug:
If I have the following:
decimal ldec_valuelong ll_id
ll_id = 1
ldec_value = 7.99
UPDATE my_table SET my_old_price = CASE WHEN :ldec_value <> my_old_price then...
DECLARE AND EXECUTE Stored Procedures don't work with SQL Server
- Issue
- Last updated 8 months ago
- Chris Pollach @Appeon replied 8 months ago
I have a stored procedure in SQL Server:
CREATE PROCEDURE [GROUP1].[test_return]( @OUTVALUE integer OUT ) AS begin SET @OUTVALUE = 999999; RETURN end
In Powerbuilder, I've set up a DECLARE and EXECUTE statement:
long ll_result
DECLARE te...
Best Driver to connect to SQL Server 2019/2022
- How-to
- Last updated 8 months ago
- Andreas Mykonios replied 8 months ago
Hi there,Currently we use ODBC to connect to SQL Server 2019/2022, but we want the best possible performance and as such we're looking for the best practice in this regard.
We're using Powerbuilder Version 2022, Build 1878.
Thank you in advance for...
Hi
pb 2022r3 win10 sql 15
All, still trying to connect to a sql server rather than my normal SQL Anywhere.
I am trying to save a PB datetime field back to the SQL server database and I am getting an error
SQLSTATE = 22007Microsoft SQL Serve...
SQL Native Client
- Resolved
- How-to
- Last updated 8 months ago
- Chris Pollach @Appeon replied 8 months ago
Hi all
PB 2022 R3 Windows 10 SQL Express 15
I have always used SQL Anywhere for my database however I have a new project that requires me to connect to a SQL server database
Can you confirm what i am getting is normal - i thought you could just co...
QUESTION: With the recent PowerBuilder 2022 R2 update of ADO.NET, is PowerBuilder now enforcing rules that were not previously enforced?
What is described below WAS NOT a problem with PowerBuilder 2022 R1...but with the release of PowerBuilder 2...
Sql Server - Row changed between retrieve and update
- Advice
- Last updated 9 months ago
- mike S replied 9 months ago
Sql Server 2019
PowerBuilder 2019 R3 build 2728
I'm using ODBC connection
I have a datastore, I change data and then do an update
lds_post_dates.setitem(i, "column_name", ll_value)ll_rv = lds_post_dates.update()
The base table for the datas...
pb2022 r3 datawindow insert and update
- Resolved
- How-to
- Last updated 10 months ago
- Andrew Davis replied 10 months ago
Hi
I hope someone can help, I am having a weird error - with the simplest of datawindows and programmes
I have just installed pb2022 R3 - on windows 10
I have it connected to SQLexpress database - v14.
I have a very very simple 2 column table...
- Page :
- 1