Execute Teradata Stored Procedure From MS-Access

UDA

Execute Teradata Stored Procedure From MS-Access

How does one execute a Teradata Stored Procedure from MS-Access?., apart from OLEDB / ODBC type of issues are there any syntax notations etc?.

Regards
Krish
2 REPLIES
Enthusiast

Re: Execute Teradata Stored Procedure From MS-Access

Hi,

U can't excecute the teradata procs from MSAccess.

regds,
sac
Teradata Employee

Re: Execute Teradata Stored Procedure From MS-Access

Create a "SQL-Specific" passthru query containing the CALL statement. Remember to set the ReturnsRecords property to No (unless you are running TD12.0 or later).