[unixODBC-support] Using unixODBC + TimesTen
csepulveda at atichile.com
csepulveda at atichile.com
Tue Jan 29 18:38:16 GMT 2008
I do this:
$ export LD_LIBRARY_PATH=/opt/TimesTen/tt70/lib
$ isql -v dbtest1_malta
| Connected! |
| sql-statement |
| help [tablename] |
| quit |
Thank you very much for your help!!!
csepulveda at atichile.com wrote:
> Thank you for your help.
> I add line "DRIVER=..." and the definition look:
> in the $HOME/.odbc.ini
> Then I test:
> $ isql -v dbtest1_malta
> [unixODBC][Driver Manager]Can't open lib
> '/opt/TimesTen/tt70/lib/libttclient.so' : libttco.so: cannot open shared
> object file: No such file or directory
> [ISQL]ERROR: Could not SQLConnect
> I check:
> $ ls -l /opt/TimesTen/tt70/lib/libttclient.so
> lrwxrwxrwx 1 btapia btapia 21 Jan 11 14:41
> /opt/TimesTen/tt70/lib/libttclient.so -> libttclient.so.gcc346
> May be I need to define some variable ... or not?
> Jeff Martin wrote:
>> We use TimesTen (TT).
>> As Nick already pointed out, your odbc.ini on B is missing the Driver=
>> line. What Nick doesn't know (since he's not a TT guy) is that from the
>> B side you need to specify the TT client-server driver, not the TT
>> in-memory driver. So your Driver= line on B needs to look something
>> like this:
>> I recommend going to TimesTen for support. They have many customers who
>> use unixODBC, and are familiar with some of the stumbling blocks.
>> Whereas most unixODBC users on this forum have barely heard of TimesTen.
>> One other thing to be aware of is that unlike most other databases, the
>> TimesTen drivers can be used by applications without a driver manager.
>> The TT drivers can directly read an odbc.ini file, but they don't need a
>> Driver= line when running without a driver manager. So when you read TT
>> documentation and examples, they usually leave out the Driver= line
>> because the TT docs usually assume you are not running with a driver
>>> I don't known if odbc.ini file can't be found (I tested with many
>>> different paths) or the format is wrong.
>> In this particular case, I think it will be the missing Driver= line.
>> But there is one other possibility. I strongly suspect that even when
>> the TT driver is running "under" a driver manager, the TT driver still
>> searches directly for the odbc.ini file, rather than letting the driver
>> manager find the setting for the TT driver.
>> Here is the search path order used by the unixODBC driver manager:
>> (Note: The location of the last entry can be changed when you
>> configure/build unixODBC, using the --sysconfdir option for
>> configure. The value shown above is the "default" value unless
>> you explicitly use --sysconfdir during configure.
>> Here is the search path order used by the TimesTen drivers when you are
>> not using a driver manager. This is also the only search path used by
>> the TT utilities (like ttAdmin, ttBackup, etc), because those utilities
>> never use a driver manager.
>> To help prevent conflicts & confusion, we have
>> /var/TimesTen/sys.odbc.ini as the "real" file, then we set up
>> /usr/local/etc/odbc.ini to be a symlink to that file (or you could do it
>> the other way). Also, we never set $ODBCSYSINI (used by unixODBC) nor
>> $SYSODBCINI (used by TT) because these can interfere with each other.
>> As I said earlier, if you are still having difficulties, try TimesTen
>> tech support.
>> -----Original Message-----
>> From: unixodbc-support-bounces at easysoft.com
>> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of
>> csepulveda at atichile.com
>> Sent: Tuesday, January 29, 2008 6:58 AM
>> To: unixodbc-support at easysoft.com
>> Subject: [unixODBC-support] Using unixODBC + TimesTen
>> I'm a new user in this forum and I need your help in a problem with
>> This is the situation:
>> 1. We have 2 linux machines with Red Hat Enterprise Linux ES release
>> 4 (Nahant Update 4) with timesten server version 7.0.3. Machine A and
>> Machine B.
>> 2. I tested local conection in Machine A and B with "isql" and it works
>> 3. I try to connect from B to A and it does not work:
>> $ isql -v dbtest1_malta
>> [IM002][unixODBC][Driver Manager]Data source name not found, and no
>> default driver specified
>> [ISQL]ERROR: Could not SQLConnect
>> I don't known if odbc.ini file can't be found (I tested with many
>> different paths) or the format is wrong.
>> Can you help me, please?
>> I attach:
>> odbc.ini.A -> file odbc.ini machine A
>> odbc.ini.B -> file odbc.ini machine B
>> ttconnect.ini.B -> file sys.ttconnect.ini in machine B (from timesten
>> Thank you so much.
>> CONFIDENTIALITY NOTICE: The information contained in this message may
>> be privileged and/or confidential. If you are not the intended
>> recipient, or responsible for delivering this message to the intended
>> recipient, any review, forwarding, dissemination, distribution or
>> copying of this communication or any attachment(s) is strictly
>> prohibited. If you have received this message in error, please notify
>> the sender immediately, and delete it and all attachments from your
>> computer and network.
>> unixODBC-support mailing list
>> unixODBC-support at easysoft.com
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
More information about the unixODBC-support