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

Resolved MSDBOLESQL and SNC - database case sensitivity

  1. Issue
0
Votes
Undo
  1. Connie Dove
    Connie Dove
  2. PowerBuilder
  3. Thursday, 12 May 2022 19:29 PM UTC

We just migrated applications from PB10 to PB2019R3.  Currenlty they are all set up to connect to the databases with ODBC.  We would like to move to OLE or SNC for connections.

However, we have ran into an issue.  When trying to get data from a database, it is looking at the case of the table name.  The databases are set for Case Insensitivity.  The tables in the database are all UPPERCASE, and in the code being called, it could be Upper, Lower, or Camel Case.  Just depends on the developer at the time.

THe databases are on SQL 2017

Is there a setting for MSDBOLEDB that will ignore the case being passed?  

 

Class/structure JSON serializer
string command returns incorrect result
Responses (2)
Connie Dove
Connie Dove Accepted Answer Pending Moderation
  1. Thursday, 12 May 2022 20:40 PM UTC
  2. PowerBuilder
  3. # 1

I have checked the sql server and the database is set to Case Insensitive.  In the database the table is dbo.ADMIN, and the datawindow has dbo.admin.  Powerbuilder is throwing error 208 saying that the table does not exists.  

 

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 12 May 2022 20:53 PM UTC
In that case, I would check your with your DBA Team to see if your DBMS login credentials and DB Ownership settings that you are assigned, have the proper Select, Insert, Delete, etc privileges. You can quickly test this out BTW by using the same credentials in the DB Profile Painter to connect to SS - then use the DBA Painter to make sure that you can see & access the table(s) in question.
  1. Helpful
John Fauss
  1. John Fauss
  2. Thursday, 12 May 2022 20:54 PM UTC
Can you open a SQLQuery pane in SQL Server Management Studio and type SELECT * FROM yourtablename-using-incorrectcase (substituting as appropriate, to verify that database collation is case-insensitive. If that works, then the problem may be related to schema/permissions. Does the connection being used either from the PB IDE (i.e., the Database Painter, for example, or the Preview Pane of the DataWindow Painter) have permission to perform SELECT, INSERT, UPDATE, DELETE statements against the table(s)?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 12 May 2022 20:31 PM UTC
  2. PowerBuilder
  3. # 2

Hi Connie;

   Yes, that would be on the SS side... https://www.webucator.com/article/how-to-check-case-sensitivity-in-sql-server

Regards ... Chris

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.