Just saw that there was a .Net driver, and tried it right away..
Maybe I installed something in the worng order? I get:
"Unable to load DLL 'wincli32.dll': The specified procedure could not be found. (Exception from HRESULT: 0x8007007F)"
Suggestions? Thanks, Dave
Here's the code snippet:
Dim dbpfTeraData As DbProviderFactory Dim dbConn As DbConnection Dim sUserID As String = "xxxx" Dim sPassword As String = "xxxx" Dim sDataSource As String = "xxxx" Dim sConnection As String = "Data Source=" + sDataSource + ";User ID=" + sUserID + ";Password=" + sPassword
Try dbpfTeraData = DbProviderFactories.GetFactory("Teradata.Client.Provider") dbConn = dbpfTeraData.CreateConnection() dbConn.ConnectionString = sConnection dbConn.Open() dbConn.Close() Catch ex As Exception
The .NET Data Provider requires CLIv2, which in turn will require tdicu and TeraGSS. The download from Teradata.com "Drivers and UDFs" area is a self-extracting ZIP that includes all necessary components - but each is a separate install (no "master install" packaging with dependency checking as on the distribution CDs).
Note: In a case where the system has an ODBC Driver for Teradata, the ODBC Driver for Teradata installs the TeraSSO.dll in the Windows\System32 directory. CLIv2 also installs the TeraSSO.dll, but in a user-specified directory. The possibility of having different TeraSSO.dll files installed could create an incompatibility between CLIv2 and older versions of the ODBC Driver for Teradata. This incompatibility will result in errors like:
"Unable to load DLL ‘wincli32.dll’: the specified procedure could not be found. (Exception from HRESULT: 0x8007007F)"