FireFox! The PHP Forum Loans and Credit
Panama Web Design for Hire Free Insurance Quotes!
Web Hosting Advertise Here $10 a Month Designer Children
Never Pay Taxes Again HGH Domain name registration
Web Hosting and Dedicated Servers Insurance Affordable web-hosting


HomeWatched TopicsRegisterSearchDirectory
FAQMemberlistUsergroupsLog inStoresItemsBank
Google

Reply to topic Page 1 of 1
DSNless connection to teradata
Message  
Reply with quote
Post DSNless connection to teradata 
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
 
Code:

  $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=sunil;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
View user's profile Send private message
Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  



Google

FireFox! The PHP Forum Loans and Credit
Panama Web Design for Hire Free Insurance Quotes!
Web Hosting Advertise Here $10 a Month Designer Children
Never Pay Taxes Again HGH Domain name registration
Web Hosting and Dedicated Servers Insurance Affordable web-hosting


Web Design by PlatinumShore.com & Web Hosting by TradeWebHosting.com