Problem in using PowerBuilder with Oracle ODBC Driver

Posted on 2006-03-20
Medium Priority
Last Modified: 2013-12-26

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.

Question by:xsysys
1 Comment
LVL 14

Accepted Solution

sandeep_patel earned 200 total points
ID: 16245187

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.


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question