1. Lucio Dimone
  2. PowerBuilder
  3. Friday, 09 February 2018

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?
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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
Make that the 'SQL Server Native Client 11.0'.

  1. Roland Smith
  2. Friday, 9 February 2018
There are no comments made yet.
  1. Friday, 9 February 2018
  2. PowerBuilder
  3. # 1
Lucio Dimone Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 9 February 2018
  2. PowerBuilder
  3. # 2
Govinda Lopez Accepted Answer Pending Moderation
0
Votes
Undo

Hi Lucio,

 

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

 

 

Regards,

Comment
There are no comments made yet.
  1. Friday, 9 February 2018
  2. PowerBuilder
  3. # 3
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 9 February 2018
  2. PowerBuilder
  3. # 4
Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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.
  1. Friday, 9 February 2018
  2. PowerBuilder
  3. # 5
René Ullrich Accepted Answer Pending Moderation
0
Votes
Undo

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

Comment
There are no comments made yet.
  1. Friday, 9 February 2018
  2. PowerBuilder
  3. # 6
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.