Connecting to Oracle from SqlBase (Gupta)

[chrisocm65]

I hv problem connecting to Oracle.
Can somebody help me on the sql.ini file. What to add in and how to connect to oracle database? 

[chrisocm65]

To complement my earlier question.

The database sits on another machine on a network with certain ip address, user and password.

My sql.ini file is as below. what shld i put in the sql.ini file so that I can connect to the oracle db.

Code: Select all

[dbnt1sv]servername=Server1,sqlapipe
centurydefaultmode=1
dbdir=e:
databasedbname=mansion,sqlapipedbname=litefrm,sqlapipecache=2000logdir=e:sqlbase_logsoracleouterjoin=0partitions=0secureapi=0dbname=ansyrah,sqlapipedbname=peladang,sqlapipeDBNAME=GLOBAL,SQLAPIPEDBNAME=STEELBIZ,SQLAPIPE[dbnt1sv.dll]comdll=sqlapipe[dbnt1sv.apipe];debug=15,dbntsrv.dbg[win32client]clientname=Win32Client[win32client.dll]comdll=sqlapipe;comdll=sqlws32;comdll=sqlwsspx;comdll=sqlntnbi

[win32client.apipe];debug=15,client.dbg[win32client.ws32];serverpath=server1,localhost/island[dbnt1sv.gui]MAINWIN=MAX,395,224,885,576STATWIN=NORM,640,365,1280,730DBWIN=NORM,640,0,1280,365PROCWIN=NORM,0,365,640,730SYSWIN=NORM,0,0,640,365DISPLEVEL=0TIMESTAMPS=0[win32client.wsspx];
[win32client.ntnbi];

Thanks 

[Steve Leighton]

You have nothing in your 'Oragtwy' section.

Try:

[oragtwy]
remotedbname=test@test
fetchrow=20
substitute=SYSSQL.

'test' is your dB name and '@test' is an alias for the dB name in TNSNames.ora
You dont need any sections starting  'dbnt1sv' unless you are running SQLBase , but it wont matter if they are there.