How does thinkphp connect to the access database?

Source: Internet
Author: User
How does thinkphp connect to the access database recently has a customer who finds his own space. he only supports access database and does not want to change the space. he can only try to use tp with access database. However, I configured it for one afternoon yesterday and worked overtime at night. At first, I couldn't connect to the database. then I searched for related information on the Internet and modified the configuration as follows: & nbsp; 'DB _ TYPE thinkphp how to connect to the access Database
Recently, a customer found his own space that only supports access databases and is not willing to change the space. he can only try to use tp with access databases.
However, I configured it for one afternoon yesterday and worked overtime at night.
At first, I couldn't connect to the database, and then I searched for relevant information on the internet. the configuration was modified as follows:
'Db _ type' => 'pdo ',
'Db _ DSN '=> "odbc: DRIVER = {Microsoft Access Driver (*. mdb)}; DBQ =". getcwd (). "\ dmmovie_data_base.mdb ",
'Db _ user' => '',
'Db _ pwd' => '',

Connected to the database, but now tp throws this error:
[SQL statement]: DESCRIBE dmmovie_page
After reading the system file for a long time, I did not see why, and did not dare to modify the system file. It seems that the configuration is not configured, but I don't know where the configuration is not configured.
For more information, please advise.


------ Solution --------------------
It is unclear that access visual access does not support DESCRIBE statements.
------ Solution --------------------
DESCRIBE
Only supported in a limited database

Of course, access does not support the limit clause. Note that

So thinkphp says it can support fake data from multiple databases.

Also: only access space is supported. can php be supported? Suspect

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.