All Forums Connectivity
atiliomedina 5 posts Joined 04/16
09 Apr 2016
Connectivity issue

Hi All;
I have installed the drivers for php on a RHEL 7 system. I've configured the odbc.ini with the same settings I had on an older system but I am getting this error when trying to load a page that queries the database. Installed driver is 15.10

Warning: odbc_connect(): SQL error: [Teradata][ODBC Teradata Driver] Loading the Teradata ICU Library Failed. USelDir Library returned an error. Error is: The owner of the "/opt/teradata/client/15.10/.genuine_TTU" file is not as expected., SQL state S1000 in SQLConnect in /var/www/html/index.php on line 12

Using the tdxodbc64 utility I get

[umpcrcl@hllumpweb:/opt/teradata/client/etc] $tdxodbc64 

tdxodbc64: /lib64/libodbcinst.so: no version information available (required by tdxodbc64)

tdxodbc64: /lib64/libodbc.so: no version information available (required by tdxodbc64)

 

Enter Data Source Name: DSN-NAME

Enter UserID: <User-ID>

Enter Password: ***********

 

Connecting with SQLConnect(DSN=DSN-NAME,UID=<User-ID>,PWD=*)...

 

adhoc: SQLError() couldn't find text, RC=100

 

ODBC connection closed.

 
Any ideas what could be causing this issue?
Any help is appreciated.
Thanks,
Atilio

atiliomedina 5 posts Joined 04/16
22 Apr 2016

Has anybody run into this issue or similar?

l3ok 1 post Joined 07/16
26 Jul 2016

Hi
Have you managed to resolve your issue?

cheese03 1 post Joined 09/13
07 Sep 2016

Has you been able to resolve this issue? I am getting the exact same error? Even with the permissions on the file set to 0555,0777,4100 and 4100.

ODBCTeam 1 post Joined 02/16
08 Sep 2016

@atiliomedina
The .genuine_TTU file has to be owned by root and have permission of 4111

  • Could you kindly try changing the owner to root, if not already root.
  • Change the file permissions to 4111.
  • Try connecting again.

Hopefully, this should resolve your issue.

You must sign in to leave a comment.