We have an application which connects to Oracle before, now our database migrated to teradata, so need to connect.
Here is what we use for oracle,
Data Source=;User ID=;Password=;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;
But when we try to replace bold part with "Teradata.Client.Provider", it doesn't work, we are using Teradata .Net provider to connect.
Can anyone please let us know what is the name for teradata . Net provider?
Thanks in advance.
The connection string shown above is for the "Microsoft .NET Data Provider for OLE DB". In other words, this ADO.NET Data Provider is a Bridge; it utilizes a native OLE DB Provider under the covers.
The .NET Data Provider for Teradata is an ADO.NET Data Provider by itself. It does not use an OLE DB Provider under the covers.
The connection string for the .NET Data Provider for Teradata is something like:
Data Source=SystemName; User Id=Foo; Password= Bar;
I recommend that you use the TdConnectionStringBuilder class to build the connection string. See online documentation for addition information: