Repost - Install questions

[Nick Gorham]

HAS wrote:

>Sorry about the repost, but I posted the last one before my joining the group
>was completed and the moderator never released it.
>
>Please bear with the Unix clueless.  A lot of this is trying to understand,
>not necessarily being thought of as good ideas, but I want to know what is
>possible and what is not possible.
>
>When you build unixODBC-2.2.12 and do make install, outside of all the files
>it places in the various directories, does it do anything that would change
>any system startup files, add any environment variables?
>
>Same question if you use one of the packages from the unixodbc site to
>install it.
>
>If you didn't have access to root and you did the install and used the
>--prefix to send the files to a directory you had access to, is it possible
>to make it work?
>
>If yes, what would you have to do?  I'm guessing add the installed lib dir
>to the LD_LIBRARY_PATH and the installed bin dir to the PATH.  Maybe set the
>ODBCINI?  If this is possible please correct/add to remove to these three
>items.
>
>  
>

Hi,

All that is ok and correct. There is no startup as its not a daemon
process. I guess the question is what are you intending to do with
unixODBC, knowing that would allow a better answer for you.

--
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[HAS]

Sorry about the repost, but I posted the last one before my joining the group was completed and the moderator never released it.

Please bear with the Unix clueless.  A lot of this is trying to understand, not necessarily being thought of as good ideas, but I want to know what is possible and what is not possible.

When you build unixODBC-2.2.12 and do make install, outside of all the files it places in the various directories, does it do anything that would change any system startup files, add any environment variables?

Same question if you use one of the packages from the unixodbc site to install it.

If you didn't have access to root and you did the install and used the --prefix to send the files to a directory you had access to, is it possible to make it work?

If yes, what would you have to do?  I'm guessing add the installed lib dir to the LD_LIBRARY_PATH and the installed bin dir to the PATH.  Maybe set the ODBCINI?  If this is possible please correct/add to remove to these three items.

If no, if you have someone with root access install the package for 2.1.x is an upgrade possible by deleting/replacing the files?

Thanks in advance for any insights.

[Nick Gorham]

HAS wrote:

>>All that is ok and correct. There is no startup as its not a daemon
>>process. I guess the question is what are you intending to do with
>>unixODBC, knowing that would allow a better answer for you.
>>    
>>
>
>Being used to communicate between kdb+ (q) and Oracle.  It was done before
>at this location but person charged with creating a how to document didn't
>and left.  Turn around time with DBA's with root access is minimum one day
>per question so I'd like to work it out in a non root environment and once
>I'm comfortable it's working and I have good instructions I want to forward
>it to those with root access.
>  
>

Ok, all you need is unixODBC and a Oracle driver then. Should be fine as
non root. assuming you can setup any Oracle client info needed if its
not using instantclient.

--
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[HAS]

> All that is ok and correct. There is no startup as its not a daemon
> process. I guess the question is what are you intending to do with
> unixODBC, knowing that would allow a better answer for you.

Being used to communicate between kdb+ (q) and Oracle.  It was done before at this location but person charged with creating a how to document didn't and left.  Turn around time with DBA's with root access is minimum one day per question so I'd like to work it out in a non root environment and once I'm comfortable it's working and I have good instructions I want to forward it to those with root access.

[HAS]

> Ok, all you need is unixODBC and a Oracle driver then. Should be fine as
> non root. assuming you can setup any Oracle client info needed if its
> not using instantclient.

I got stuck with this error: [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

I looked in the forum and saw some info relating to DB2 and did some net searches and found others with the same problem but no solution.  tnsping works and I can use sqlplus and other utilities to connect to oracle.  Any thoughts on what this error message is actually telling me and perhaps how to resolve it?

Thanks.

[Nick Gorham]

HAS wrote:

>>Ok, all you need is unixODBC and a Oracle driver then. Should be fine as
>>non root. assuming you can setup any Oracle client info needed if its
>>not using instantclient.
>>    
>>
>
>I got stuck with this error: [IM004][unixODBC][Driver Manager]Driver's
>SQLAllocHandle on SQL_HANDLE_HENV failed
>
>I looked in the forum and saw some info relating to DB2 and did some net
>searches and found others with the same problem but no solution.  tnsping
>works and I can use sqlplus and other utilities to connect to oracle.  Any
>thoughts on what this error message is actually telling me and perhaps how
>to resolve it?
>
>Thanks.
>
>  
>

What driver are you using, show us your odbcinst.ini and odbc.ini

--
Nick
_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[HAS]

> What driver are you using, show us your odbcinst.ini and odbc.ini

Below are both, the last line of the odbc.ini is something I am playing around with, I think the answer is related to that, something needs to be defined that isn't, but that's just based on what I've found on this forum and the net searches.

> odbcinst.ini

[Oracle10gODBCDriver]
Description   = Oracle 10g Linux ODBC driver
Driver        = /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
Setup         =
FileUsage     =
CPTimeout     =
CPReuse       =

[ODBC]
DEBUG = 1
TraceFile = /export/home/tcaadmin/howard/sql.log
Trace = Yes

> odbc.ini

[IEQQ2]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle10gODBCDriver
DSN = IEQQ2
EXECSchemaOpt =
EXECSyntax = T
Failover = T
FailoverDelay = 10
FailoverRetryCount = 10
FetchBufferSize = 64000
ForceWCHAR = F
Lobs = T
Longs = T
MetadataIdDefault = F
QueryTimeout = T
ResultSets = T
ServerName = ieqq2
SQLGetData extensions = F
Translation DLL =
Translation Option = 0
UserID = tca_read_user
DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0}

[Stefan Radman]

It's most likely not a uniXODBC but an Oracle driver issue.

If you are using instantclient-basiclite have a look at this thread
http://forums.oracle.com/forums/thread.jspa?messageID=1433370

That solved it for me.

Stefan

> -----Original Message-----
> From: unixodbc-support-bounces@...
> [mailto:unixodbc-support-bounces@...] On Behalf Of HAS
> Sent: Tuesday, 12 June, 2007 22:24
> To: unixodbc-support@...
> Subject: Re: [unixODBC-support] Repost - Install questions
>
>
> > What driver are you using, show us your odbcinst.ini and odbc.ini
>
> Below are both, the last line of the odbc.ini is something I
> am playing
> around with, I think the answer is related to that, something
> needs to be
> defined that isn't, but that's just based on what I've found
> on this forum
> and the net searches.
>
> > odbcinst.ini
>
> [Oracle10gODBCDriver]
> Description   = Oracle 10g Linux ODBC driver
> Driver        =
> /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
> Setup         =
> FileUsage     =
> CPTimeout     =
> CPReuse       =
>
> [ODBC]
> DEBUG = 1
> TraceFile = /export/home/tcaadmin/howard/sql.log
> Trace = Yes
>
> > odbc.ini
>
> [IEQQ2]
> Application Attributes = T
> Attributes = W
> BatchAutocommitMode = IfAllSuccessful
> CloseCursor = F
> DisableDPM = F
> DisableMTS = T
> Driver = Oracle10gODBCDriver
> DSN = IEQQ2
> EXECSchemaOpt =
> EXECSyntax = T
> Failover = T
> FailoverDelay = 10
> FailoverRetryCount = 10
> FetchBufferSize = 64000
> ForceWCHAR = F
> Lobs = T
> Longs = T
> MetadataIdDefault = F
> QueryTimeout = T
> ResultSets = T
> ServerName = ieqq2
> SQLGetData extensions = F
> Translation DLL =
> Translation Option = 0
> UserID = tca_read_user
> DMEnvAttr =
> SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/ieqqammk1/oracle/produ
> ct/10.2.0}
>
>
> --
> View this message in context:
> http://www.nabble.com/Repost---Install-questions-tf3908337.htm
> l#a11086258
> Sent from the unixODBC - Support mailing list archive at Nabble.com.
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support@...
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[HAS]

> It's most likely not a uniXODBC but an Oracle driver issue.
>
> If you are using instantclient-basiclite have a look at this thread
> http://forums.oracle.com/forums/thread.jspa?messageID=1433370

Thanks for the info.  I looked at the thread and unless I'm missing something I see two things, copying from windows (which I didn't) and Basic vs Basic lite.  Anyone know if there is a way to determine which was installed?  I didn't do the install, it's unlikely it was the lite but always good to rule things out.

I don't doubt the problem is some missing env variable or file and that it's more than likely related to the driver itself, but according to one document I found online, IM messages are from the driver manager, so maybe there is a way to get more detail on what it's really complaining about.  I'm going to try and see if I can match the trace log to the program code, but if anyone has thoughts or answer don't let that stop you from sharing!  Thanks.

[Nick Gorham]

HAS wrote:

>>the last line of the odbc.ini is something I am playing around with, I
>>    
>>
>think the answer is related to that, > something needs to be defined that
>isn't, but that's just based on what I've found on this forum and the > net
>searches.
>
>  
>
>>DMEnvAttr =
>>SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0}
>>    
>>
>
>Below is from the trace log, I notice the ret = -1, which makes me think I
>have a bad syntax in the odbc.ini?  Well at least it makes me think it's not
>working but I don't know exactly where in the code that's getting written to
>the log.  I'll keep tracing code for now.
>
>[SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0] ret
>= -1
>
>
>[ODBC][19126][SQLConnect.c][3586]
>                Entry:
>                        Connection = 27978
>                        Server Name = [IEQQ2][length = 5 (SQL_NTS)]
>                        User Name = [tca_read_user][length = 13 (SQL_NTS)]
>                        Authentication = [*************][length = 13
>(SQL_NTS)]
>                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
>'UCS-2BE'
>
>                ENV ATTR
>[SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0] ret
>= -1
>
>[ODBC][19126][SQLConnect.c][1315]Error: IM004
>
>  
>

I just checked, thats a typo in the driver manager code, ignore the -1.
Its not the problem here.

The error you are getting either means the driver lib is failing when
the driver manager calls SQLAllocEnv or SQLAllocHandle for a environmant
handle.

--
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[HAS]

> the last line of the odbc.ini is something I am playing around with, I think the answer is related to that, > something needs to be defined that isn't, but that's just based on what I've found on this forum and the > net searches.

> DMEnvAttr = SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0}

Below is from the trace log, I notice the ret = -1, which makes me think I have a bad syntax in the odbc.ini?  Well at least it makes me think it's not working but I don't know exactly where in the code that's getting written to the log.  I'll keep tracing code for now.

[SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0] ret = -1


[ODBC][19126][SQLConnect.c][3586]
                Entry:
                        Connection = 27978
                        Server Name = [IEQQ2][length = 5 (SQL_NTS)]
                        User Name = [tca_read_user][length = 13 (SQL_NTS)]
                        Authentication = [*************][length = 13 (SQL_NTS)]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2BE'

                ENV ATTR [SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0] ret = -1

[ODBC][19126][SQLConnect.c][1315]Error: IM004

[HAS]

> I just checked, thats a typo in the driver manager code, ignore the -1.
> Its not the problem here.

> The error you are getting either means the driver lib is failing when
> the driver manager calls SQLAllocEnv or SQLAllocHandle for a environmant
> handle.

Thanks for that info (as well as all the help you are providing), I would have wasted my day trying to figure out what I was doing wrong with loading the env var :)

Not being a unix person, I have a hunch that because none of the env vars I'm setting are in a "global" file like .cshrc or .login, etc. that kicks in for each shell, that my problem requires more than just ORACLE_HOME.  That's what I'm going to try next, since I know the envirnoment setting via the odbc.ini is ok.

[Stefan Radman]

> Basic vs Basic lite.  
In my case installing basic instead of basiclite solved the problem but
first of all I would install the latest instantclient version 10.2.0.3

> Anyone know if there is a way to determine which was installed
The basic package contains
  client/lib/libociei.so
and the basiclite package contains
  client/lib/libociicus.so
instead.

> I found online, IM messages are from the driver manager, so
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on
SQL_HANDLE_HENV failed

The driver manager just reports that a function implemented by the
driver (SQLAllocHandle) that the driver manager was instucted to execute
failed. The problem is in the function implemented by the driver even if
it did not report why it failed to execute it.

There is one more thing I observed:
  DMEnvAttr =
SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/ieqqammk1/oracle/product/10.2.0}
triggered the same error message even with the basic instantclient.
Only after commenting the line or using TNS_ADMIN instead would the
error go away.
For instantclient you don't need to set ORACLE_HOME anyway.

Cheers
Stefan

> -----Original Message-----
> From: unixodbc-support-bounces@...
> [mailto:unixodbc-support-bounces@...] On Behalf Of HAS
> Sent: Wednesday, 13 June, 2007 15:38
> To: unixodbc-support@...
> Subject: [unixODBC-support] RE: Repost - Install questions
>
>
> > It's most likely not a uniXODBC but an Oracle driver issue.
> >
> > If you are using instantclient-basiclite have a look at this thread
> > http://forums.oracle.com/forums/thread.jspa?messageID=1433370
>
> Thanks for the info.  I looked at the thread and unless I'm missing
> something I see two things, copying from windows (which I
> didn't) and Basic
> vs Basic lite.  Anyone know if there is a way to determine which was
> installed?  I didn't do the install, it's unlikely it was the lite but
> always good to rule things out.
>
> I don't doubt the problem is some missing env variable or
> file and that it's
> more than likely related to the driver itself, but according
> to one document
> I found online, IM messages are from the driver manager, so
> maybe there is a
> way to get more detail on what it's really complaining about.
>  I'm going to
> try and see if I can match the trace log to the program code,
> but if anyone
> has thoughts or answer don't let that stop you from sharing!  Thanks.
>
> --
> View this message in context:
> http://www.nabble.com/Repost---Install-questions-tf3908337.htm
> l#a11099329
> Sent from the unixODBC - Support mailing list archive at Nabble.com.
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support@...
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[Stefan Radman]

>                        Server Name = [IEQQ2][length = 5 (SQL_NTS)]
>                        User Name = [tca_read_user][length = 13
(SQL_NTS)]
>                        Authentication = [*************][length =
13(SQL_NTS)]
>                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
'UCS-2BE'

That might be somhow consistent with the explanation provided (use basic
instead of basiclite).
The basiclite package includes only English error messages and support
for
Unicode, ASCII, and Western European character sets.
Maybe this does not include the above encodings.

Stefan

> -----Original Message-----
> From: unixodbc-support-bounces@...
> [mailto:unixodbc-support-bounces@...] On Behalf Of
> Nick Gorham
> Sent: Wednesday, 13 June, 2007 16:19
> To: Support for the unixODBC project
> Subject: Re: [unixODBC-support] Repost - Install questions
>
> HAS wrote:
>
> >>the last line of the odbc.ini is something I am playing
> around with, I
> >>    
> >>
> >think the answer is related to that, > something needs to be
> defined that
> >isn't, but that's just based on what I've found on this
> forum and the > net
> >searches.
> >
> >  
> >
> >>DMEnvAttr =
> >>SQL_ATTR_UNIXODBC_ENVATTR={ORACLE_HOME=/ieqqammk1/oracle/pro
> duct/10.2.0}
> >>    
> >>
> >
> >Below is from the trace log, I notice the ret = -1, which
> makes me think I
> >have a bad syntax in the odbc.ini?  Well at least it makes
> me think it's not
> >working but I don't know exactly where in the code that's
> getting written to
> >the log.  I'll keep tracing code for now.
> >
> >[SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/ieqqammk1/oracle/prod
> uct/10.2.0] ret
> >= -1
> >
> >
> >[ODBC][19126][SQLConnect.c][3586]
> >                Entry:
> >                        Connection = 27978
> >                        Server Name = [IEQQ2][length = 5 (SQL_NTS)]
> >                        User Name = [tca_read_user][length =
> 13 (SQL_NTS)]
> >                        Authentication = [*************][length = 13
> >(SQL_NTS)]
> >                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
> >'UCS-2BE'
> >
> >                ENV ATTR
> >[SQL_ATTR_UNIXODBC_ENVATTR=ORACLE_HOME=/ieqqammk1/oracle/prod
> uct/10.2.0] ret
> >= -1
> >
> >[ODBC][19126][SQLConnect.c][1315]Error: IM004
> >
> >  
> >
> I just checked, thats a typo in the driver manager code,
> ignore the -1.
> Its not the problem here.
>
> The error you are getting either means the driver lib is failing when
> the driver manager calls SQLAllocEnv or SQLAllocHandle for a
> environmant
> handle.
>
> --
> Nick Gorham
> Easysoft Limited
> http://www.easysoft.com, http://www.unixODBC.org
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support@...
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>

_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support

[HAS]

> > Basic vs Basic lite.  
> In my case installing basic instead of basiclite solved the problem but
> first of all I would install the latest instantclient version 10.2.0.3

> > Anyone know if there is a way to determine which was installed
> The basic package contains
>   client/lib/libociei.so
> and the basiclite package contains
>   client/lib/libociicus.so
> instead.

Going by this, it's the basic package installed.  My attempt at adding all env vars in the odbc.ini didn't work either.  Still have some ideas, open to hear any others.

[HAS]

> The error you are getting either means the driver lib is failing when
> the driver manager calls SQLAllocEnv or SQLAllocHandle for a environmant
> handle.

I added some additional code to the SQLConnect.c and determined the offending call is this one, it returns -1 and cause the IM004 to be thrown.  Please forgive me in advance for my cluelessness, and now my questions.

is the SQLALLOCHANDLE referenced below expected to be in the odbc driver for the client I'm trying to connect to?

if it is, I ran dltest as follows:

bash-3.00$ dltest /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1 SQLALLOCHANDLE
SUCCESS: Loaded /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
ERROR: ld.so.1: dltest: fatal: SQLALLOCHANDLE: can't find symbol
 Could not find SQLALLOCHANDLE

and

bash-3.00$ dltest /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1 SQLAllocHandle
SUCCESS: Loaded /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
SUCCESS: Found SQLAllocHandle

Is there an issue relating to the case of SQLAllocHandle vs SQLALLOCHANDLE?

If this is a dll issue, what would be the path to trying to resolve it?  Oracle client forum?

Open to ideas...  Thanks in advance.

ret = SQLALLOCHANDLE( connection,
                    SQL_HANDLE_ENV,
                    SQL_NULL_HENV,
                    &connection -> driver_env,
                    connection );

[Nick Gorham]

HAS wrote:

>>The error you are getting either means the driver lib is failing when
>>the driver manager calls SQLAllocEnv or SQLAllocHandle for a environmant
>>handle.
>>    
>>
>
>I added some additional code to the SQLConnect.c and determined the
>offending call is this one, it returns -1 and cause the IM004 to be thrown.
>Please forgive me in advance for my cluelessness, and now my questions.
>
>is the SQLALLOCHANDLE referenced below expected to be in the odbc driver for
>the client I'm trying to connect to?
>
>if it is, I ran dltest as follows:
>
>bash-3.00$ dltest /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
>SQLALLOCHANDLE
>SUCCESS: Loaded /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
>ERROR: ld.so.1: dltest: fatal: SQLALLOCHANDLE: can't find symbol
> Could not find SQLALLOCHANDLE
>
>and
>
>bash-3.00$ dltest /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
>SQLAllocHandle
>SUCCESS: Loaded /ieqqammk1/oracle/product/10.2.0/lib32/libsqora.so.10.1
>SUCCESS: Found SQLAllocHandle
>
>Is there an issue relating to the case of SQLAllocHandle vs SQLALLOCHANDLE?
>
>If this is a dll issue, what would be the path to trying to resolve it?
>Oracle client forum?
>
>Open to ideas...  Thanks in advance.
>
>ret = SQLALLOCHANDLE( connection,
>                    SQL_HANDLE_ENV,
>                    SQL_NULL_HENV,
>                    &connection -> driver_env,
>                    connection );
>
>  
>

No, you have missed what the code is doing, SQLALLOCHANDLE is a macro
that calls the entry point in the driver that has been dynamically
loaded, it calls SQLAllocHandle.

If it didn't have the entry point, it woudln't have tried to call it. So
its callint the driver, and the driver is returning -1. Maybe it can't
load the oracle libs. Maybe try using strace and see if that gives any
clues.

Other than that, try the Oracle folk, or Easysoft do a nice driver :-).

--
Nick
_______________________________________________
unixODBC-support mailing list
unixODBC-support@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-support