Sunday, April 6, 2014

Re: Using ODBC Data Source in Cake 2.4

Hi Borislav
Thanks for your response. I downloaded the odbc.php (in Database folder) and tried to create connection in database.php by tweaking the following but no luck:
public $default = array(
//// 'datasource'=>'Database/odbc',
//                'driver' => 'Teradata',
//                'connect' => 'TeradataProduction',
// 'persistent' => '',
// 'host' => 'TeraProd',
// 'port'=> '',
// 'login' => '',
// 'password' => '',
// 'database' => 'DBA',
// 'prefix' => '',
// //'encoding' => 'utf8',
// );

I am not verse enough in cakephp to extend the PDO. I am surprised to see there is no support for ODBC in cakePHP. Not all organizations uses MySQL/SQLServer or Postgre.

On Saturday, April 5, 2014 12:39:10 AM UTC-7, Борислав Събев Borislav Sabev wrote:
Now that i searched a bit more I saw that There is a Datasources plugin for CakePHP 2.0 but the `Database/Odbc` data source is still incompatible with CakePhp 2.x.
So you should definitely start there!

I also answered your StackOverflow Question in the same way as here. Posting it as reference.

Cheers, Borislav.

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.

No comments: