Hi,
We are using Oracle 8.1.5 with NT 4. It all runs on the same box. Maybe by
chance but we managed to connect first time. Here are some settings which
may be of help:
1. We use ODBC with Oracle ODBC driver.
2. tnsnames.ora entry for the service used by ODBC:
ORASERV1 =
(DESCRIPTION =
(SOURCE_ROUTE = OFF)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(Key = oraserv1))
(ADDRESS = (PROTOCOL = TCP)(HOST = compserv01)(PORT = 1521))
(ADDRESS = (PROTOCOL = NMP)(Server = compserv01)(Pipe = ORAPIPE))
)
(CONNECT_DATA =
(SID = oraserv1)
(SRVR = DEDICATED)
)
)
where: 'oraserv1' is the database SID, 'compserv01' is server's name
Your listener should be configured to use any of these protocols. Possibly
all of them.
3. Settings used in data-sources.xml
<data-source
class="com.evermind.sql.ConnectionDataSource"
name="Oracle"
location="jdbc/DefaultCoreDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultDS"
connection-driver="sun.jdbc.odbc.JdbcOdbcDriver"
username="danny"
password="murphy"
url="jdbc:odbc:yourdsn"
inactivity-timeout="30"
/>
where 'yourdsn' is the ODBC DSN name.
Hope this is of help.
Jarek
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of John N. Alegre
> Sent: 24 November 2000 19:40
> To: Orion-Interest
> Subject: Re: DB changes not reflected in CMP bean.
>
>
> We have got this to work on Oracle running on Solaris and Linux. All
> attempts to use Oracle 8.1.5 on NT are failing. The error returned by
> Orion shows a failure in TNS lookup. However, we can write
> straight Java JDBC
> code and connect just fine. sqlnet also connects just fine using
> the same URL
> and driver. The failure only occurs on NT Oracle with Orion.
>
> I would be glad to elaborate with error codes and sample Java
> source files if
> desired.
>
> Is anyone using Oracle on NT with Orion?
>
> Peace
> john
> On 24-Nov-00 Sven van 't Veer wrote:
> >
> >
> > To connect to Oracle you would need the oracle type4 jdbc
> drivers and create
> > a
> > datasource in orion/config/data-sources.xml.
> >
> >
> >
> > Sven
> >
> >
> > --
> >
> ==================================================================
> ============
> > ========
> >
> > Sven E. van 't Veer
> > http://www.cachoeiro.net
> > Java Developer [EMAIL PROTECTED]
> >
> ==================================================================
> ============
> > ========
> >
> >
> >
>
> ----------------------------------
> E-Mail: John N. Alegre <[EMAIL PROTECTED]>
> Date: 24-Nov-00
> Time: 13:32:46
>
> This message was sent by XFMail
> ----------------------------------
>
