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
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.