Connecting Tech Pros Worldwide Help | Site Map

ODBC works in Excel not Access

  #1  
Old November 13th, 2005, 12:36 PM
Nolan
Guest
 
Posts: n/a
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

  #2  
Old November 13th, 2005, 12:36 PM
Ruben Baumann
Guest
 
Posts: n/a

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with large amount of characters in a VBA variant nartla answers 11 January 5th, 2008 04:45 AM
ODBC for Access back end in WAN environment Remco Groot Beumer answers 12 November 12th, 2005 10:48 PM
ODBC for Access back end in WAN environment Remco Groot Beumer answers 12 November 12th, 2005 10:20 PM
using Excel as a DB Mark answers 4 July 22nd, 2005 01:53 AM