I am having problems to create a model using yiic shell against an Oracle database.
This stand-alone code using PDO works:
<?php
try {
$pdo = new PDO('oci:dbname=//IP.ADD.RE.SS:1521/schemaname', 'user', 'password');
} catch (PDOException $e) {
die('Connection failed: ' . $e->getMessage());
}
$sql = 'SELECT * FROM TRACKERDB.T_QX_USERS';
$result = $pdo->query($sql);
while($row = $result->fetch(PDO::FETCH_ASSOC)) {
var_dump($row);
}
?>
In the yiic shell, I receive this:
>> model TrackerUser TRACKERDB.T_QX_USERS
Warning: the table 'TRACKERDB.T_QX_USERS' does not exist in the database.
The db config looks like:
'db'=>array(
'connectionString' => 'oci:dbname=//IP.ADD.RE.SS:1521/schemaname',
'username' => 'user',
'password' => 'password'
),
Any help would be appreciated!
Regards,
Joachim