* Earnie Boyd earnie@users.sourceforge.net [130101 18:38]:
The schema doesn't come from the database but from the modules that implement a schema. The schema will exist regardless of which connection you're connected to. http://api.drupal.org/api/drupal/includes%21bootstrap.inc/function/drupal_ge...
Understood. Thank you for the reply. I intended the schema call as sort of a diagnostic. The real goal is to insert data into the 'external' database. So here is the code I have now: // code begins $dba = array ( 'driver' => 'mysql', 'database' => 'dolphy_books', 'host' => 'localhost', 'username' => 'tim', 'password' => '******', 'port' => '3306', ); Database::addConnectionInfo('db1','default',$dba); db_set_active('db1'); $result = Database::getConnectionInfo('db1'); drupal_set_message("<b>Now : Connection Info</b>: <pre>" . print_r($result,1) . '</pre>'); $inserter = db_insert('providers'); // code ends When this code is executed, I get an error: as follows """ Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[HY000] [2002] No such file or directory in db_insert() (line 2398 of /Users/http/sites/daily/includes/database/database.inc).
Additional
PDOException: SQLSTATE[HY000] [2002] No such file or directory in db_select() (line 2491 of /Users/http/sites/daily/includes/database/database.inc).
Uncaught exception thrown in session handler.
PDOException: SQLSTATE[HY000] [2002] No such file or directory in db_merge() (line 2416 of /Users/http/sites/daily/includes/database/database.inc).
""" So what am I doing wrong? Thanks again for the help.