Re: Connecting PowerBuilder 4.0 to Personal Oracle 7.1

>>: In <3piaep$h1o_at_saturn.ball.com> dschrade_at_ball.com (Dave Schrader)
>>: writes:
>>: >Is it possible to connect PB 4.0 Desktop to Personal Oracle 7.1
>>: >via ODBC? If you've done it, I'd appreciate some tips.
>
 

>: To connect to the sample database in PO7,
>: 1. Startup the database from PO7 (you may use SQLDBA or DBManager)
>: 2. From PB4.0, in preferences, set DBMS to OR7, userid to 'system',
 

>: password to 'manager' (you may want to create a profile later on)
>
 In <D9CBu7.Auo_at_cs.dal.ca> aa651_at_ccn.cs.dal.ca (Karl Penney) writes:
>Note that the above will not work with PB4 Desktop since the native
 Oracle
>drivers will not be available. I don't know wheter it works with ODBC
 or
>not, but my guess would be no.
>
>--

The above works with PB4.0 enterprise version. To connect to PO7 from PB4.0 Enterprise, you have to configure ODBC. My entries for Oracle in odbcinst.ini:

    [ODBC Drivers]
    Oracle71=Installed
    [Oracle71]
    Driver=C:\WINDOWS\SYSTEM\sqora71.dll     Setup=C:\WINDOWS\SYSTEM\sqoras71.dll

I dont think this would work for PB4.0 Desktop with ODBC out from the box since it would not have the PB oracle interface DLL (PBORxxxx.DLL).  I dont know if Powersoft will provide the Enhanced Database Kit as option to the desktop or maybe check with 3rd party vendors like Q&E if they have anything.

JOEL CRUZ

• QUANTUM MATRIX SYSTEMS *
• qmtrx_at_aol.com *
• *
• Contract Programming . Network Integration . Training *
• *
• AS/400 . CLIENT/SERVER . CONNECTIVITY * *RPG III/400 . COBOL . VISUAL BASIC . POWERBUILDER . ORACLE . SYBASE*

  ---