Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Migration of Legacy App to PowerServer

  1. How-to
0
Votes
Undo
  1. Michael Chernin
    Michael Chernin
  2. PowerServer
  3. Tuesday, 7 June 2022 13:34 PM UTC

I've just migrated our app to PowerServer and have 3 main issues:

1. We used to have ODBC connection to MSSQL, it does not seem available right now. Is that correct? I'm getting a lot of SQL errors all of a sudden.

2. Overall performance seems to be slower than client-server mode. Is it normal?

3. What to do with shared folders and drives - how to map them now? For example, our users have i: drive mapped to the invoice repository, How can these be accessed?

Thank you

Michael

32-bit ODBC for SQL Anywhere
PS 2021 individual dw column background colors w t...
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 June 2022 18:08 PM UTC
  2. PowerServer
  3. # 1

Hi Michael;

  PowerServer 2021 has it's own built-in SS DB driver based on Microsoft's C# NUGET package for SS. Only DBMS's like (ie: SQLAnyWhere and ASE) use the ODBC DB driver as those DBMS do not support .Net Core based drivers.

Regards ... Chris

Comment
Michael Chernin
  1. Michael Chernin
  2. Tuesday, 7 June 2022 18:16 PM UTC
Thank you Chris, this is clear. What about the #3 (Shared folders)?
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 7 June 2022 18:48 PM UTC
#2 - Yes, performance could be slower as Network latency and SQL result set to JSON conversion will take a bit longer per RestFul call.

#3 - There should be no change to the use of SHARED folders as the PS "Client" part of the App is still executing in "native" EXE mode.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 June 2022 19:26 PM UTC
  2. PowerServer
  3. # 2

Adding to what Chris said, PowerServer 2022 offers improved performance over 2021 version.  Of course, since this is cloud architecture and not on-premise LAN deployment so PowerServer 2022 is still going to be slower than client/server. 

If any particular function is unbearably slow, then it means you need to optimize the relevant code.  We offer Performance Tuning Guide to help guide you what to do: https://docs.appeon.com/ps2021/performance_guide.html

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Tuesday, 7 June 2022 15:09 PM UTC
  2. PowerServer
  3. # 3

Hi.

You should mention what version of PB/PS you are using. PowerServer 2020 is a totally different product than PowerServer 2021. Also, if you migrated to PowerServer 2020, then take in mind that this product will be supported for some years, but is replaced from PowerServer 2021.

If using PowerServer 2021 why not using MSOLEDBSQL SQL Server driver?

Andreas.

Comment
There are no comments made yet.
Michael Chernin
Michael Chernin Accepted Answer Pending Moderation
  1. Tuesday, 7 June 2022 15:27 PM UTC
  2. PowerServer
  3. # 4

Sorry, should have given more details: migration was done from PB12.6 to PS2021. PB12.6 used Microsoft ODBC SQL Server driver.

Comment
John Fauss
  1. John Fauss
  2. Tuesday, 7 June 2022 16:06 PM UTC
PS 2021 is 64-bit only, so it requires use of a 64-bit ODBC driver, whereas the PB IDE must use a 32-bit ODBC driver. In regards to your second question, PS 2021 converts all database activity to utilize REST API calls so this may be why you are seeing some performance degradation compared to a traditional client/server implementation.
  1. Helpful
Michael Chernin
  1. Michael Chernin
  2. Tuesday, 7 June 2022 16:27 PM UTC
The list of database drivers in PowerServer project setup does not contain ODBC option. Can it be added through JSON configuration file manually?
  1. Helpful
John Fauss
  1. John Fauss
  2. Tuesday, 7 June 2022 18:09 PM UTC
According to the documentation:

https://docs.appeon.com/ps2021/Supported_dbtypes_versions.html

PowerServer 2021 connections to SQL Server can only be accomplished via the native driver for .Net Core. Only SQL Anywhere and Sybase ASE can be connected using the ODBC driver.
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.