What should I do if PHP cannot connect to access under win10?

Under Windows 10 system, when using PHP to connect to the Access database, you may encounter the problem of not being able to connect to the database. This problem may affect the work of developers. This article explains how to solve this problem.

First of all, we need to confirm the following points:

1. PHP version: Make sure you are using a PHP version that supports the ODBC extension.
2. Path to the Access database file: Make sure there is no error in the path to the Access database file. It is best to use an absolute path to obtain the database file.
3. ODBC driver installation: PHP needs to use the ODBC driver to connect to Access, which needs to be installed on the Windows system. The installation process can be completed through "Data Sources (ODBC)" in the Control Panel.

If there are no problems with the above points, but you still cannot connect to the Access database, you can try the following solutions:

1. Confirm whether the ODBC driver is running normally: You can use the command Enter "odbcconf /a" into the line to view the list of ODBC drivers. If the ODBC driver is not found or the ODBC driver is not started, you need to reinstall or start the ODBC driver.
2. Confirm whether the ODBC extension configuration in php.ini is correct: Find the "[ODBC]" extension section in the php.ini file and confirm whether the following two configuration items are correct:

odbc.default_db =
odbc.default_user =

When these two configuration items are empty, it means that the current user's identity is used to access the database. If you need to use other identities to access the database, you need to fill in the configuration items correctly.

3. Use DSN to connect to Access: You can connect to the Access database through DSN (Data Source Name). DSN is one of the ways for the ODBC driver to connect to the database. You need to specify the path to the Access database file when creating the DSN. Creating a DSN can be done using the "System DSN" or "User DSN" in the ODBC Data Source Manager (odbcad32.exe).

You need to pay attention to the following points when creating a DSN:

• Click the "Add" button to add a new DSN, and select "Microsoft Access Driver (.mdb )" or "Microsoft Access'97 Driver (.mdb)".
• Fill in the DSN name and description information, and select the Access database file to be connected in the "Database" column.
• Use the following code in the PHP program to connect:

// 使用DSN连接Access
$conn = odbc_connect("dsn_name", "", "");

Among them, dsn_name is the name of the DSN created in step 2.

To sum up, when PHP cannot connect to the Access database, you need to first confirm whether the above points are correct and try the above solutions. If none of the above methods work, you may need to reinstall the ODBC driver and check whether the configuration is correct.

The above is the detailed content of What should I do if PHP cannot connect to access under win10?. For more information, please follow other related articles on the PHP Chinese website!