• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1936
  • Last Modified:

Problem in using PowerBuilder with Oracle ODBC Driver


I am connecting oracle 10g from PowerBuilder 8 through ODBC driver.

While creating DSN for oracle 10g user name ‘SYSMAN’ is used.

When I connect oracle 10g from PowerBuilder 8 database painter then all the table names are displayed with username e.g. SYSNAM.employee

When I create DataWindow from any of the table then username is displayed with table name in DataWindow select statement.

How to avoid the user name, while creating DataWindow?

 If I remove username from select statement of DataWindow then at the time of giving table name for update properties, it says that particular table is not found.

 This problem is not found when I am using native driver of oracle provided by PowerBuilder, as no username name is displayed before table names. Even I connected with same user ‘SYSMAN’.

Can anyone guide me how to solve this problem of ODBC driver.

1 Solution

I think it's not due to ODBC Driver. But it's due to the settings in your db profile.

Just go to dbprofile > system tabpage and give 'SYSMAN' as PowerBuilder Catalog Table Owner and same in Table Criteria > Table Owner.

Now see the database syntax in preview tab (TbaleCriteria is added to the sqlca.dbparm) and use the same for database connectivity.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now