Aster database and linked server in SQL Studio Manager 2016

Aster
Fan

Aster database and linked server in SQL Studio Manager 2016

Hi all,

I am the newbie in this filed, I mean Teradata, but have spent a few months with SQL Studio Manager.

I have followed instructions from this site and used Aster ODBC driver instaed Teradata ODBC.

 https://community.teradata.com/t5/Blog/Setup-SQL-Server-2008-R2-Linked-Server-To-the-Teradata-Databa...

Also I created linked server in SQL Studio 2016 but can't sript any table within SQL. Always get the error:

sql issue 2.PNG

 

Could someone assist me on this as I don't have any idea what is wrong?

Thank you in advance.

4 REPLIES
Fan

Re: Aster database and linked server in SQL Studio Manager 2016

I've re-created linked server, run this statement:

Select * from TD..cert.global_sr_details

and got this error:

An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "TD".
Fan

Re: Aster database and linked server in SQL Studio Manager 2016

Any news?

Teradata Employee

Re: Aster database and linked server in SQL Studio Manager 2016

Teradata Employee

Re: Aster database and linked server in SQL Studio Manager 2016

The Aster Client User Guide describes how to install and configure Aster ODBC. You need to review the manual for the specific Aster version you are connecting to since it can differ for each version. You will find exact steps for Windows, Linux or other OS. Further check the “Aster Client Platform and OS Support Matrix” and “Aster ODBC Driver Support Matrix” for requirements. You will find it in the Aster Client User Guide as well.