|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/3/2006 1:08:00 PM
Posts: 5,
Visits: 1
|
|
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
Dave
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Yesterday @ 7:00:28 PM
Posts: 328,
Visits: 512
|
|
|
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).
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/3/2006 1:08:00 PM
Posts: 5,
Visits: 1
|
|
I downloaded and installed all those..
Is there a way to confirm the proper DLL versions are actually found?
Dave
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/19/2007 2:21:00 PM
Posts: 2,
Visits: 1
|
|
|
You can download listdlls from sysinternals, under the process and threads utility section. Listdlls lists by either process name or process id.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/24/2006 9:28:00 AM
Posts: 12,
Visits: 1
|
|
I wanted to know if you found a solution to this problem as I am having the same problem.
Thanks
Pr
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/9/2007 1:26:00 PM
Posts: 1,
Visits: 1
|
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/20/2008 6:06:39 PM
Posts: 125,
Visits: 271
|
|
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)"
Shaw
|
|
|
|