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

Resolved ODBC sybase password validation issue

  1. How-to
0
Votes
Undo
  1. Chen Mey Lee
    Chen Mey Lee
  2. PowerServer 2020 or older (Obsolete)
  3. Friday, 9 April 2021 04:11 AM UTC

hi,

I using ODBC to connect sybase database (ASE). When login to database  with  invalid password SQLCA.SQLCode = 0 which mean valid password.  UID and PWD is setup in DBParm  connectString.

 

 

SetFilter() is not working in PowerServer web.
Cross tab report, while saving to HTML, Excel, or...
Responses (4)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 14 April 2021 14:41 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

One workaround:

Put a small block of code after your connection attempt. This should be a simple retrieve from a small table:

       SELECT count(*) INTO :ll_count FROM small_table;

Now check the sqlca.sqlCode value.

Comment
Chris Keating
  1. Chris Keating
  2. Thursday, 15 April 2021 04:03 AM UTC
Something like "select @@version" would also work and is very inexpensive to verify that a connection is live.
  1. Helpful
There are no comments made yet.
David Xiong @Appeon
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 14 April 2021 10:40 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi Chen,

We further analyzed it on our side and found that it is not a bug.

In PowerServer 2021 Beta, if you configure the SQLCA corresponding Cache in the Database Configuration in the Web APIs tab in PowerServer Project, the connection info SQLCA used will come from the corresponding Cache connection info in Connection-Cache.json.

Any problems please let us know.

Regards,

David

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 14 April 2021 14:41 PM UTC
The problem with this is that the examples and documentation say that you HAVE to fill the connection profile.

I'll try without....
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 15 April 2021 03:06 AM UTC
(Same comment as on the ticket).

So if I want to access with different user and access rights, I cannot use caching? The only way to take advantage of caching is by all users running as the SAME user on the database?

That kinda seems like a big downside to me.

regards

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 15 April 2021 03:08 AM UTC
It would be nice if you could configure the caching without user and password, so you can pass those in the sqlca from code, but for now you cannot save the caching profile if you can't connect first by specifying user and password.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 9 April 2021 06:30 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

Okay,

I've also been testing on 2021 beta (with Oracle DB) and just tried to reproduce the problem:

Indeed, I've changed my password to 'potato' (which is not a valid password) and I don't get any error message from the CONNECT; sqlca.sqlcode = 0 so that's bad.

In my opinion, this is a bug!

I have create a support ticket for you: https://www.appeon.com/standardsupport/track/view?id=6407

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 9 April 2021 04:35 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 4

Hi,

Please explain a little bit more. What is your question?

regards

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 9 April 2021 05:54 AM UTC
(Sorry Chen, I totally missed that it's powerSERVER that you are talking about.)
  1. Helpful
Chen Mey Lee
  1. Chen Mey Lee
  2. Friday, 9 April 2021 05:55 AM UTC
Use PowerBuilder 2021 beta version
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 9 April 2021 05:57 AM UTC
That's not removing the userid and password, that's setting them to empty. But I'm not sure that this is the problem anyway.

I think Armeen will be able to help you better on this one.

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