Re: Cakephp 2.X with PEAR:DB drivers
Thanks for your help , i think writting a pear db datasource is a good option. On Fri, May 18, 2012 at 4:11 AM, AD7six wrote: > >> Ok, I wanted to be sure you weren't trying to use the PEAR lib with a db > that is already well supported. > > I know nothing about the status of any mssql dbo driver - but there are > also numerous references pointing at: > > https://github.com/rchavik/datasources/blob/mssql-2.0/Model/Datasource/Database/Mssql.php > > Doesn't that work? > > If you want to use peardb anyway, you have a few options: > > * Use Pear directly - you'll lose ~all model functionality > * Overwrite a few model methods (find, save) to call the Pear db methods > * Write a pear db datasource > > The last option is potentially the best idea as it would mean you can > change the datasource at some point in the future if a better option became > available > > AD > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Abhijit Kakade LAMP Developer, MCP,CCNA Mob : +91-9923729250 -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cakephp 2.X with PEAR:DB drivers
> > > Ok, I wanted to be sure you weren't trying to use the PEAR lib with a db that is already well supported. I know nothing about the status of any mssql dbo driver - but there are also numerous references pointing at: https://github.com/rchavik/datasources/blob/mssql-2.0/Model/Datasource/Database/Mssql.php Doesn't that work? If you want to use peardb anyway, you have a few options: * Use Pear directly - you'll lose ~all model functionality * Overwrite a few model methods (find, save) to call the Pear db methods * Write a pear db datasource The last option is potentially the best idea as it would mean you can change the datasource at some point in the future if a better option became available AD -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cakephp 2.X with PEAR:DB drivers
I am using PHP 5.2 + Mssql 2008 + Linux Server and Cake 2.1.2, latest
version of cake only Sqlsrv drivers that does not work on Linux box.
Because lack of php_mssql drivers in cake i have to use PEAR:DB
drivers with cakephp, also i want strong support for store procedure
calls
that cake in built drivers dosent support.
Pear drivers has good function to call Store procedures like below
$res = $db->getAll("mystoreprocedure", array($param1, $param2,
$param3));
Although i can call SP from cake using $this->query() method but in
this function i have to take care of SQL injection, SP out parameters
etc..
hope you understand the problem.
Thanks,
Abhijit
On May 16, 3:39 pm, AD7six wrote:
> On Wednesday, 16 May 2012 06:37:53 UTC+2, abhikakade wrote:
>
> > Hi All
>
> > I there any way to use cakephp 2.X with PEAR:DB drivers ? i have
> > checked old cake version supports pear connection but not the latest
> > one.. is there any native drivers available to connect with PEAR:DB
> > class ?
>
> Why would you want to do that?
>
> AD
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: Cakephp 2.X with PEAR:DB drivers
On Wednesday, 16 May 2012 06:37:53 UTC+2, abhikakade wrote: > > Hi All > > I there any way to use cakephp 2.X with PEAR:DB drivers ? i have > checked old cake version supports pear connection but not the latest > one.. is there any native drivers available to connect with PEAR:DB > class ? Why would you want to do that? AD -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
