SQL ERROR 9293

[venkat]

We are undergoing TD 5.2 migration from TD 3.1.

While running the migrated code we are getting SQL ERROR 9293.

But when I tried running the code from the TD installation directory (C:\Program Files\Unify\Team Developer 5.2), its working fine.

Please help me out.

DB and PC details

Data Base : Oracle 8i
Client : orace 9 i
OS : XP sp3
TD : 5.2

SQL.ini file

[dbntsrv]
dbname=ISLAND,sqlws32
servername=Server1,sqlws32
cache=2000
sortcache=2000
readonly=0
oracleouterjoin=0
logfileprealloc=0
partitions=0
optimizerlevel=2
ansijoinsyntax=0
dbdir=C:\Program Files\Unify\Team Developer 5.2

[dbntsrv.dll]
comdll=sqlws32

[win32client]
clientname=01HW247030
clientruntimedir="C:\Program Files\Unify\Team Developer 5.2"

[win32client.dll]
comdll=sqlws32
comdll=sqlora32

[win32client.ws32]
serverpath=server1,localhost/island

;[win32client.ws32]
; Resource Manager (sqlmpipe uses port 2156 explicitly declared instead of
; default port 2155
;serverpath=server1,localhost,2156/*
[oragtwy]
remotedbname=TEST,@TEST.SQ.COM.SG
remotedbname=ora10g,@tns:ora10db
longbuffer=32767
fetchrow=20
[odbcrtr]
odbctrace=off
odbctracefile=sql.log
[sybgtwy]
remotedbname=sys10,SERVERNAME,DBNAME
longbuffer=32650
locktimeout=0
sybautocommit=off
yieldonservercall=0
sybworkstationname=workstation_name
sybapplicationname=Gupta Sybase App
checkexists=off
fetchrow=20
enablemultipleconnections=off
closecursorateof=off

[Jeff Luther]

Check your PATH

[venkat]

Do you mean PATH variable?.

[Jeff Luther]

Yes, if you have to run something local to the TD install folder, but cannot run it outside, that tells me that your PATH variable does not have v.52 in the PATH or there is another TD version before v5.2. In either case, your 5.2 app has to find 5.2 install in the PATH to be able to run outside the install folder.