[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                                  |
|                                       |
+---------------------------------------+
SQL>

Thank you very much for your help!!!

:D









csepulveda at atichile.com wrote:
> Thank you for your help.
> 
> I add line "DRIVER=..." and the definition look:
> 
> [dbtest1_malta]
> DRIVER=/opt/TimesTen/tt70/lib/libttclient.so
> TTC_SERVER=192.168.10.61
> TTC_SERVER_DSN=dbtest1
> TTC_TIMEOUT=300
> UID=csepulve
> PWD=csepulve
> 
> 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?
> 
> Thanks!
> 
> 
> 
> 
> 
> 
> 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=192.168.10.61
>> TTC_SERVER_DSN=dbtest1
>> TTC_TIMEOUT=300
>> 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
>>     $SYSODBCINI
>>     /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
>>
> 
> 
> _______________________________________________
> 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