windows - Unknown error occurred in terasso library, unable to connect to teradata using vba -
i have simple code. last line return such error, use not english version, might bit different: " the data source not found , default driver not specified ". private objconn new adodb.connection 'connection... private objrs new adodb.recordset 'recordset... private objerr adodb.error 'errors... dim strsql string, intjobcoderequested integer 'prompt user job code... intjobcoderequested = inputbox("please enter job code desired: ", "teradata program", " ") 'connect database using dsl set in odbc setup... objconn.open "driver=teradatadsn; server=teradata server name; database=database name; uid=user id; pwd=password" so after that: i run 32 bit odbc data source administrator, pressed "add" selected "teradata" list pressed "finish" as result error message unknown error occurred in terasso library i`m using teradata v 14.1. oldp driver installed, according registry. ...