<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
GianLuca Sarto wrote:
<blockquote cite="mid:4B40E222.7060907@tiscali.it" type="cite">
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
Ken Resander wrote:
<blockquote cite="mid:365217.84301.qm@web51006.mail.re2.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top">Hi GianLuca,<br>
<br>
I managed to get Oracle XE working with unixODBC about 8 months ago. It
was not easy. The Oracle driver documentation is very poor and
incomplete.<br>
<br>
A few days ago I posted on this mailing giving all information that
helped me get Oracle XE up and working. Before continuing your Google
search try the ini files below, if you have not already done so: <br>
<br>
/etc/odbcinst.ini<br>
[OracleExpressdrv]<br>
Driver =
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libsqora.so.10.1<br>
Description = Oracle 10g express driver<br>
<br>
/etc/odbc.ini<br>
[TestDBDSN]<br>
Application Attributes = T<br>
Attributes = W<br>
BatchAutocommitMode = IfAllSuccessful<br>
CloseCursor = F<br>
DisableDPM = F<br>
DisableMTS = T<br>
Driver = OracleExpressdrv<br>
DSN = TestDBDSN<br>
EXECSchemaOpt =<br>
EXECSyntax = T<br>
Failover = T<br>
FailoverDelay = 10<br>
FailoverRetryCount = 10<br>
FetchBufferSize = 64000<br>
ForceWCHAR = F<br>
Lobs = T<br>
Longs = T<br>
MetadataIdDefault = F<br>
QueryTimeout = T<br>
ResultSets = T<br>
# ServerName is TNS_alias_from_tnsnames.ora<br>
ServerName = XE<br>
SQLGetData extensions = F<br>
Translation DLL =<br>
Translation Option = 0<br>
UserID = hr<br>
<br>
<br>
You may also need to put this or parts of this in your startup file:<br>
<br>
ODBCINI=/etc/odbc.ini;export ODBCINI<br>
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0;export
ORACLE_HOME<br>
TNS_ADMIN=$ORACLE_HOME/server/network/admin;export TNS_ADMIN<br>
LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib;export
LD_LIBRARY_PATH<br>
<br>
<br>
The main problem that stopped me connecting was that Oracle had changed
the install directory structure (undocumented?). I discovered by trial
and error that ORACLE_HOME has to be:<br>
<br>
ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server<br>
<br>
not<br>
<br>
ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0<br>
<br>
which is shown in dozens of pages on the Internet going back many years.<br>
<br>
Hope this works for you.<br>
<br>
Ken<br>
<br>
P.S. I stopped using the GUI tools a long time ago. It is a lot easier
just to type in the ini sections as text files. Don't remember which
one(s), but some GUI tool(s) are buggy and cannot generate complete and
correct text files.<br>
<br>
<br>
<br>
--- On <b>Sat, 2/1/10, GianLuca Sarto <i><a moz-do-not-send="true"
class="moz-txt-link-rfc2396E" href="mailto:glsarto@tiscali.it"><glsarto@tiscali.it></a></i></b>
wrote:<br>
<blockquote
style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>
From: GianLuca Sarto <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E" href="mailto:glsarto@tiscali.it"><glsarto@tiscali.it></a><br>
Subject: Re: [unixODBC-support] how to connect to oracle xe?<br>
To: "Support for the unixODBC project"
<a moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="mailto:unixodbc-support@mailman.unixodbc.org"><unixodbc-support@mailman.unixodbc.org></a><br>
Date: Saturday, 2 January, 2010, 6:35 PM<br>
<br>
<div id="yiv1596807578">
<title></title>
Nick Gorham wrote:
<blockquote type="cite">GianLuca
Sarto wrote: <br>
<blockquote type="cite">Nick Gorham wrote: <br>
<blockquote type="cite">GianLuca Sarto wrote: <br>
<blockquote type="cite">Nick Gorham wrote: <br>
<blockquote type="cite">GianLuca Sarto wrote: <br>
<blockquote type="cite">Nick, <br>
<br>
thanks for your kind reply. <br>
<br>
I am not sure I fully understood the Oracle ReadME, but I managed to
install the driver. <br>
<br>
Well, almost... <br>
<br>
ODBCConfig crashes when I try to configure the driver: <br>
gian@hp-gls:/usr/lib/oracle/instantclient_10_2$ sudo ODBCConfig <br>
ODBCConfig: libltdl/ltdl.c:1178: try_dlopen: Assertion `filename
&& *filename' failed. <br>
Aborted <br>
<br>
</blockquote>
I would avoid ODBCConfig and just edit the ini files. You haven't got a
setup lib <br>
<br>
</blockquote>
How should I edit my ini files? are there any required entries I should
add? <br>
</blockquote>
Should be documented with the driver. <br>
<br>
</blockquote>
it should, but it is not. <br>
<br>
I'm asking what are the UnixOdbc requirements in the ini files. <br>
<br>
If I'm OT or on the wrong list please forgive me. <br>
</blockquote>
It fine asking, I just don't know the full answer :-) <br>
<br>
All unixODBC needs is a [DSN] section in the odbc.ini file that
contains a <br>
<br>
Driver = NameofDriver <br>
<br>
That refers to a [NameofDriver] section on odbcinst.ini that contains a
<br>
<br>
Driver = /path/to/the/driver/libdriver.so <br>
<br>
All the other entries are up to the driver. Thats why it needs info
from the driver. I would expect there wil be a sample ini setup
somewhere in the docs, it would be a mistake assuming that everyone can
use (or wants to use) the GUI tools. <br>
<br>
</blockquote>
it's fine for me to use the command line, but reading unixODBC docs I
found:<br>
<b><font face="Arial,Helvetica">NOTE: odbc.ini and
odbcinst.ini are
considered to be ODBC System Information. All access (read or write) to
this System Information should occur via the Driver Manager or the <a
moz-do-not-send="true" rel="nofollow" target="_blank"
href="http://www.unixodbc.org/utilities.html">ODBCINST</a>
share library. Do not access these INI files directly!<br>
<br>
</font></b>That's why I tried ODBCConfig.<br>
<br>
I 'll go on googling...<br>
<br>
thanks for your help,<br>
-Gian<br>
<br>
<font face="Arial,Helvetica"><br>
</font> </div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="plainMail">_______________________________________________<br>
unixODBC-support mailing list<br>
<a moz-do-not-send="true"
ymailto="mailto:unixODBC-support@mailman.unixodbc.org"
href="/mc/compose?to=unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a><br>
<a moz-do-not-send="true"
href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support"
target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
</div>
</blockquote>
</td>
</tr>
</tbody>
</table>
<br>
<hr size="1"> <a moz-do-not-send="true"
href="http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/aa/">New
Email addresses available on Yahoo! </a> <br>
Get the Email name you've always wanted on the new @ymail and
@rocketmail.<br>
Hurry before someone else does!
<pre wrap=""><hr size="4" width="90%">
_______________________________________________
unixODBC-support mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a>
</pre>
</blockquote>
Ken,<br>
<br>
thanks for your message.<br>
<br>
I do not have the /server subfolder, did you install the XE client, or
the instant one?<br>
<br>
I'm totally confused!<br>
<br>
-Gian<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
unixODBC-support mailing list
<a class="moz-txt-link-abbreviated" href="mailto:unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a>
<a class="moz-txt-link-freetext" href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a>
</pre>
</blockquote>
Let's get back to square one.<br>
<br>
Because this works:<br>
<br>
gian@hp-gls:~$ ./sqlplus <a class="moz-txt-link-abbreviated" href="mailto:user/pwd@//192.168.1.126:1521/XE">user/pwd@//192.168.1.126:1521/XE</a><br>
<br>
So, where do I put the server address, 192.168.1.126:1521/XE into the
odbc.ini or odbcinst.ini?<br>
<br>
I guess that missing this info , I never be able to connect...<br>
<br>
-G<br>
</body>
</html>