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: <u2-users@listserver.u2ug.org> 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 = 00000 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/
