• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • Powerserver with SQL Anywhere Authenticated DB

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

Resolved Powerserver with SQL Anywhere Authenticated DB

  1. Issue
0
Votes
Undo
  1. Richard Donagrandi
    Richard Donagrandi
  2. PowerServer
  3. Thursday, 20 April 2023 17:27 PM UTC

I'm "migrating" our legacy app to Powerserver and have successfully built/compiled/ran the app. However, I'm having database connection issues.

Our SQL Anywhere database is authenticated; and --normally (running as client/server) -- immediately after connecting, we EXECUTE IMMEDIATE the authentication code.

When the application runs in Powerserver, however, I'm seeing "Authentication Violation" errors, for some retrievals, which mostly work, but always with saves (updates). 

I have enabled Dynamic Connections and allowing LogID and LogPass to be used. 

What are the recommendations for working with authenticated SQL Anywhere databases? 

Cloud Migration of PFC App, Linkage Error
Text Corrupted after applying Theme
Responses (2)
Dan Harrel
Dan Harrel Accepted Answer Pending Moderation
  1. Friday, 21 April 2023 21:31 PM UTC
  2. PowerServer
  3. # 1

Can you use something like the following as your connection string?  Following is C# syntax, where "(...)" items need to be substituted as approriate:

string connectionString = "DSN=(my dsn);InitString=\"SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=(my company);Application=(my product);Signature=(my oem key)'\"";

 

Comment
There are no comments made yet.
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Friday, 21 April 2023 03:14 AM UTC
  2. PowerServer
  3. # 2

Hi Richard,

Have you already understood the difference between PowerServer's database connection and Native PB? 

DB connection differences (C/S app vs. installable cloud app) - - PowerServer 2022 Help (appeon.com)

Does your application have to use the same database connection after authentication? If yes, you can also refer to Enabling long connections - - PowerServer 2022 Help (appeon.com)

If still does not work, please report your issue via our support ticketing system to ensure it is being properly received by our tech support and tracked at: 

Regards, Logan

 

 

Comment
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.