All Forums Third Party Software
12 Aug 2008
ODBC connection problem - MS Query and Excel

Hello!Although this query has more to do with ODBC than Teradata, I am only posting it to see if any other users have worked around the error I have encountered.When connecting to Teradata via Excel | Data | New Database Query, when the dialogue comes up, I enter my password, and it comes up with Connecting... After about half a minute I get an Out of Memory error, and MS Query CPU usage goes to 50% and stays there, with memory allocated of 16000KB. I have to end the process to continue.I believe this issue has to do with my PC build and with the number of tables in our Teradata system. The problem is, a laptop with the same memory, but a laptop build, works fine and has no problems loading the tables in.My question is has anyone come up with a successful workaround? One workaround I have found was to open a small database and then in MS Query click on Options and tick only the Tables box, so that only Table names load. When I go back in and try Teradata I can get in. This is a workaround, but I would like to find an easier one, perhaps a setting that users can use instead. Not all users will have a small database they can connect to to set the options.I have proven that I am connecting to the database by inputting my password incorrectly. It wouldn't log me on, so I can tell it is not a Teradata issue.Thanks!

Andrew Livingston EMEA - Customer Education Consultant Teradata UK 206 Marylebone Road London NW1 6LY United Kingdom M: +44 7785 971 080 E-mail: Andrew.Livingston@Teradata.com
Fred 1096 posts Joined 08/04
12 Aug 2008

In the Teradata ODBC driver configuration, Advanced options, try selecting "Custom Catalog Mode".

15 Aug 2008

Thanks for that.I assume what this does is load only what is in the connection box database, and that is what I want it to do.Regards!Andrew

Andrew Livingston
EMEA - Customer Education Consultant
Teradata UK
206 Marylebone Road
London NW1 6LY
United Kingdom

M: +44 7785 971 080
E-mail: Andrew.Livingston@Teradata.com

hellind 6 posts Joined 09/08
01 Sep 2008

Thanks for the tips. I was also having similar problems using Excel to import data from a Teradata DB using Microsoft Query.The first link on Google search was the solution to my problems.

You must sign in to leave a comment.