Hi guys, I will be very greatful if anyone can help me,I have been trying to solve this error for weeks now. Iam using 64bit teradata .net provider on win2k 64 bit server and keep getting error: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B). The same thing works if i use 32 bit .net provider on 32 bit test machine. I will appreciate any ideas....
Is a service like IIS loading the .NET Data Provider? if it is a Service, did you restart the service after Installing CLI, ICU and GSS? Also did you install 32-bit and 64-bit versions of CLI, ICU and GSS on this machine?
I suggest to run a simple test with NQuery.exe first. It is in InstallationDirectory\Samples\Bin. NQuery architecture is MSIL; it will run as a 64-bit process.
Also note that .NET Data Provider for Teradata Version 12.0 no longer depends on CLI, ICU and GSS.
Hi, I have installed both the 32bit version and 64 bit version now. Iam testing using the NQuery. and still getting the same error. Do i have to make any registry changes or some thing like that. Our teradata database is 8.2, Can i use .NET Data Provider for Teradata Version 12.0 to connect to 8.2 database? ....
Does NQuery startup? If NQuery starts up, then the .NET Data Provider is fine. You can use ListDlls to see that it loaded correctly from the GAC.
I would write a simple console application that simply connects and disconnects. I would first build a 32-bit version and run it on the server. If this succeeds then there is something wrong with 64-bit versions of CLI, ICU or GSS. .NET Data Provider for Teradata is MSIL; it can load into a 32-bit or 64-bit process. If process is 32-bit, then it will require the 32-bit version of CLI, ICU and GSS. If process is 64-bit then it will require 64-bit versions.
You can use .NET Data Provider for Teradata version 12.0 to connect to Teradata Database 6.2.