Can't Login into server database after creating system DSN

Database
Fan

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 Regards
Kccrga
3 REPLIES
Enthusiast

Re: Can't Login into server database after creating system DSN

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)
Enthusiast

Re: Can't Login into server database after creating system DSN

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\ETC

127.0.0.1 cop1 tdpid

A tdpid normally is your databasename.
Enthusiast

Re: Can't Login into server database after creating system DSN

Oops, I was trying to say:

127.0.0.1 tdpidcop1 tdpid