srini, i think you need to have the OCILIBPATH set to the path of the libraries, and not to the actual filename. on osx i just have "libclntsh.dylib" in that directory, and on solaris i have a "libclntsh.so" (amongst others). i'm not sure about the file with "jdbc" in the name.
also, on my box, i don't have ODBCDMLIBRARY set to anything at all...i don't think that should matter, but if you aren't using odbc, then you don't need it. in terms of your other message (asking about the startup files), i use the witango sample file... "/usr/local/witango_5.5/install/SampleFiles/start_witango.sh" and just comment out the ODBCINI stuff and add the ORACLE_HOME stuff that i gave you before. everything else is exactly the same. cheers, russell "Srinivasan" <[EMAIL PROTECTED]> wrote on 25/03/2004 06:41:11 AM: > Hi, > I get the following error when I try to access my taf files that interacts > with DB > [ 943] 2004-03-24 09:43:54 RUNTIME INFO No existing connection to > the data source found, creat > ng a new connection. DSN: oracle.cl; User: ; > [ 943] 2004-03-24 09:43:54 RUNTIME WARNING Unable to open to oracle.cl > due to an error during con > ection > [ 943] 2004-03-24 09:43:54 RUNTIME INFO Total Connection in > Datasource Pool: 0 Max connections > for the host: 0 Current connections in use for the host: 0 > Please advice me on what setting i need to do. > My witango.ini has the following: > [Witango Definitions] > WitangoServer= > [WitangoServer] > ABSOLUTEPATHPREFIX= > ALTUSERKEY=<@CGIPARAM CLIENT_IP> > APPCONFIGFILE=/usr/local/witango_5.5/configuration/applications.ini > APPLICATIONSWITCH=on > APREFIX=<TABLE BORDER="1"> > ASUFFIX=</TABLE> > CACHE=false > CACHEINCLUDEFILES=false > CACHESIZE=2000000 > CDELIM=, > CONFIGPASSWD=s28ep9dykqdt > CPREFIX=<TD> > CRONTABFILE= > CSUFFIX=</TD> > CURRENCYCHAR=$ > CUSTOMSCOPESWITCH=off > CUSTOMTAGSPATH=/usr/local/witango_5.5/configuration/CustomTags > DATASOURCELIFE=30 > DATEFORMAT=%m/%d/%Y > DBDECIMALCHAR=. > DEBUGMODE=AppFileSetting > DECIMALCHAR=. > DEFAULTERRORFILE=/usr/local/witango_5.5/configuration/error.htx > DEFAULTSCOPE=request > DOCSSWITCH=on > DOMAINCONFIGFILE=/usr/local/witango_5.5/configuration/domains.ini > DOMAINSCOPEKEY=<@CIPHER action=hash str=<@LOWER <@DOMAIN>>> > DSCONFIG= > DSCONFIGFILE= > ENABLETANGOUSERDOCS=false > ENCODERESULTS=true > EXTERNALSWITCH=on > FILEDELETESWITCH=on > FILEREADSWITCH=on > FILEWRITESWITCH=on > FMDATABASESDIR= > HEADERFILE=/usr/local/witango_5.5/configuration/Header.htx > ITEMBUFFERSIZE=65535 > JAVASCRIPTSWITCH=on > JAVASWITCH=on > JAVAVIRTUALMACHINE=/usr/j2se/jre/lib/sparc/client/libjvm.so > LICENSE=C4VT8-B5GYJ-7N07B-D1NBK-B21GL-L700 > LIMITURLTHREADS= > LISTENERADDRESS= > LISTENERPORT=18100 > LOGDIR=/usr/local/witango_5.5/configuration/log.WitangoServer > LOGGINGLEVEL=1 > LOGTORESULTS=FALSE > MAILDEFAULTFROM=jessica > MAILPORT=25 > MAILSERVER=127.0.0.1 > MAILSWITCH=on > MAXACTIONS=0 > MAXHEAPSIZE=50000000 > NOSQLENCODING=false > OBJECTCONFIGFILE=/usr/local/witango_5.5/configuration/objects.ini > OCILIBPATH=/export/db0/app/oracle/product/8.0.6/lib/liboci806jdbc.so > ODBCDMLIBRARY=/usr/local/lib/libiodbc.so > PASSTHROUGHSWITCH=on > PERSISTENTRESTART=false > PIDFILE=/usr/local/witango_5.5/configuration/pid.WitangoServer > POSTARGFILTER= > PROCESSAFFINITY=ALL > QUERYTIMEOUT=300 > RDELIM=; > REQUESTQUEUELIMIT=0 > RETURNDEPTH=20 > RPREFIX=<TR> > RSUFFIX=</TR> > SHUTDOWNURL= > STARTSTOPTIMEOUT=60 > STARTUPURL= > STATICNUMERICCHARS=true > STRIPCHARS=true > TCFSEARCHPATH=<@APPFILEPATH>;<@CLASSFILEPATH>;/Witango/TCF/ > THOUSANDSCHAR=, > THREADPOOLSIZE=20 > TIMEFORMAT=%H:%M:%S > TIMEOUTHTML=/usr/local/witango_5.5/configuration/timeout.html > TIMESTAMPFORMAT=%m/%d/%Y %H:%M:%S > USERAGENT= > USERKEY=<@USERREFERENCE> > VALIDHOSTS=63.165.43.40:192.168.100.40 > VARCACHEPATH=/usr/local/witango_5.5/configuration/variables.WitangoServer > VARIABLETIMEOUT=30 > VARIABLETIMEOUTTRIGGER= > ---------------------------------------------------------------------------- > ------------------------------------------------ > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ForwardSourceID:NT0001038E -------------------------------------------------------------- Russell Stephany Lead Developer, Information Technology Australian Graduate School of Management UNSW SYDNEY NSW 2052 Australia Tel: +61 2 9931-9263 Fax: +61 2 9931-9349 Email: [EMAIL PROTECTED] Web: http://www.agsm.edu.au The Australian Graduate School of Management is a School of both The University of Sydney & The University of New South Wales. CRICOS Provider Number: 00098G ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
