I am getting below error while trying to connect to Oracle DB using DataDirect 7.1 ODBC drivers from TPT script. I am able to test the connection using the example executable program in DataDirect and it works fine.
TeraData Version: 13.10
DataDirect Driver: 7.1 (64 bit trial for testing purpose)
Below is the Log.
Are you using the 32-bit or 64-bit versions of the driver?
TPT is a 32-bit application and you must use the 32-bit versions of the drivers.
Are there any plans for TPT to move to 64-bit ? I have 64bit servers available with 64bit ODBC drivers already installed - it would be ideal to use what's there with the TPT ODBC Operator without having to purchase additional 32 bit drivers.
We already delivered 64-bit on Windows in 14.10.
In our next release (sometime next year) we will deliver a native 64-bit TPT on the rest of the platforms.
I need load date from oracle database to teradata in linux machine. Do you know, how i can do this with mload script??
Someboy can tell me a example od how i can to connect to oracle database directly from the mload script??
This particular thread is discussing TPT, not MultiLoad.
Please open a new thread to discuss MultiLoad.
Hi, I am trying to move data from Oracle to Teradata using the TPT Script below but unable to connect to Oracle database as it throws an CLI 224 error like "name not in HOSTS file or names database"
Please start a new topic for new questions.
The EXPORT operator only reads from Teradata, so uses a Tdpid not a DSN. If you want to read from Oracle via a DSN, you need to use the ODBC operator.