CodeIgniter连接SQL Server后无法使用Active Record怎么解决？

Hey there, let's break down your problem and fix it step by step:

What does the error mean? #

The error Call to undefined method CI_DB_sqlsrv_driver::select() tells you that your CodeIgniter SQL Server database driver doesn't have access to the select() method—which is part of CodeIgniter's Active Record system (now called Query Builder in newer versions). This usually happens because the driver isn't properly integrated with the Query Builder functionality, or the functionality isn't enabled.

Can I use CodeIgniter's built-in Active Record with SQL Server? #

Absolutely! CodeIgniter's Query Builder (formerly Active Record) does support SQL Server—you just need to make sure your setup is configured correctly.

How to get your Query Builder code working #

Let's go through the fixes to get your example code running:

1. Verify your CodeIgniter version and driver compatibility #

• If you're using CodeIgniter 2.x: Active Record support for SQL Server was limited in older versions. Consider upgrading to CodeIgniter 3.x or 4.x for better, maintained support.
• For CodeIgniter 3.x/4.x: Ensure you're using the official sqlsrv driver (not the old mssql driver, which is deprecated).

2. Check your database configuration #

Open application/config/database.php (CI3) or app/Config/Database.php (CI4) and confirm:

• dbdriver is set to 'sqlsrv'
• For CI3: $db['default']['query_builder'] = TRUE; (this enables Query Builder)
• For CI4: Query Builder is enabled by default, but double-check that $this->db->allowQueryBuilder = true; is set for your connection.

3. Validate the SQL Server driver class #

In CodeIgniter 3, navigate to system/database/drivers/sqlsrv/sqlsrv_driver.php and check the class definition:

class CI_DB_sqlsrv_driver extends CI_DB_query_builder {
    // ... driver code
}

If it's extending CI_DB_driver instead of CI_DB_query_builder, that's the problem! The driver isn't inheriting Query Builder methods. You can:

• Download the latest official SQL Server driver from the CodeIgniter repository and replace your current driver files
• Manually change the parent class to CI_DB_query_builder (note: this is a quick fix, upgrading is better for long-term support)

4. Ensure the PHP sqlsrv extension is installed and up-to-date #

Your server needs the official Microsoft PHP SQL Server extension installed. Make sure it's compatible with your PHP version and SQL Server version—outdated extensions can cause unexpected issues with driver functionality.

5. Test your fixed Query Builder code #

Once everything is configured correctly, your original code should work:

$this->db->select('*');
$this->db->from('Persons');
$query = $this->db->get();
$data = $query->result();
print_r($data);

(Note: If you haven't already, make sure the database library is loaded—either via $this->load->database(); in your controller, or by adding database to the autoload['libraries'] array in application/config/autoload.php.)

Alternative Active Record/ORM options if you need them #

If you still run into issues with the built-in Query Builder, here are some alternatives:

• Doctrine ORM: A powerful, full-featured ORM that works well with CodeIgniter. It's more heavyweight but offers advanced features.
• Lightweight Query Builder libraries: There are standalone PHP Query Builder tools you can integrate, like illuminate/database (Laravel's query builder, which can be used independently).

That said, fixing the built-in Query Builder setup is almost always the best approach since it's tightly integrated with CodeIgniter.

内容的提问来源于stack exchange，提问作者Arsalan Afridi