subject:"\[U2\] Unidata\/Oracle connection problem"

RE: [U2] Unidata/Oracle connection problem

2006-08-03 Thread Angelo Collazo

Sara,

Is your UniVerse a 32bit or 64bit dbms?

Cheers,

Angelo

We have been transferring data from UniVerse to Oracle and SQLServer for
many years now using the BCI.  We also query those databases and bring data
to UniVerse also using BCI.

We use Openlink software  http://www.openlinksw.com/
   as the ODBC Manager which is linked into
UniVerse.  Works very well.  Our users expect real-time replication of data
as they create it in UniVerse and expect to be able to use in immediately in
Oracle.  Normally this expectation is satisfied.

Sara Burns

Sara Burns (SEB)


Integration Manager

Public Trust
Phone: +64 (04) 978 4534 (DDI)

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>


The information contained in this communication (including any attachment)
is confidential. If you are not the intended recipient, please destroy this
communication. You must not disclose, copy or use in any way the information
contained in this communication. Any views expressed in this communication
are not necessarily the views of Public Trust. No representation is made
that this communication is free of error, virus or interference.

.



A family trust can help you protect your assets if the unexpected happens.
To find out how a family trust works and if one's right for you, call 0800
505 405.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Unidata/Oracle connection problem

2006-08-02 Thread Sara Burns

We have been transferring data from UniVerse to Oracle and SQLServer for
many years now using the BCI.  We also query those databases and bring data
to UniVerse also using BCI.
 
We use Openlink software  http://www.openlinksw.com/
   as the ODBC Manager which is linked into
UniVerse.  Works very well.  Our users expect real-time replication of data
as they create it in UniVerse and expect to be able to use in immediately in
Oracle.  Normally this expectation is satisfied.
 
Sara Burns
 
Sara Burns (SEB) 


Integration Manager

Public Trust 
Phone: +64 (04) 978 4534 (DDI) 

Mobile: 027 457 5974
<  mailto:[EMAIL PROTECTED]>

 
The information contained in this communication (including any attachment)
is confidential. If you are not the intended recipient, please destroy this
communication. You must not disclose, copy or use in any way the information
contained in this communication. Any views expressed in this communication
are not necessarily the views of Public Trust. No representation is made
that this communication is free of error, virus or interference.

.

 

A family trust can help you protect your assets if the unexpected happens. 
To find out how a family trust works and if one's right for you, call 0800 505 
405.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

2006-08-02 Thread Angelo Collazo

Here you go.
http://www.easysoft.com/

Cheers,

Angelo

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor
Sent: Wednesday, August 02, 2006 9:54 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata/Oracle connection problem

   Yes

   Actually  we  identified another problem. That being the fact that the
   Oracle  client  on  Unix did NOT include an ODBC driver from what I am
   being  told.   We  are  investigating other commercial and open source
   drivers.  If anyone has any suggestions it would be appreciated.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  "Angelo
   Collazo" <[EMAIL PROTECTED]>
   Sent: Tuesday, August 01, 2006 4:36 PM
   To: 
   Subject: RE: [U2] Unidata/Oracle connection problem

   Richard,
   Did you do a relink.udlibs? That is what CONNECT uses.
   Cheers,
   Angelo
   More info on this:
   I was able to successfully use the Oracle Client using SQLplus.
   However attempts to use CONNECT from the tcl prompt return the
   following:
   SQLConnect error: Status = -1 SQLState = 0 Natcode = 3349920
   We think our problem is in the libodbc.sl (HPUX version 11). This is
   still linked to the file in the Unidata application path. We can not
   find any other occurrence of this file. This is the ODBC Driver
   manager and I believe that this is necessary.
   Can anyone point out what you are using for this and where you got the
   file?
   Thanks
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   __
   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED] On Behalf Of Richard
   Taylor
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem
   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@l

RE: [U2] Unidata/Oracle connection problem

2006-08-02 Thread Shin.Tanaka

Did you run $UDTBIN/relink.udlibs ?

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor
Sent: Tuesday, August 01, 2006 3:05 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata/Oracle connection problem

   More info on this:

   I  was  able  to  successfully  use  the  Oracle Client using
SQLplus.
   However  attempts  to  use  CONNECT  from  the  tcl  prompt return
the
   following:

   SQLConnect error:  Status = -1  SQLState = 0  Natcode = 3349920

   We  think our problem is in the libodbc.sl (HPUX version 11).  This
is
   still  linked to the file in the Unidata application path.  We can
not
   find  any  other  occurrence  of  this  file.  This is the ODBC
Driver
   manager and I believe that this is necessary.

   Can anyone point out what you are using for this and where you got
the
   file?

   Thanks

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the
most
   complex,   time-sensitive  marketing  challenges  through
consulting,
   creative,   research,   direct,   media,  technology,  and
production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
 
__

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of
Richard
   Taylor <[EMAIL PROTECTED]>
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem

   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

2006-08-02 Thread Richard Taylor

   Yes

   Actually  we  identified another problem. That being the fact that the
   Oracle  client  on  Unix did NOT include an ODBC driver from what I am
   being  told.   We  are  investigating other commercial and open source
   drivers.  If anyone has any suggestions it would be appreciated.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  "Angelo
   Collazo" <[EMAIL PROTECTED]>
   Sent: Tuesday, August 01, 2006 4:36 PM
   To: 
   Subject: RE: [U2] Unidata/Oracle connection problem

   Richard,
   Did you do a relink.udlibs? That is what CONNECT uses.
   Cheers,
   Angelo
   More info on this:
   I was able to successfully use the Oracle Client using SQLplus.
   However attempts to use CONNECT from the tcl prompt return the
   following:
   SQLConnect error: Status = -1 SQLState = 0 Natcode = 3349920
   We think our problem is in the libodbc.sl (HPUX version 11). This is
   still linked to the file in the Unidata application path. We can not
   find any other occurrence of this file. This is the ODBC Driver
   manager and I believe that this is necessary.
   Can anyone point out what you are using for this and where you got the
   file?
   Thanks
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   __
   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED] On Behalf Of Richard
   Taylor
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem
   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

2006-08-01 Thread Angelo Collazo

Richard,

Did you do a relink.udlibs? That is what CONNECT uses.

Cheers,

Angelo


   More info on this:

   I  was  able  to  successfully  use  the  Oracle Client using SQLplus.
   However  attempts  to  use  CONNECT  from  the  tcl  prompt return the
   following:

   SQLConnect error:  Status = -1  SQLState = 0  Natcode = 3349920

   We  think our problem is in the libodbc.sl (HPUX version 11).  This is
   still  linked to the file in the Unidata application path.  We can not
   find  any  other  occurrence  of  this  file.  This is the ODBC Driver
   manager and I believe that this is necessary.

   Can anyone point out what you are using for this and where you got the
   file?

   Thanks

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  Richard
   Taylor <[EMAIL PROTECTED]>
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem

   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

2006-08-01 Thread Richard Taylor

   More info on this:

   I  was  able  to  successfully  use  the  Oracle Client using SQLplus.
   However  attempts  to  use  CONNECT  from  the  tcl  prompt return the
   following:

   SQLConnect error:  Status = -1  SQLState = 0  Natcode = 3349920

   We  think our problem is in the libodbc.sl (HPUX version 11).  This is
   still  linked to the file in the Unidata application path.  We can not
   find  any  other  occurrence  of  this  file.  This is the ODBC Driver
   manager and I believe that this is necessary.

   Can anyone point out what you are using for this and where you got the
   file?

   Thanks

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
   __

   From: [EMAIL PROTECTED]
   [mailto:[EMAIL PROTECTED]   On   Behalf  Of  Richard
   Taylor <[EMAIL PROTECTED]>
   Sent: Monday, July 31, 2006 3:19 PM
   To: u2-users@listserver.u2ug.org
   Subject: [U2] Unidata/Oracle connection problem

   I am attempting to setup a data source under Unix to allow access to
   an Oracle database. I am having a lot of trouble getting this to
   work.
   I have:
   7 Installed the oracle client
   7 Setup a place to hold the driving library
   7 Setup a folder to hold my odbc.ini file and set the
   ODBCSYSINI environment variable to point there.
   7 I created the odbc.ini file as shown below.
   7 My oracle dba also did some configuration setup for the
   Oracle client and was able to connect through the client.
   [DV83]
   Driver=/usr/local/lib/hsdb_odbc.sl
   Description=Oracle ODBC on test system
   SERVER=testserver
   PORT=1521
   USER=test_user
   Password=**
   Database=DV83
   OPTION=3
   SOCKET=
   TraceFile=/production/udtmp/odbc_rich.trace
   Trace=1
   Can anyone tell me if they have successfully gotten a BCI connection
   going to Oracle and how you did it. By the way I am on an HP Unix
   system.
   Thanks in advance for any help.
   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS
   250 W. Pratt Street | Baltimore, MD 21201
   P 410.361.8688 | F 410.454.8392
   [EMAIL PROTECTED] | http://www.vertisinc.com
   Vertis Communications - Partnering with clients to solve the most
   complex, time-sensitive marketing challenges through consulting,
   creative, research, direct, media, technology, and production
   services.
   "The more they complicate the plumbing
   the easier it is to stop up the drain"
   - Montgomery Scott NCC-1701
   ---
   u2-users mailing list
   u2-users@listserver.u2ug.org
   To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

2006-07-31 Thread Angelo Collazo

Rich,

One important issue to know is to determine if you need a 64 or 32 bit UNIX
driver. Also what is your .udlibs soft link look like? Hope this helps.


Take a look-see at this link.
http://www.easysoft.com/cgi-bin/search/search.cgi



Cheers,

Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor
Sent: Monday, July 31, 2006 3:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata/Oracle connection problem

   I  am  attempting to setup a data source under Unix to allow access to
   an  Oracle  database.   I  am  having a lot of trouble getting this to
   work.

   I have:

   7Installed the oracle client

   7Setup a place to hold the driving library

   7 Setup  a  folder  to  hold  my  odbc.ini  file  and  set the
   ODBCSYSINI environment variable to point there.

   7I created the odbc.ini file as shown below.

   7 My  oracle  dba  also  did  some configuration setup for the
   Oracle client and was able to connect through the client.

   [DV83]

   Driver=/usr/local/lib/hsdb_odbc.sl

   Description=Oracle ODBC on test system

   SERVER=testserver

   PORT=1521

   USER=test_user

   Password=**

   Database=DV83

   OPTION=3

   SOCKET=

   TraceFile=/production/udtmp/odbc_rich.trace

   Trace=1

   Can  anyone  tell me if they have successfully gotten a BCI connection
   going  to  Oracle  and  how  you did it. By the way I am on an HP Unix
   system.

   Thanks in advance for any help.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Unidata/Oracle connection problem

2006-07-31 Thread Richard Taylor

   I  am  attempting to setup a data source under Unix to allow access to
   an  Oracle  database.   I  am  having a lot of trouble getting this to
   work.

   I have:

   7Installed the oracle client

   7Setup a place to hold the driving library

   7 Setup  a  folder  to  hold  my  odbc.ini  file  and  set the
   ODBCSYSINI environment variable to point there.

   7I created the odbc.ini file as shown below.

   7 My  oracle  dba  also  did  some configuration setup for the
   Oracle client and was able to connect through the client.

   [DV83]

   Driver=/usr/local/lib/hsdb_odbc.sl

   Description=Oracle ODBC on test system

   SERVER=testserver

   PORT=1521

   USER=test_user

   Password=**

   Database=DV83

   OPTION=3

   SOCKET=

   TraceFile=/production/udtmp/odbc_rich.trace

   Trace=1

   Can  anyone  tell me if they have successfully gotten a BCI connection
   going  to  Oracle  and  how  you did it. By the way I am on an HP Unix
   system.

   Thanks in advance for any help.

   Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS

   250 W. Pratt Street | Baltimore, MD 21201

   P 410.361.8688 | F 410.454.8392

   [EMAIL PROTECTED] | http://www.vertisinc.com

   Vertis  Communications  -  Partnering  with  clients to solve the most
   complex,   time-sensitive  marketing  challenges  through  consulting,
   creative,   research,   direct,   media,  technology,  and  production
   services.

   "The more they complicate the plumbing

 the easier it is to stop up the drain"

   - Montgomery Scott NCC-1701
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Unidata/Oracle connection problem

[U2] Unidata/Oracle connection problem

RE: [U2] Unidata/Oracle connection problem

RE: [U2] Unidata/Oracle connection problem

RE: [U2] Unidata/Oracle connection problem

RE: [U2] Unidata/Oracle connection problem

RE: [U2] Unidata/Oracle connection problem

RE: [U2] Unidata/Oracle connection problem

[U2] Unidata/Oracle connection problem

9 matches

Site Navigation

Mail list logo

Footer information