sunilvadranapu Posted May 12, 2008 Share Posted May 12, 2008 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 Quote Link to comment Share on other sites More sharing options...
sunilvadranapu Posted May 14, 2008 Author Share Posted May 14, 2008 any suggestions/ideas on this?? Quote Link to comment Share on other sites More sharing options...
sunilvadranapu Posted May 16, 2008 Author Share Posted May 16, 2008 Hi, any one help me on this? is it possible to connect Teradata using DSNless connection? please help me Thanks in advance -Sunil Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.