Re: Conneect with Oracle
thanks so much ^^ I have check it and I can connect to oracle database ^^ I use configuration like this: 'driver' = 'oracle', 'connect'='oci_connect', 'persistent' = false, 'host' = 'localhost', 'port'=1521, 'login' = 'hr', 'password' = 'hr', 'database' = 'xe', 'prefix' = '', and check php_oci8 in PHP- PHP extensions Thank you again ^^ On 22 Tháng Hai, 23:04, Zaky Katalan-Ezra procsh...@gmail.com wrote: Linux? windows? Do you see OCI in phpinfo()? -- 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: Conneect with Oracle
thanks for your helping, but I dont know why it does not work on my project :( On 18 Tháng Hai, 21:35, ojonam manojo10...@gmail.com wrote: Hi, I had a few issues with the configuration as well. Try removing the host name and adding it as a prefix to the database field. Also, specify the 'connect' field. var $default = array( 'driver' = 'oracle', 'connect' = 'oci_connect', 'persistent' = false, 'host' = '', 'login' = 'hr' 'password' = 'hr', 'database' = 'localhost/xe', 'prefix' = '' ); Of course, this is assuming you have installed all the necessary drivers and packages for php to interact with oracle (try googling it in case you haven't). Cheers, ojonam On Feb 18, 1:16 pm, Nguyễn Trịnh Hồng Ngọc nthngoc...@gmail.com wrote: Hello everybody, I'm trying to make a connection between CakePHP and Oracle with configuration database: class DATABASE_CONFIG { var $default = array( 'driver' = 'oracle', 'persistent' = false, 'host' = 'localhost', 'login' = 'hr', 'password' = 'hr', 'database' = 'xe', 'prefix' = '', ); var $test = array( 'driver' = 'oracle', 'persistent' = false, 'host' = 'localhost', 'login' = 'hr', 'password' = 'hr', 'database' = 'xe', 'prefix' = '', );} and it work with the message: Your database configuration file is present. But I don't know why I can't get the data I have a table: posts(id,title,body), and Model class: post.php class Post extends AppModel{ var $name='Post';} controller: posts_controller.php class PostsController extends AppController{ var $name='Posts'; var $scaffold; } if you know, please help me, thanks a lot! Best regard! -- 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: Conneect with Oracle
Linux? windows? Do you see OCI in phpinfo()? -- 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: Conneect with Oracle
This one should work: var $default = array('driver' = 'oracle', 'connect' = 'oci', 'persistent' = false, 'host' = 'localhost', 'port'=1521, 'login' = 'postsUser', 'password' = 'pass', 'schema'='post', //The Oracle slang for what mySql call database. 'database' = 'localhost:1521/xe', //All your application have this same line for localhost schemas 'prefix' = '' ); -- 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: Conneect with Oracle
Hi, I had a few issues with the configuration as well. Try removing the host name and adding it as a prefix to the database field. Also, specify the 'connect' field. var $default = array( 'driver' = 'oracle', 'connect' = 'oci_connect', 'persistent' = false, 'host' = '', 'login' = 'hr' 'password' = 'hr', 'database' = 'localhost/xe', 'prefix' = '' ); Of course, this is assuming you have installed all the necessary drivers and packages for php to interact with oracle (try googling it in case you haven't). Cheers, ojonam On Feb 18, 1:16 pm, Nguyễn Trịnh Hồng Ngọc nthngoc...@gmail.com wrote: Hello everybody, I'm trying to make a connection between CakePHP and Oracle with configuration database: class DATABASE_CONFIG { var $default = array( 'driver' = 'oracle', 'persistent' = false, 'host' = 'localhost', 'login' = 'hr', 'password' = 'hr', 'database' = 'xe', 'prefix' = '', ); var $test = array( 'driver' = 'oracle', 'persistent' = false, 'host' = 'localhost', 'login' = 'hr', 'password' = 'hr', 'database' = 'xe', 'prefix' = '', );} and it work with the message: Your database configuration file is present. But I don't know why I can't get the data I have a table: posts(id,title,body), and Model class: post.php class Post extends AppModel{ var $name='Post';} controller: posts_controller.php class PostsController extends AppController{ var $name='Posts'; var $scaffold; } if you know, please help me, thanks a lot! Best regard! -- 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