Teradata Drivers

[robojam]

Hi

 

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

 

"Provider=Teradata;DBCName=xxxxxxxxxx;Uid=xxxxxxxx xx;Pwd=xxxxxxxxxx"

 

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... :(