[unixODBC-support] Using unixODBC + TimesTen

csepulveda at atichile.com csepulveda at atichile.com
Tue Jan 29 18:28:25 GMT 2008

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
[01000][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:
> [dbtest1_malta]
> DRIVER=/opt/TimesTen/tt70/lib/libttclient.so
> TTC_SERVER_DSN=dbtest1
> UID=csepulve
> PWD=csepulve
> 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
> manager.
>>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:
>     $ODBCINI
>     $HOME/.odbc.ini
>     $ODBCSYSINI/odbc.ini
>     /usr/local/etc/odbc.ini
>     (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.
>     $ODBCINI
>     $HOME/.odbc.ini
>     /var/TimesTen/sys.odbc.ini
> 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
> Hello.
> I'm a new user in this forum and I need your help in a problem with
> odbc.
> 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
> ok.
> 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 
> source)
> 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
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support

More information about the unixODBC-support mailing list