Menu

Using Teradata ODBC driver from SWIFT

strannik
2015-05-02
2015-05-04
  • strannik

    strannik - 2015-05-02

    Hello!

    Found your ODBCkit module and wanted to use it to talk to a Teradata database over ODBC (using http://druware.tumblr.com/tagged/odbckit as an example). But I cannot get it to connect, it says it cannot load the driver. I have tested the DSN through other odbc tools, and they are able to connect using the same DSN. Help would be much appreciated.

    http://pastebin.com/wD7SKa8N -- swift source
    http://pastebin.com/TfqFGSWV -- iodbc trace
    http://pastebin.com/YjEVQ5LC -- swift error

     
  • strannik

    strannik - 2015-05-04

    I recompiled ODBCKit to use unixODBC, and I am getting a different problem now. The error is:
    2015-05-04 14:47:54.024 dbq[50128:2973063] AllocHandle
    2015-05-04 14:47:54.025 dbq[50128:2973063] SQLSetConnectOption
    2015-05-04 14:47:54.025 dbq[50128:2973063] DriverConnect
    2015-05-04 14:47:54.029 dbq[50128:2973063] SQL Error State:01000, Native Error Code: 0, ODBC Error: [unixODBC][Driver Manager]Can't open lib '/Library/Application Support/teradata/client/ODBC/lib/tdata.dylib' : file not found
    Connection Failed
    SQL Error State:01000, Native Error Code: 0, ODBC Error: [unixODBC][Driver Manager]Can't open lib '/Library/Application Support/teradata/client/ODBC/lib/tdata.dylib' : file not found.

    I tested the same DSN with isql that comes with unixODBC and it works without issue.

     

Log in to post a comment.

MongoDB Logo MongoDB