Linked tables to Teradata

[Terry]

All

I am trying to use access to modify data within a Teradata DB. I have the
following code that access Teradata thru the ODBC drivers.

Dim sql As String
Const stCon As String = "DSN=Teradata32_EDW Local"
Set cnt = New ADODB.Connection
Set rst = New ADODB.Recordset
Dim I As Long
cnt.ConnectionString = stCon

I = 1
sql = "select * from MIS.MV1513_JR74838_CURR_DSL"
cnt.Open
rst.Open sql, cnt, adOpenDynamic, adLockReadOnly
Do While rst.EOF = False
Debug.Print I
I = I + 1
rst.MoveNext
Loop


My problem is that I am trying to link the table in and right after I select
the Driver to use I get an error of "Reserved error (-7722); there is no
message for this error"

Anyone have suggestions on what is causing this. I would like to link the
tables in that I use the most often.

thanks

Terry

 

[Guest]

You appear to be using an ODBC connection string, for an
OLEDB connection.

Get an OLEDB connection string, or replace the ADODB
code with DAO code.

(david)