Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Charlotte, NC

    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;"


    "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...

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts