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. teradata gss installed (folder exist in teradata folder). , according this, shared icu libraries installed. suggestions?
the "unknown error occurred in terasso library" occurs when odbc drivers still need upgraded, after other teradata tools was.
see here see how upgrade odbc drivers.
Comments
Post a Comment