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.

ref http://www.xtremevbtalk.com/showthre...90#post1183190