dsn with dbProvider as odbc

[tkent]

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.

[Frank]

We do have users working with Teradata and they were sucessful. Too bad I cannot provide any reference. Seems like you have problem with the ODBC conenction. Use the TED and [F10] will bring up live code examples. Use "Pure MySQL", "ODBC Csv" which use ODBC to connect. Get asp to connect before you use Tornado. Check the TeraData example (got to be some) and extra their connect string. Finally, goto www.deja.com computer forum and search for "Teradata ODBC" and you'll see a ton of reference there.


Frank

[tkent]

.dbDSN = "Driver=Teradata; DBCName=demoTDAT; uid=mmxyz;pwd=mmxyz;"
is what I finally got to work. uid and pwd are required even though they are stored in this dsn.

[Frank]

glad you resolved that. looks simple enough.

FK