I am helping migrate a datawarehouse from SQLServer to Teradata. As part of this one .net application has to be rewritten to connect to the new teradata datawarehouse. However, I am not able to add the Teradata .net driver as a reference in the .net Project.
I am using the Microsoft .Net framework version 2.0 and have installed the .Net driver for Teradata provided on this website.
What do i need to do to reference the TDOLEDB on the local machine? Any help truly appreciated.
Is you question in reference to the "OLE DB Provider for Teradata" (a.k.a. TDOLEDB)?
The .NET Data Provider for Teradata (not TDOLEDB) installation adds a registry entry to \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders. Visual Studio 2005 reads the registry key and displays the Assemblies in "Add Reference" dialog box.
I had no joy with this and so decided to change to use the Microsoft.Data.ODBC Classes. These have worked. I am wondering about the connection strings of these classes an whether they can take parameters? For example, the 1st statement below works but the 2nd falls over (even though the parameters been passed in the 2nd Stmt are identical to the hardcoded values.) with an exception as follows:
Microsoft.Data.Odbc.OdbcException' occurred in microsoft.data.odbc.dll. Additional information: System error.
I installed .NET Framework 2.0 because the .NET Data Provider for Teradata had it as pre-requisite. My applications still work so I can only assume that I am still pointing at 1.1 because I use 2003 V7.0. How can I know/find out this?
Also, I have extensive use of DataSets, dataAdaptors etc in my Apps. Will Microsft.Data.Odbc utilise these under 2003 V7.0?
C>corflags C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\system.data.dll Microsoft (R) .NET Framework CorFlags Conversion Tool. Version 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved.
Version : v2.0.50727 CLR Header: 2.5 PE : PE32 CorFlags : 24 ILONLY : 0 32BIT : 0 Signed : 1
C>corflags C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\System.data.dll Microsoft (R) .NET Framework CorFlags Conversion Tool. Version 2.0.50727.42 Copyright (c) Microsoft Corporation. All rights reserved.
Version : v1.1.4322 CLR Header: 2.0 PE : PE32 CorFlags : 9 ILONLY : 1 32BIT : 0 Signed : 1
I cannot answer you question about the .NET Data Provider for ODBC.