[MDB] Oracle specific options?

From: 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

« previous php.pear.general (#10341) next »