Re: Using ODBC Data Source in Cake 2.4

Well I don't think there is any support out of the box but I may be very wrong.
Can someone who knows the core super well answer?

Otherwise you can extend the DboSource and connect throgh a PDO just like in this example:

https://gist.github.com/ceeram/3062745

- check the

function connect() {......

Keep in mind that this example is UNSTABLE and most-probably very outdated but it can get you started.

Keep in mind that PDOs have a ODBC Driver.
There is also a seperate Abstraction Layer (like PDO) but for ODBC but it is know for some issues - for example, incompatibility with the package php-recode for some reason.

Anyway, in order to connect to your DSN you can use PDO_ODBC DSN

I personally think it is better to access the ODBC DSN through PDO, however your usage scenario way dictate otherwise.

I will wait for the others to answer.

On Friday, 4 April 2014 00:29:30 UTC+3, Comrade Raj wrote:

Hi, I am newbie to Cake. I have a DSN pointing to Teradata.

How can I configure database.php to use that ODBC DSN. I am currently uing Cake 2.4.6

Thanks alot.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.