Problem in using PowerBuilder with Oracle ODBC Driver

Posted on 2006-03-20
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


    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now