Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 08 May 2003 @ 15:36:37 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Correct method of using Linked Tables in MS-Access
From:   Anomy Anom

<-- Anonymously Posted: Thursday, May 08, 2003 11:31 -->

Possible avenues to examine:

Check the following places which should control the Teradata logon settings.

1) Bring up the ODBC Administrator via Start->Settings->Control Panel->Administrative Tools->Data Sources (ODBC). Find the data source for Teradata (either on the User DSN or System DSN tabs) and click on the Configure button. The Teradata ODBC data driver documentation explains each of the settings as well as advanced options but I would look to see if the driver is configured to either always supply userid/password or to use Windows Integrated Security (that is, Single SignOn). I have not personally used the new Single SignOn (SSO) feature but that might explain the grayed out dialog box.

2) A second possible issue might be related to the table link defined in the MS Access database itself. If you bring up one of the table links involved in the Design view and then look at View->Properties you will be able to see the ODBC connection string associated with the link. This always starts with the keyword, "ODBC;" and has a semi-colon separated list of parameter assignments to use during the Teradata logon. Depending upon the parameter settings there might be something there.

In general, a good security practice with any ODBC application (not just Teradata) is to only store a default userid but not the password in the DSN or in the application (in this case, in the table link). That gives you the specific behavior you mention below where the user will provide/override the settings when they logon.

Hope this helps.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016