Access ODBC connection to Teradata

[DaveK]

I'm trying to connect to a Teradata data source through ODBC in Access using
VB code. Does anyone have sample code to build the connection string
necessary to make this work?

 

[RD]

I'm trying to connect to a Teradata data source through ODBC in Access using
VB code. Does anyone have sample code to build the connection string
necessary to make this work?

First, make sure your computer has the proper driver:
http://www.teradata.com/t/page/130536


I found some good stuff at:
http://www.able-consulting.com/tech.htm


For ADO:

oConn.Open "Provider=Teradata;" & _
"DBCName=MyDbcName;" & _
"Database=MyDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

You'll need an "account" on the teradata server. Back when I was
doing this, the DBA created a special account to be used in the
connection string used by all of the computers that needed access.

HTH,
RD