.Net driver

Connectivity
Fan

.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

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

End Try
6 REPLIES
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).
Fan

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

Re: .Net driver

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

Thanks
Pr

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