Unanswered: Teradata Drivers
I am in the middle of a proof of concept at the moment to determine if we can connect to a Teradata database from our web servers.
I have the NCR Teradata ODBC drivers installed on a Windows 2003 server, and that server should by default have the MS Teradata drivers installed as MDAC 2.8 SP1 should be there.
The problem I have had is that the drivers aren't recognized if I try this with either ODBC or OLE DB connections. I have had one of the developers create an app for me so that I can update the connection string and try to connect, but have had no luck. I also installed the NCR drivers on my own Windows XP machine (SP2), which also should have the equivalent of MDAC 2.8 SP1, but writing VBA in Excel.
The error that I get is that the driver isn't recognized. I can connect using a DSN connection on my machine using Teradata SQL Assistant, but we cannot use DSN connections on the servers (DSN-less only).
The only online help I have found so far suggests reinstalling drivers, and I have lost count of how many times I have done that on both machines, so that doesn't work.
The connection strings that I have tried are:
"Provider=TDOLEDB;Data Source=xxxxxxxxxx;User Id=xxxxxxxxxx;Password=xxxxxxxxxx;Extended Properties=Session Mode=TERADATA;"
and multiple versions thereof.
Does anyone know why I am getting problems recognizing the driver? My assumption is that either of the Provider names that I am giving is not correct, but these are the ones that I find when I search the Internet.
I am really confused on this one, as I don't know what the issue is here.
Make something idiot proof and someone will make a better idiot...