Skip to content
Advertisement

Tag: ms-access

odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

I have some problem in PHP using MS Access database, when I running the query in PHP show error odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect But when I’m going echo the “$query” variable and running the syntax in Microsoft Access is running well. And this is my query: And

PDO connect to .accdb on network

I have an access database which I would like to CRUD with PDO. When My database is stored on C:\wamp\www\test.accdb I can connect. However, the database I am interested in is stored on our office server, at \server1abc123test.accdb . server1 is mapped to drive z: on my computer. My code looks like this (verbatim) both of these give me error:

Advertisement