ODBC--call failed error

Connectivity
Min
N/A

ODBC--call failed error

Hi,

I have created views in a teradata database and i am trying to link these in access using the link function. However a pop-up box with the following error message appears when trying to link the tables:

"ODBC-call failed

[NCR][ODBC Teradata Driver][Teradata Database]The user does not have any access to database DB1. (#-3524)"

I can log-on to the database in teradata, but using the same log-on credentials to set up the ODBC connection in Access, it does not like it.

Does anyone have any idea's?

Many Thanks
3 REPLIES

Re: ODBC--call failed error

Enable the following in the ODBC settings to resolve your issues

* Use X views

* No HELP DATABSE

* Enable Custom Catalog mode for 2 x.Applications (This is the Advanced option)

Re: ODBC--call failed error

Thanks for the details.  I can see the list of database objects for import/linking.  But I am getting the following error message while linking/importing a table/view.   

ODBC --call failed.

[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Blank name in Quotation Marks. (#-3706).

I am using 13.10.00.04 ODBC driver.  Does anyone have any ideas?

Thanks in advance.

Re: ODBC--call failed error

 I can see the list of database objects for import/linking.  But I am getting the following error message while linking/importing a table/view.   

ODBC --call failed.

[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Blank name in Quotation Marks. (#-3706).

Does anyone have any ideas?

Thanks in advance.