Hi
I am asking again .... :(
I am going to connect to my oracle database using odbc and here is my
configuration:
var $default = array('driver' => 'odbc',
'connect' =>
'odbc_connect',
'host' =>
'localhost',
'login' =>
'myschema',
'password' =>
'mypassword',
'database' =>
'sd',
'prefix' => '')
where my tnsname.ora (I have oracle client on my server)
SD= (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.18.1.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sd)
)
)
My ODBC:
Datasource Name: SD
TNS Name: SD
I test it by opening the web on http://localhost/cake/
it said
------------
Your database configuration file is present.
Cake is able to connect to the database.
-----------
I think everything is okay ...
then I create an appmodel : let say: Sj.php
<?php
class Sj extends AppModel
{
var $name = 'Sj';
var $useTable = 'rpic0spahd';
}
?>
and controller: sjs_controller.php
<?php
class SjsController extends AppController {
var $name = 'Sjs';
function index()
{
}
}
?>
then I tried to access : http://localhost/cake/sjs/
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at C:\xampp\htdocs
\cake\app\controllers\sjs_controller.php:10) in C:\xampp\htdocs\cake
\cake\libs\session.php on line 154
...
and
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Oracle][ODBC]
[Ora]ORA-00933: SQL command not properly ended , SQL state S1000 in
SQLExecDirect in C:\xampp\htdocs\cake\cake\libs\model\dbo\dbo_odbc.php
on line 179
Warning: odbc_num_fields(): supplied argument is not a valid ODBC
result resource in C:\xampp\htdocs\cake\cake\libs\model\dbo
\dbo_odbc.php on line 181
My question,
is my configuration correct ? I am not sure ... I looking for guide to
connect with cakephp-odbc but i cannot found any.
thank you
adwin
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
