DSNless connection to teradata

[sunilvadranapu]

Hi,

  i have RHEL 5 and tdodbc12(teradata odbc drivers) installed on my box. i want to connect Teradata from PHP using DSNless connection. Could any one tell the connection string for Teradata.

 

  i am using the below connection string which is running on Windows

 

  $con_string = "DRIVER={Teradata};DBCName=sunil;DATABASE=DBC;UID=dbc;PWD=dbc;RunInQuietMode=Yes;
  

 

  But i am getting below error with the same connection stirng on linux:

 

PHP Version 5.2.1 DRIVER={Teradata};DBCName=ramesh;DATABASE=DBC;UID=dbc;PWD=dbc;RunInQuietMode=Yes;

 

ODBC error: [DataDirect][ODBC lib] Invalid string or buffer length

ODBC error code: S1090

 

Connection Failed.....

 

 

whats the wrong with the above connection string. could any one help me in this regard.

 

could you also clear me below doubts in PHP:

  1. does PHP supports DSN less connection on LINUx? 

  2. DSN less feature support should be provided by Database(ODBC drivers) or PHP?

  3. how PHP function odbc_connect() distinguish DSN and DSNless connections?

  4. As for as i know, for DSN connection, odbc_connect should call SQLConnect() and for DNSless connection, it should call SQLDriverConnect().

  5. But for the above connections string, it is calling SQLConnect() even though it is DSNless connection

 

any ideas would be appreciated

 

thanks in advance

 

 

-sun

[sunilvadranapu]

 

 

any suggestions/ideas on this??

[sunilvadranapu]

Hi,

  any one help me on this? is it possible to connect Teradata using DSNless connection? please help me 

 

 

Thanks in advance

 

-Sunil