连接到访问代码点火器，然后导出到mysql。

Question

此代码有什么问题，请继续“无法使用所提供的设置连接到数据库服务器”。当试图连接access数据库时

public function update_dbx(){
    $loc='Driver={Microsoft Access Driver (*.mdb)};DBQ='.base_url('database\simardi.mdb');
  $confd['hostname'] = $loc;
  $confd['username'] = '';
  $confd['password'] = '';
  $confd['database'] = $loc;
  $confd['dbdriver'] = 'odbc';
  $confd['dbprefix'] = '';
  $confd['pconnect'] = TRUE;
  $confd['db_debug'] = TRUE;
  $confd['cache_on'] = FALSE;
  $confd['cachedir'] = '';
  $confd['char_set'] = 'utf8';
  $confd['dbcollat'] = 'utf8_general_ci';
  $confd['swap_pre'] = '';
  $confd['autoinit'] = TRUE;
  $confd['stricton'] = FALSE;

    $CI = &get_instance();
    $this->db2 = $CI->load->database('db2', $confd);
    $qryx = $this->db2->query("SELECT * FROM INAKTIFMASTER");
    foreach($qryx->result() as $data){
        $this->db->insert('INAKTIFMASTER',$data);
        //print_r($data);
    }

我试图通过上传从accces导出mysql db

我的database.php中有默认和“database.php”数据库配置

编辑

  $db['db2']['hostname'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\xampp\htdocs\site\database\data.mdb';
   $db['db2']['username'] = '';
   $db['db2']['password'] = '';
   $db['db2']['database'] = 'Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\xampp\htdocs\site\database\data.mdb';

$db'db2‘= 'odbc'；

我需要和base_url一起工作

Answer 1

首先，您正在使用base_url()。这并不等于；

C:\xampp\htdocs\site\

对于目录上的访问，可以使用

__DIR__."database/data.mdb"

在执行之前，使用var_dump(__DIR__);并检查您得到了什么。