Ora 01001 error

[Pallavi]

Platform - Sun Solaris
NES Version 3.63
Database: Oracle 8i

The web application using ssjs creates a dbpool object to connect to a
Oracle8i database. This returns a error ORA-01001 even if no such
database exists.
Pls suggest.

Thanks
Pallavi

[Robert Stewart]

Hi,

If you have both the NES 3.6 and the Oracel 8i on the same machine
you'll have problems.

NES 3.6 doesn't work with the SQL*net version that comes with Oracle 8.x

You either have to put them on different machines (which would be my
choice anyway) and add the Oracle 7.3.x client to the web sever, or
you need to upgrade the web server to iPlantet 4.x.

--
Robert Stewart

Software Development Division
ARDUC Corporation
5-13-16 Shimizu
Asahi-ku
Osaka, 535-0021
Japan
Tel:(+81) 06-6956-8088 FAX: (+81) 06-6956-1238
e-mail: robert-...@arduc.co.jp

[Pallavi]

Thanks will try that out.
In this case would simply working with ODBC using Oracle 8i drivers work?

Pallavi

"Robert Stewart" <robert-...@arduc.co.jp> wrote in message
news:3A18658F...@arduc.co.jp...

[Robert Stewart]

Hi,

No, I don't think so.

I'm not sure abut UNIX, but I know on NT, Oracle doesn't like to have
2 different client versions on the same machine.

[Barry Hathaway]

I would advise against upgrading to 4.x for Livewire applications.
4.x is based on the Gecko engine and supports Javascript 1.4
vs. Javascript 1.2. In my opinion code base is not only unstable
but broken. Methods attached project and server objects do
not recognize global variables, like the entire request object!
Save yourself the headaches and just install the Oracle 7.3.x
client as Robert suggested. It only takes about 10 minutes.

Barry Hathaway