All Forums Database
Prem 3 posts Joined 09/07
22 Feb 2008
Can't Login into server database after creating system DSN

Hi,Can't login into server database after creating system DSN through bteq. I am able to connect through sql assistant. Can anyone help me out on this issue.With RegardsKccrga

joedsilva 505 posts Joined 07/05
22 Feb 2008

Bteq and other CLI based applications like mload, fastload, fexp etc ... don't use DSN to connect to a teradata system... you need to use the tdpid of the system to login ...(optionally hostname/ipaddress also works)

nithyanandam 65 posts Joined 10/04
22 Feb 2008

CLI based programs would normally look at the tdpid in the hosts file. Add a tdpid entry in the hosts file under the below directory:C:\WINDOWS\SYSTEM32\DRIVERS\ETC127.0.0.1 cop1 tdpidA tdpid normally is your databasename.

nithyanandam 65 posts Joined 10/04
22 Feb 2008

Oops, I was trying to say:127.0.0.1 tdpidcop1 tdpid

You must sign in to leave a comment.