Hello Community,

I am trying to integrating cakephp, auth and oracle.

I have defined my connection string like below:

var $default = array(
        'driver' => 'oracle',
        'persistent' => true,
        'host' => 'x.x.x.x',
        'login' => 'xxxx',
        'password' => 'xxxx',
        'database' => 'x.x.x.x:1521/JVD',
        'prefix' => '',
        'connect' => 'oci_connect'
    );

Cakephp shows that it is "Cake is able to connect to the database."
able to connect with database.

Now while i am trying to login in my form via auth component, it shows
below mentioned error.

Query:

SELECT User.id, User.username, User.password, User.email,
User.first_name, User.last_name, User.created, User.modified FROM
users User WHERE User.username = 'tapan' AND User.password =
'f5f7714b74b0f0f851830145b10b2a041959e281'

Error:
ORA-00923: FROM keyword not found where expected

Can you please suggest what should i do to remove this issue?

Regards
Tapan Thapa

-- 
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
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to