paradox 4.5 & oracle 10g

|
paradox 4.5 & oracle 10g in Paradox to/from Other Data Sources topic (part of our Corel Paradox / ObjectPAL Coding group).
Quick Search:
paradox
paradox 4
paradox 4 5
& oracle
|
|
|
|
matjazc
|
|
We are in the process of migrating our applications to Oracle10g database, but in order to achieve this first we have to configure one vintage Paradox 4.5 (for win) application to use 10g database. The guys who wrote it are long time gone from our firm and none of us knows Paradox or the way it works.
'till now I've managed to find out the following: The application used to work with interbase but was reconfigured to use Oracle8.0 later. It runs on win98 machine with sql*net V2 Lite installed along with PCTCP (don't know if that's mandatory - or what it's for). The network protocol installed is "TCP/IP Stack. FTP Software, Inc.".
I've scanned trough some source code files and have come upon Oracle's sql*net v1 strings:
ConnectBase = "@t:192.168.4.8/1521:pp80"
I've replaced IP and Oracle SID in connect string with 10g database's properties and the application even managed to obtain connection with database, but it hangs right after that because sql*net v2 and Net8 are incompatibile.
I've even installed Oracle8i client and tried to replace sql*net v1 connect string with entry in tnsnames.ora but I get database connection error.
I suppose what we are dealing with here is ObjectPAL language (from what I've read on net).
Can some of you guys please point me out some references or info about connecting with Paradox to OracleDB, through native or ODBC calls.
Or any kind of advice/explanation/suggestion about what to change to make it work.
Here is relevant (I think) code from two source files:
PROC OILGLogin() PRIVATE RetValue, User, Pass, nW1, nW2, OILGSola, OILGUser, OILGPass, OILGIdle
OILGSola = IIF(ConnectType=0,""," æOLSKA BAZA") SWITCH CASE ConnectProduct = "INTERBAS": OILGSola = "*IB*"+OILGSola CASE ConnectProduct = "ORACLE": OILGSola = "*OR*"+OILGSola OTHERWISE: OILGSola = "*?*"+OILGSola ENDSWITCH
; OILGSola = IIF(StrRight(ConnectBase,5)="o.gdb","","SOLSKA BAZA") OILGUser = "" OILGPass = "" OILGIdle = TICKS() ; IDLE loop counter
WHILE True RetValue = OILGLoginDlg() SWITCH CASE RetValue = 0: ; OK in preverjen RETURN True CASE RetValue = 1: ; CANCEL RETURN False CASE RetValue = 2: ; Help ENDSWITCH ENDWHILE RETURN False ENDPROC ; OILGLogin - prijavljanje na sistem
KEYDISABLE -130, -131
SETCANVAS DEFAULT CLEAR ConnectType = 1 IF NOT ISRUNTIME() THEN Message "SYS001: Ne morem se vkljuciti v program" Sleep 5000 Message "" QUIT ENDIF ConnectType = 0 ConnectName = "onko" ConnectPass = "onko" ConnectProduct = "ORACLE" ConnectBase = "@t:192.168.4.8/1521:pp80"
PROC DBConnect(aName,aPass,aBase) PRIVATE OILGcDir
OILGcDir = DIRECTORY() SETDIR OI_PdoxPath ; MESSAGE "Pripravljam povezavo z bazo podatkov" SQLRELEASE ; sqlclearconnect SQLSELECTCONNECT PRODUCT ConnectProduct VALUES aName, aPass, aBase SETDIR OILGcDir
IF NOT RetVal THEN MESSAGE "Napaka na datoteŸnem stre§niku: "+ConnectProduct+"/"+aBase SLEEP 2000 RETURN False ENDIF
RETURN True ENDPROC
WRITELIB LibName DBConnect RELEASE PROCS DBConnect
|
|
Posted 20 years ago (Thread Starter)
|
|
| About matjazc |
|
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
|
Email Not Verified!
Once email is verified, we will review and approve the account.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #11129, 2 replies
Thread Started 6/15/2005 5:05:00 AM
View Counter=3031
Last Reply Posted 1/3/2018 12:00:27 AM)
|
|
|
|
Location=-- USA
|
|
 |
|
|
|
Tony M
|
|
SETCANVAS? CLEAR? WRITELIB? RELEASE PROCS?
That sure looks like Paradox DOS.
Why do you say 4.5 *Win*?
|
|
Posted 20 years ago
|
|
| About Tony M |
|
Inactive member.
Member does not subscribe to this thread.
Post ID #11130 (Level 1.1)
Reply to 11129
Thread Started 6/15/2005 6:05:00 AM
View Counter=2
|
|
|
|
Location=
|
|
 |
Most Recent Post
|
|
|
matjazc
|
|
I've checked readme file in /pdoxrun directory and it also said something like this:
TABLE OF CONTENTS -----------------
1. Contacting Borland 2. Using Paradox Runtime with Windows or OS/2 3. Notes on TUTILITY
... I guess I've made wrong assumption.
|
|
Posted 20 years ago (Thread Starter)
|
|
| About matjazc |
|
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
|
Email Not Verified!
Once email is verified, we will review and approve the account.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #11131 (Level 1.2)
Reply to 11129
Reply Posted 6/15/2005 7:53:00 AM
|
|
|
|
Location=-- USA
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
| Thread #11129 Counter |
| 3031 |
|
Since 4/2/2008
|
|
|