Linked tables to Teradata

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top