I've just started working the Teradata Parallel Transporter utility. I'm attempting to import data from an Oracle datable. However, when I attempt to establish the connection, I get an error message "There was a database access error – check privledges.” I can access the tables in question through SQL*Plus, MS Access and SQL Assistant; so there is not a privledges problem. Any ideas what you might need to tweak in TPT to get the ODBC connection to work?
I think somebody responded to my personal email (which I can't access at work) rather than here. If I remember the questions they were about the Oracle ODBC driver I've successfully used with SQL Assistant, SQL*Plus and MS Access. I don't know where we got it; it was on my machine when I came to work here. It is the Oracle ODBC driver provided by Oracle. Ours is version 9.02.00.03; SQORA32.DLL, dated 11/1/02.