• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • PowerServer - Adaptive Server Anywhere - Datasource not showing

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

Resolved PowerServer - Adaptive Server Anywhere - Datasource not showing

  1. How-to
0
Votes
Undo
  1. Rajkumar K S
    Rajkumar K S
  2. PowerServer
  3. Thursday, 1 June 2023 14:54 PM UTC

Hi Team,

We have try to configure our client server application to PowerServer 2022. Please find the below details

1. Our DB configured in Adaptive Server Anywhere 9.0 and it's successfully connecting.

2. In PowerServer application object in database provider list we cannot see the "Adaptive Server Anywhere 9.0" driver, but Adaptive Server Enterprise (ODBC) is available. Because of we cannot select the datasource name already created in Adaptive Server Anywhere 9.0.  

Please help us to solve this issue.

Thanks 

Rajkumar K S

 

Datawindows in Powerserver 2022R2 beta
PowerServer Project questions
Responses (3)
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 1 June 2023 17:11 PM UTC
  2. PowerServer
  3. # 1

Did you create a 64-bit DSN?  PowerServer defaults to 64-bit mode on a 64-bit Windows OS so it will only be able to access 64-bit DSNs.

Comment
There are no comments made yet.
Rajkumar K S
Rajkumar K S Accepted Answer Pending Moderation
  1. Thursday, 1 June 2023 16:00 PM UTC
  2. PowerServer
  3. # 2

Thank you Chris..

Regards

Rajkumar

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 1 June 2023 15:35 PM UTC
  2. PowerServer
  3. # 3

Hi Rajkumar ;

  In PowerServer 2022 it does not use the same ODBC driver as PB does. PS grabs a native C# ODBC DB driver from SAP using a Nu-get package request. It's that SAP C# ODBC driver that has the issue as it does not support SA9. You will need to upgrade to SA version 16 or higher.

FYI: https://docs.appeon.com/ps2022/Database_Server.html

HTH

Regards ... Chris

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 1 June 2023 16:16 PM UTC
You are most welcome! ;-)
  1. Helpful
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.