All Forums Connectivity
BryceMT 1 post Joined 05/09
26 May 2009
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

Fred 1096 posts Joined 08/04
27 May 2009

OLE DB Provider ... Provider=TDOLEDBorODBC Driver ... Provider={Teradata}

NetFx 346 posts Joined 09/06
27 May 2009

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;

You must sign in to leave a comment.