0 - 3 of 3 tags for ado

I'm using VBA and the Microsoft ActiveX Data Objects 2.6 Library to access our Teradata 14.00.05.03 server using Teradata ODBC Driver 15.00.00.01

I have a linked table from a teradata server database in accees database.

i need to get from teradata table all records where in teradata filed table DATE1>01/01/2000

how to format the date 01/01/2000 in sql string?

note:
I use VB6 classic and ADO, and access 2100.

Tks.

I want to get a recordset in asp which is returned from teradata stored procedure.

Create PROCEDURE test() DYNAMIC RESULT SETS 1
BEGIN DECLARE cur1 CURSOR WITH RETURN only FOR
SELECT
col1,col2
from myTable;
OPEN cur1;
END;
-----------------it running well and get a result list correctly by execute "call test()" in SQL Assistant.----------------------------

Then I tried several different ways in ASP to get the result list:

***DB connection using ODBC as:

Set DBConn = Server.CreateObject("ADODB.Connection")