G
Guest
Hi,
I have built a working application in vb.net and have installed it on the
network.
2(including my own development pc) of 5 pcs will open the application. The
other 3 give the above message. The status bar finds the exception and
displays the information specified in the code below. I have tried everything
and cannot work out the issue.
I was getting the error on one pc and I did the following to fix it but did
the same on 2 other pcs but it did not work. I did all of this in the exact
same order to secure dependancies.
Uninstalled all Teradata Utilities and applications.
Uninstalled the .Net framework 2.0.
Unistalled the .Net Data Provider for Teradata.
Reinstalled Teradata Tools & Utilities Rel 8.0 Edition 2.
Uninstalled CLIv2, Shared ICU & GSS.
Reinstalled Shared ICU Libraries For Teradata 1.1.1.2, Teradata GSS Client
nt-i386 6.1.0.14 and Teradata CLIv2 4.8.1.4.
Installed .NET Provider Framework 2.0.
Installed .NET Data Provider for Teradata 01.01.00.00.
I have run out of ideas and have checked the versions of wincli32.dll,
tdusr32.dll etc and they all match. Any input/advice much appreciated.
-- code snippet of connection that is causing error.
Dim pf As DbProviderFactory =
DbProviderFactories.GetFactory("Teradata.Client.Provider")
cnString = "Data Source=" & ServerLogXML & ";User ID=" & UNameLogXML &
";Password=" + PasswordLogXML
strSQL = "SELECT uname FROM CQA_DATA_V.mis_MISRE_employees WHERE uname = '"
+ txtUName.Text + "';"
Try
cn = pf.CreateConnection
cn.ConnectionString = cnString
cn.Open()
Catch ex As Exception
sbLogin.Text = ("Error: Could not establish database connection")
End Try
I have built a working application in vb.net and have installed it on the
network.
2(including my own development pc) of 5 pcs will open the application. The
other 3 give the above message. The status bar finds the exception and
displays the information specified in the code below. I have tried everything
and cannot work out the issue.
I was getting the error on one pc and I did the following to fix it but did
the same on 2 other pcs but it did not work. I did all of this in the exact
same order to secure dependancies.
Uninstalled all Teradata Utilities and applications.
Uninstalled the .Net framework 2.0.
Unistalled the .Net Data Provider for Teradata.
Reinstalled Teradata Tools & Utilities Rel 8.0 Edition 2.
Uninstalled CLIv2, Shared ICU & GSS.
Reinstalled Shared ICU Libraries For Teradata 1.1.1.2, Teradata GSS Client
nt-i386 6.1.0.14 and Teradata CLIv2 4.8.1.4.
Installed .NET Provider Framework 2.0.
Installed .NET Data Provider for Teradata 01.01.00.00.
I have run out of ideas and have checked the versions of wincli32.dll,
tdusr32.dll etc and they all match. Any input/advice much appreciated.
-- code snippet of connection that is causing error.
Dim pf As DbProviderFactory =
DbProviderFactories.GetFactory("Teradata.Client.Provider")
cnString = "Data Source=" & ServerLogXML & ";User ID=" & UNameLogXML &
";Password=" + PasswordLogXML
strSQL = "SELECT uname FROM CQA_DATA_V.mis_MISRE_employees WHERE uname = '"
+ txtUName.Text + "';"
Try
cn = pf.CreateConnection
cn.ConnectionString = cnString
cn.Open()
Catch ex As Exception
sbLogin.Text = ("Error: Could not establish database connection")
End Try