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

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -