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
delphi teradata firedac


source to share


No one has answered this question yet

Check out similar questions:

five
How to setup ODBC connection to Oracle using FireDAC?
4
delphi mysql ado connectivity
2
Delphi 10.1 connection to Interbase XE7 Desktop in the Rad Studio development environment
1
Retrieving Data Types from Paradox Database over ODBC in SQLite [Delphi]
1
Configuring ODBC connection to MS Access database in Data Explorer in XE2 Enterprise that does not use DSN
1
Query from SQL Server 2008 R2 with FireDAC
0
PC, VS2017 installed, Attunity driver for Tdata, start package, exit, cancel
0
ODBCConfig.exe error during ConfigSysDSN using Teradata driver
0
(DRIVER_NOT_FOUND ', "No driver found for' Teradata '. Available drivers :) - using Anaconda-Jupyter notebooks with teradata module
0
How to override registry path for fireDAC or DBExpress vendorLib



All Articles
Loading...
X
Show
Funny
Dev
Pics