how to connect in oracle with powerbuilder SQLCA object?

Posted on 2004-11-06
Last Modified: 2013-12-26

i created a connection object

SQLCA.userid = "123"

SQLCA.dbpass = "1234"
SQLCA.dbparm = "ConnectString='DRIVER={O90 Oracle9i (9.0.1)};'"

this is not working!

how the connectstring should have been? and how i define the database server/instance to connect?

please help me...
Question by:stefanosn
    LVL 8

    Expert Comment

    have you installed oracle client on your machine if yes then its more easire to get the conecting string

    LVL 33

    Accepted Solution

    Any reason why you are connecting thru ODBC and not using the default oracle driver ?

    The below code works for oracle driver
    SQLCA.DBMS = "O90 Oracle9i (9.0.1)"
    SQLCA.ServerName = "ORCSERVER"
    SQLCA.LogPass = 'tiger'
    SQLCA.LogId = "scott"
    SQLCA.AutoCommit = False
    SQLCA.DBParm = "Timestamp='NO',DelimitIdentifier='No'"

    Setup for:
    DATABASE: Oracle9i
    Oracle Client:
    PowerBuilder: 9.0.1

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
    Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project ( automates most of the tasks discussed in this article. You can even fin…
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now