.Net driver


.Net driver

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

dbpfTeraData = DbProviderFactories.GetFactory("Teradata.Client.Provider")
dbConn = dbpfTeraData.CreateConnection()
dbConn.ConnectionString = sConnection
Catch ex As Exception

End Try
Teradata Employee

Re: .Net driver

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).

Re: .Net driver

I downloaded and installed all those..

Is there a way to confirm the proper DLL versions are actually found?

Re: .Net driver

You can download listdlls from sysinternals, under the process and threads utility section. Listdlls lists by either process name or process id.

Re: .Net driver

I wanted to know if you found a solution to this problem as I am having the same problem.

Not applicable

Re: .Net driver

Has anyone solved this issue? I am experiencing the problem now when trying to publish my ASP.net site to a server. I have already installed CLIv2, TeraGSS and the .net provider.
Teradata Employee

Re: .Net driver

This is a documented issue in release notes:

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)"