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
Conneect with Oracle
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
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
