All Forums Connectivity
DaveH 2 posts Joined 03/05
05 Jun 2006
.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, DaveHere'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

Fred 1096 posts Joined 08/04
06 Jun 2006

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

DaveH 2 posts Joined 03/05
06 Jun 2006

I downloaded and installed all those.. Is there a way to confirm the proper DLL versions are actually found?

cc151010 4 posts Joined 09/06
18 Sep 2006

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

premalm 12 posts Joined 09/06
29 Sep 2006

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

beth113 1 post Joined 10/07
09 Oct 2007

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.

NetFx 346 posts Joined 09/06
09 Oct 2007

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

You must sign in to leave a comment.