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
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|