• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Problem with SyntaxFromSQL(GET EXTENDED ATTRIBUTES)

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

Resolved Problem with SyntaxFromSQL(GET EXTENDED ATTRIBUTES)

  1. Issue
0
Votes
Undo
  1. Lucio Dimone
    Lucio Dimone
  2. PowerBuilder
  3. Friday, 9 February 2018 11:41 AM UTC

PB 8.0.4

Got a trace from a customer from a SyntaxFromSQL:

(23b7008): Select (...)
(23b7008): GET EXTENDED ATTRIBUTES: TABLE=tablename OWNER=dbo (16 MilliSeconds)
(23b7008): 
Error 208 (rc -1) : Name of Object 'dbo.pbcattbl' invalid.
 
The problem is: no customer have the pbcat tables, and this never happened before.
I tested the same exe, in a local database, after dropping the pbcat tables, an there is no error. After the GET EXTENDED ATTRIBUTES the select is executed and everything is fine.
 
Is there any parameter or something that define that my SyntaxFromSQL should use or not the pbcat tables?
  1. SQL
Can I deploy a standard non db basic PB app to run...
What is "idw_requestor" identifier?
Responses (6)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 9 February 2018 18:23 PM UTC
  2. PowerBuilder
  3. # 1

Try accessing the database with the Server Native Client ODBC driver. The MSS interface was not continued after PB 8 because Microsoft no longer supports the underlying technology.

 

Comment
Roland Smith
  1. Roland Smith
  2. Friday, 9 February 2018 18:25 PM UTC
Make that the 'SQL Server Native Client 11.0'.

  1. Helpful
There are no comments made yet.
Lucio Dimone
Lucio Dimone Accepted Answer Pending Moderation
  1. Friday, 9 February 2018 16:49 PM UTC
  2. PowerBuilder
  3. # 2

SQLServer2008 with native interface ( DBMS=MSS )

Already had tried NoCatalog without sucess.

And yes, we still maintenance a few old applications on PB8. No new products with this version.

Comment
There are no comments made yet.
Govinda Lopez @Appeon
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Friday, 9 February 2018 15:07 PM UTC
  2. PowerBuilder
  3. # 3

Hi Lucio,

 

I agree with Roland. I also recommend you upgrading to PowerBuilder 2017.

 

 

Regards,

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 9 February 2018 13:49 PM UTC
  2. PowerBuilder
  3. # 4

Do I understand correctly that your company sells an application to other companies and it is written in PowerBuilder 8?

PowerBuilder 8 came out in 2001 and has been unsupported for more than 12 years. You should look into an upgrade tp PB 2017.

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 9 February 2018 13:45 PM UTC
  2. PowerBuilder
  3. # 5

What database are you using and which interface are you using (ODBC, OLE, etc..)?

PBNoCatalog isn't an option for the PB 8 Oracle interface.

 

Comment
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Friday, 9 February 2018 12:22 PM UTC
  2. PowerBuilder
  3. # 6

You may try the DBParm parameter PBNoCatalog. But the help means it is only for Oracle connections.

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.