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.
source to share
No one has answered this question yet
Check out similar questions: