Connecting Tech Pros Worldwide Forums | Help | Site Map

ODBC works in Excel not Access

Nolan
Guest
 
Posts: n/a
#1: Nov 13 '05
I have created an ODBC connection to our Teradata database. Whenever I
attempt to link to a table on Teradata the process seems to be working.
But then I get the error message, "Reserved error (-7778); there is no
message for this error." The diaglog box of tables to select appears,
but there are no tables present.

The usual answer to these ODBC types of questions seem to be that there
is something wrong with your ODBC connection string. However this same
ODBC definition works just fine from MS Excel.

What is there about MS Access that won't recognize the ODBC connection?

Nolan


Ruben Baumann
Guest
 
Posts: n/a
#2: Nov 13 '05

re: ODBC works in Excel not Access


Publish both connection strings here, and we'll see if we can help you out.

RB

"Nolan" <NMadsonGoogle@yahoo.com> wrote in message
news:1120149231.885558.254320@f14g2000cwb.googlegr oups.com...[color=blue]
>I have created an ODBC connection to our Teradata database. Whenever I
> attempt to link to a table on Teradata the process seems to be working.
> But then I get the error message, "Reserved error (-7778); there is no
> message for this error." The diaglog box of tables to select appears,
> but there are no tables present.
>
> The usual answer to these ODBC types of questions seem to be that there
> is something wrong with your ODBC connection string. However this same
> ODBC definition works just fine from MS Excel.
>
> What is there about MS Access that won't recognize the ODBC connection?
>
> Nolan
>[/color]


Closed Thread