<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.2900.5803" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=858042106-06072009><FONT face=Arial
color=#0000ff size=2>Baruch, </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=858042106-06072009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=858042106-06072009><FONT face=Arial
color=#0000ff size=2> I speculate, your driver and adhoc
application are built with some other driver manager other than unixODBC.
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=858042106-06072009><FONT face=Arial
color=#0000ff size=2>isql is built with unixODBC DM. Hence, you need to build
your Teradata driver with unixODBC DM to work with isql.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=858042106-06072009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=858042106-06072009><FONT face=Arial
color=#0000ff size=2>Hemanth.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
unixodbc-support-bounces@mailman.unixodbc.org
[mailto:unixodbc-support-bounces@mailman.unixodbc.org] <B>On Behalf Of
</B>Baruch Volkov<BR><B>Sent:</B> Saturday, July 04, 2009 6:18 PM<BR><B>To:</B>
unixodbc-support@mailman.unixodbc.org<BR><B>Subject:</B> [unixODBC-support]
unixODBC with Teradata on linux<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman,new york,times,serif">
<DIV>
<STYLE title=owaParaStyle>P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
BODY {
SCROLLBAR-HIGHLIGHT-COLOR: #cecfce; SCROLLBAR-ARROW-COLOR: #3f52b8; SCROLLBAR-TRACK-COLOR: #fffbff; SCROLLBAR-DARKSHADOW-COLOR: #fafafa; SCROLLBAR-BASE-COLOR: #f7f7f7
}
SPAN#misspelled {
BACKGROUND: url(8.1.375.2/themes/base/squiggly.gif) repeat-x 50% bottom; PADDING-BOTTOM: 1px
}
</STYLE>
<DIV dir=ltr><FONT face=Tahoma color=#000000 size=2>Hi,</FONT></DIV>
<DIV dir=ltr><FONT face=Tahoma color=#000000 size=2>I have problems accessing
Teradata using isql. Did search google, but could not find anything, maybe
somebody on this list did make it work.</FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=tahoma size=2>I'm running:</FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2>- 64 bit Redhat5 with </FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2><FONT face=tahoma>- </FONT>32 bit unixODBC
2.2.12</FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2>- 32 bit teradata client
tdodbc-12.00.00.01-1</FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=tahoma size=2>using adhoc works fine, mean can submit
any query</FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2>using isql, some queries failing on with
segmentation fault and I can't figure out the reason. </FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2>For example, "<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Verdana">SELECT * FROM DBC.
Table_LevelConstraints" works, but select * from dbc.tables
fails.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=tahoma size=2>In the library path i put Teradata first,
then unixODBC, but also tried unixODBC first and then Teradata.
<BR></FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=tahoma
size=2>LD_LYBRARY_PATH=/usr/odbc/lib:/usr/odbc/drivers:/home/support/unixODBC-2.2.12_32/install/lib:/home/support/instantclient_10_2_32</FONT></DIV>
<DIV dir=ltr><FONT face=tahoma size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=tahoma size=2>any suggestion would be
appreciated<BR><BR>Baruch<BR></FONT></DIV></DIV></DIV><BR></BODY></HTML>