I am 'making' unixODBC the same regardless of version. I am using the same DB2 driver (which I believe is 64bit) with both versions successfully.

I have both 32bit and 64bit drivers for Teradata, and where the 32bit driver works with isql, the 64bit complains about the 'magic' number in 2.2.11. In 2.3.0, both 32bit and 64bit cannot open tdata.so and neither refer to the magic number.

As a side note my Teradata client is 13.0 and it comes with it's own libodbc.a, libodbcinst.a, and more. So, the order of Teradata to unixODBC in my LIBPATH also becomes important.

The last 50 of unixODBC.log follows:

[ODBC][749914][SQLDriverConnect.c][678]
                Entry:
                        Connection = 20539e08
                        Window Hdl = 0
                        Str In = [nhitest][length = 7]
                        Str Out = 2ff21c14
                        Str Out Max = 512
                        Str Out Ptr = 2ff21a10
                        Completion = 0
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE '
+UCS-2'

[ODBC][749914][SQLDriverConnect.c][1258]
                Exit:[SQL_ERROR]
[ODBC][749914][SQLError.c][424]
                Entry:
                        Connection = 20539e08
                        SQLState = 2ff217a8
                        Native = 2ff217a4
                        Message Text = 2ff217b0
                        Buffer Length = 511
                        Text Len Ptr = 2ff217a0
[ODBC][749914][SQLError.c][461]
                Exit:[SQL_NO_DATA]
[ODBC][749914][SQLConnect.c][3549]
                Entry:
                        Connection = 20539e08
                        Server Name = [nhitest][length = 7]
                        User Name = [delli28][length = 7]
                        Authentication = [********][length = 8]
                UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE '
+UCS-2'

[ODBC][749914][SQLConnect.c][4123]
                Exit:[SQL_SUCCESS]
[ODBC][749914][SQLSetConnectAttr.c][318]
                Entry:
                        Connection = 20539e08
                        Attribute = SQL_ATTR_AUTOCOMMIT
                        Value = 1
                        StrLen = 0
[ODBC][749914][SQLSetConnectAttr.c][671]
                Exit:[SQL_SUCCESS]
[ODBC][749914][SQLGetInfo.c][214]
                Entry:
                        Connection = 20539e08
                        Info Type = SQL_DRIVER_ODBC_VER (77)
                        Info Value = 20537b84
                        Buffer Length = 20
                        StrLen = 2ff21980
[ODBC][749914][SQLGetInfo.c][501]Error: IM001

[download]

In reply to Re^4: DBD::ODBC to Teradata by DanEllison
in thread DBD::ODBC to Teradata by DanEllison

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.