Delphi - connecting to Teradata database (in virtual machine) using FireDAC

Abort the chase:
Windows 10 x64 host machine runs VMWare Player 12, which runs the "Linux version of TDE 16.00.04 SLES 11" downloaded from the Teradata website. The VM is pre-installed with Teradata DB and it works fine, I can connect to it using Teradata Studio Express from the host machine.
(There is also an adhoc.c file that can help you test ODBC connectivity on a VM, and it works great too).
I downloaded and installed "Teradata ODBC Driver For Windows" from the Teradata site.

Using Delphi Berlin 10.1 . I created a new project, added TFDConnection component and TFDPhysTDataDriverLinkin the main form, added a button to set the connection string and connect to the database.
Set the TFDPhysTDataDriverLink ODBCDriver property to Teradata Database ODBC Driver 16.00. Install the connection string:

Connection.Params.Values['DriverID']  := 'TData';
Connection.Params.Values['Server']    := '192.168.56.128';
Connection.Params.Values['Database']  := 'dbc';
Connection.Params.Values['User_Name'] := 'dbc';
Connection.Params.Values['Password']  := 'dbc';

      

When I try to connect, the exception says nothing to me:

[FireDAC][Phys][ODBC]



(Yes, that's it, nothing else)
I also tried to add a User and System DSN entry (32 bit) and tried to set the Datasource parameter:

Connection.Params.Values['DriverID']  := 'TData';
Connection.Params.Values['Datasource']:= 'testdsn';
Connection.Params.Values['User_Name'] := 'dbc';
Connection.Params.Values['Password']  := 'dbc';

      

When I do this, the msg message says:

Data source name not found and no default driver specified

      

How to set up a delphi connection correctly? How can I get information about a problem?
Any ideas what the problem might be?
Any suggestions would be greatly appreciated.

+3


source to share





All Articles