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.
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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.