Connect Teradata to MS Access

Connectivity

Connect Teradata to MS Access

Hi -

I am trying to Connect Teradata to MS Access in VBA. I am using ADODB connection string but I haven't been able to establish the connection.

oConn.Open "Provider= Teradata;" & _
"DBCName= P5450;" & _
"Database= MWAD_USERDB;" & _
"Uid= Username;" & _
"Pwd= password"

Which drivers should I install to connect MS Access to Teradata server?

Thanks!
Bryce
2 REPLIES
Teradata Employee

Re: Connect Teradata to MS Access

OLE DB Provider ... Provider=TDOLEDB
or
ODBC Driver ... Provider={Teradata}
Teradata Employee

Re: Connect Teradata to MS Access

try this:

Provider=MSDASQL;Driver={Teradata};DBCName=TDPID;UID=x;PWD=y;

Also you can create an ODBC Data Source; the Data Source will hold configuration information and therefore simplifies the connection string; for example:

Provider=MSDASQL;DSN=myDataSource;UID=x;PWD=y;