Problem with unixODBC and teradata

Connectivity
Enthusiast

Problem with unixODBC and teradata

Ok the setup is RHEL 5 with unixODBC 2.2.11 python 2.4 using pyodbc 2.1.5

I have followed the instructions located here:

http://cjgoldsmith.blogspot.com/2011/03/teradata-odbc-python-pyodbc-on-fedora.html

To try and get this working but with no luck. I can get sql server and mysql working and everything like that but just can't get teradata to work. I've tried downloading and using the 13.0 bundle and the 13.10 bundle linking the files and everything like that. When i look at the trace it looks like this:

[code]
ENTER SQLSetEnvAttr
SQLHENV 0x13a13830
SQLINTEGER 200
SQLPOINTER 3
SQLINTEGER 4

EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x13a13830
SQLINTEGER 200
SQLPOINTER 3
SQLINTEGER 4

ENTER SQLAllocHandle
SQLSMALLINT 2
SQLHANDLE 0x13a13830
SQLHANDLE * 0x59baab40

EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 0x13a13830
SQLHANDLE * 0x59baab40 ( 0x13a147e0)

ENTER SQLConnect
HDBC 0x13a147e0
UCHAR * 0x59baa9b0 [ 7] "testdsn"
SWORD 7
UCHAR * 0x59baa7b0 [ 7] "user"
SWORD 7
UCHAR * 0x73046320 [4294967293] "******"
SWORD -3

EXIT SQLConnect with return code -1 (SQL_ERROR)
HDBC 0x13a147e0
UCHAR * 0x59baa9b0 [ 7] "testdsn"
SWORD 7
UCHAR * 0x59baa7b0 [ 7] "user"
SWORD 7
UCHAR * 0x73046320 [4294967293] "******"
SWORD -3

ENTER SQLError
HENV 0x13a13830
HDBC 0x13a147e0
HSTMT 0x00000000
UCHAR * 0x599b5ff0 (NYI)
SDWORD * 0x599b60f8
UCHAR * 0x599b5ef0
SWORD 256
SWORD * 0x599b60f6

EXIT SQLError with return code 0 (SQL_SUCCESS)
HENV 0x13a13830
HDBC 0x13a147e0
HSTMT 0x00000000
UCHAR * 0x599b5ff0 [ 5] "HY000"
SDWORD * 0x599b60f8 (0)
UCHAR * 0x599b5ef0 [ 112] "[Teradata][ODBC Teradata Driver] Major Status=0x04bd Minor Status=0xe0000007-[terasso]Cannot load TDGSS library."
SWORD 256
SWORD * 0x599b60f6 (112)

ENTER SQLSetEnvAttr
SQLHENV 0x1c63f830
SQLINTEGER 200
SQLPOINTER 3
SQLINTEGER 4

EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x1c63f830
SQLINTEGER 200
SQLPOINTER 3
SQLINTEGER 4

ENTER SQLAllocHandle
SQLSMALLINT 2
SQLHANDLE 0x1c63f830
SQLHANDLE * 0x001efa20

EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 0x1c63f830
SQLHANDLE * 0x001efa20 ( 0x1c6407e0)

ENTER SQLConnect
HDBC 0x1c6407e0
UCHAR * 0x001ef890 [ 7] "testdsn"
SWORD 7
UCHAR * 0x001ef690 [ 7] "user"
SWORD 7
UCHAR * 0x661ce320 [4294967293] "******"
SWORD -3

EXIT SQLConnect with return code -1 (SQL_ERROR)
HDBC 0x1c6407e0
UCHAR * 0x001ef890 [ 7] "testdsn"
SWORD 7
UCHAR * 0x001ef690 [ 7] "user"
SWORD 7
UCHAR * 0x661ce320 [4294967293] "******"
SWORD -3

ENTER SQLError
HENV 0x1c63f830
HDBC 0x1c6407e0
HSTMT 0x00000000
UCHAR * 0xffffaed0 (NYI)
SDWORD * 0xffffafd8
UCHAR * 0xffffadd0
SWORD 256
SWORD * 0xffffafd6

EXIT SQLError with return code 0 (SQL_SUCCESS)
HENV 0x1c63f830
HDBC 0x1c6407e0
HSTMT 0x00000000
UCHAR * 0xffffaed0 [ 5] "HY000"
SDWORD * 0xffffafd8 (0)
UCHAR * 0xffffadd0 [ 112] "[Teradata][ODBC Teradata Driver] Major Status=0x04bd Minor Status=0xe0000007-[terasso]Cannot load TDGSS library."
SWORD 256
SWORD * 0xffffafd6 (112)

ENTER SQLSetEnvAttr
SQLHENV 0x1c7da830
SQLINTEGER 200
SQLPOINTER 3
SQLINTEGER 4

EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x1c7da830
SQLINTEGER 200
SQLPOINTER 3
SQLINTEGER 4

ENTER SQLAllocHandle
SQLSMALLINT 2
SQLHANDLE 0x1c7da830
SQLHANDLE * 0x7e98cb00

EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2
SQLHANDLE 0x1c7da830
SQLHANDLE * 0x7e98cb00 ( 0x1c7db7e0)

ENTER SQLConnect
HDBC 0x1c7db7e0
UCHAR * 0x7e98c970 [ 7] "testdsn"
SWORD 7
UCHAR * 0x7e98c770 [ 7] "user"
SWORD 7
UCHAR * 0xc69d8320 [4294967293] "******"
SWORD -3

EXIT SQLConnect with return code -1 (SQL_ERROR)
HDBC 0x1c7db7e0
UCHAR * 0x7e98c970 [ 7] "testdsn"
SWORD 7
UCHAR * 0x7e98c770 [ 7] "user"
SWORD 7
UCHAR * 0xc69d8320 [4294967293] "******"
SWORD -3

ENTER SQLError
HENV 0x1c7da830
HDBC 0x1c7db7e0
HSTMT 0x00000000
UCHAR * 0x7e797fb0 (NYI)
SDWORD * 0x7e7980b8
UCHAR * 0x7e797eb0
SWORD 256
SWORD * 0x7e7980b6

EXIT SQLError with return code 0 (SQL_SUCCESS)
HENV 0x1c7da830
HDBC 0x1c7db7e0
HSTMT 0x00000000
UCHAR * 0x7e797fb0 [ 5] "HY000"
SDWORD * 0x7e7980b8 (0)
UCHAR * 0x7e797eb0 [ 112] "[Teradata][ODBC Teradata Driver] Major Status=0x04bd Minor Status=0xe0000007-[terasso]Cannot load TDGSS library."
SWORD 256
SWORD * 0x7e7980b6 (112)
[/code]

6 REPLIES

Re: Problem with unixODBC and teradata

I am getting the same error. Please help

Re: Problem with unixODBC and teradata

I am having the same problem too.

Using RHEL5, UnixODBC-2.3.0,

Teradata Drivers

tdodbc__linux_indep.14.00.00.04-1.tar.gz

tdicu__linux_indep.14.00.00.00-1.tar.gz

TeraGSS_linux_x64__linux_indep.14.00.00.00-1.tar.gz.

Just to check, ANYONE at all in this world that has made Teradata work with Unixodbc on Linux. I have not seen one positive respond....

Being a Teradata forum, please could someone from Teradata, say something here?

Fan

Re: Problem with unixODBC and teradata

I'm getting this error:

pyodbc.Error: ('HY000', '[HY000] [Teradata][ODBC Teradata Driver] Could not load security library (0) (SQLDriverConnect)')

What does it mean?

N/A

Re: Problem with unixODBC and teradata

Anyone know the answer to this one? or a post with a fix?

Teradata Employee

Re: Problem with unixODBC and teradata

Check out new, updated and clarified instructions Python access via RHEL....coming in a post shortly

Re: Problem with unixODBC and teradata

[Teradata][ODBC Teradata Driver] Major Status=0x04bd Minor Status=0xe0000007-[terasso]Cannot load TDGSS library.