[MDB] Oracle specific options?
| From: | Thierry Bothorel | Date: | Sat, 24 Jan 2004 16:11:42 +0000 |
| Subject: | [MDB] Oracle specific options? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-10341@lists.php.net to get a copy of this message | ||
Hi,
How am i supposed to create tables with Oracle (with default system users)?
Is this correct :
$dbsys = "oci8";
$db_host = "localhost";
$db_port = "";
$db_database = "mybase"; // already created
$db_login = "SYS"; //
$db_password = "change_on_install"; //use default password
$db_create = 0;
$db_protocol = "tcp";
//****ORACLE*****
$oci8_sid = "mybase";// created with same as dbname
$oci8_home = "C:\oracle\ora81"; //for my windows instalation
include_once("MDB.php");
MDB::loadFile("Manager");
$schema_file = "mrbs.schema.xml";
$variables = array
(
"database_name" => $db_database,
"database_create" => $db_create
);
$dsn = array
(
"phptype" => $dbsys,
"username" => $db_login,
"password" => $db_password,
"hostspec" => $db_host,
"protocol" => $db_protocol,
"port" => $db_port
);
$options = array
(
"SID" => $oci8_sid,
"HOME" => $oci8_home,
);
$manager = new MDB_manager;
$manager->connect($dsn, $options);
$success = $manager->updateDatabase($schema_file, $schema_file . ".before",
$variables);
??
Also, I see in oci8.php
$this->options['DBAUser'] = FALSE;
$this->options['DBAPassword'] = FALSE;
they were used in Metabase oci8 driver for creating database, have they any
use in MDB?
Thierry Bothorel
--
Click below to answer / cliquez ci dessous pour me repondre
http://cerbermail.com/?MQkxTL4vUP