I must use .dbProvider="ODBC"
for a particular setup. OLEDB is not available on production system due to licensing.

To show connection works, first test with OLEDB.

global.asax has:
Application("TDlocalx") = "Provider=TDOLEDB; Data Source=tdlocal; User ID=mmxyz; Password=mmxyz; "

first test is ok with:
.dbDSN = "TDlocalx"
.dbDBType = "TERADATA"
.dbProvider = "OLEDB"
.dbSQL = "Select * from mmtable; "

next use is ok also:
.dbDSN = "Provider=TDOLEDB; Data Source=tdlocal; User ID=mmxyz; Password=mmxyz;"
.dbDBType = "TERADATA"
.dbProvider = "OLEDB"
.dbSQL = "Select * from mmtable; "

not working:
.dbDSN = "Driver=Teradata; Dsn=tdlocal; User ID=mmxyz; Password=mmxyz; "
.dbDBType = "TERADATA"
.dbProvider = "ODBC"
.dbSQL = "Select * from mmtable; "

error is:
ERROR [28000] [NCR][ODBC Teradata Driver] Not enough information to log on
Other applications use this DSN correctly.

also tried "User=mmxyz; Password=mmxyz;"
also tried "User=mmxyz; Pass=mmxyz;"
also tired "uid=mmxyz; pwd=mmxyz;"


also not working:
.dbDSN = "Driver=Teradata; DSN=demoTDAT; "
.dbDBType = "TERADATA"
.dbProvider = "ODBC"
.dbSQL = "Select * from mmtable; "

error is:
ERROR [28000] [NCR][ODBC Teradata Driver] Not enough information to log on
Above DSN has correct userid/password stored in it. Other applications use it without problem.

also not working:
.dbDSN = "Driver=Teradata; DSN=badname; "
.dbDBType = "TERADATA"
.dbProvider = "ODBC"
.dbSQL = "Select * from mmtable; "

error is:
ERROR [28000] [NCR][ODBC Teradata Driver] Not enough information to log on
DSN called badname does not exist in system.