title: local XAMPP install connecting to live oracle DB DSN
body: <p>I am using Yii2 locally on my PC, but wishing to connect to our production server DB I have tried the string:</p>
  
  <p><code>'dbname=//host:port/servicename',</code> but it says Connection does not support reading schema</p>
  
  <p>I've never tried to connect Yii2 to oracle before or connect to a live DB. What is the way to achieve this if it is even possible?</p>
  
  <p>I also read this link <a href="https://www.quora.com/How-do-I-connect-Yii-to-Oracle" rel="nofollow">https://www.quora.com/How-do-I-connect-Yii-to-Oracle</a>
  and changed mine to the format mentioned which was</p>
  
  <pre><code> 'db' =&gt; [ 
    'class' =&gt; '\yii\db\Connection',
    'dsn' =&gt; 'oci:dbname=SOME_IP_ADDRESS:PORT/YOUR_SID;charset=UTF8',
    'username' =&gt; 'your_username',
    'password' =&gt; 'your_password',
    'charset' =&gt; 'utf8',
  ], 
  </code></pre>
  
  <p>But I got the same error. Except I am using a service name in place of a SID</p>
  
  <p><strong>Update</strong></p>
  
  <p>Ok, looking at the Yii code</p>
  
  <pre><code>/**
   * Returns the schema information for the database opened by this connection.
   * @return Schema the schema information for the database opened by this connection.
   * @throws NotSupportedException if there is no support for the current driver type
   */
  public function getSchema()
  {
      if ($this-&gt;_schema !== null) {
          return $this-&gt;_schema;
      } else {
          $driver = $this-&gt;getDriverName();
          if (isset($this-&gt;schemaMap[$driver])) {
              $this-&gt;_schema = \Yii::createObject($this-&gt;schemaMap[$driver]);
              $this-&gt;_schema-&gt;db = $this;
              return $this-&gt;_schema;
          } else {
              throw new NotSupportedException("Connection does not support reading schema information for '$driver' DBMS.");
          }
      }
  }
  </code></pre>
  
  <p>The driver isn't supported I think, so how do I found out which ones are?</p>