Current recordset does not support updating this may be bpd dating npd
Connection');$conn-Open("DRIVER=; DBQ=$db");// Driver do Microsoft Access (*.mdb)// must be the name in your odbc drivers, the one you get// from the Data Sources (ODBC).// In this case, I'm in Mexico but the driver name is in portuguese, thanks Microsoft.$sql = 'SELECT username FROM tbl Usuarios';$res = $conn- [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified If you keep running into this on the 64 bit versions of windows, ie server 2008, and none of the other solutions helped.
In a 64 bit windows server operating system, there are TWO odbc managers.
However, it seems that once connected, your odbc session is limited to 30 seconds of active time, after which, the connection becomes stale, and no further queries can be executed.
Instead, it returns a generic "Authentication violation" error from the odbc driver.
All I got is this message: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path.
Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides., SQL state S1009 in SQLConnect in d:\apache\cm\on line 13So...
I wrote a script using the PHP5 CLI binary that monitors a directory for changes, then updates a Network Server SQL Anywhere 8 database when a change was detected.
Idealy, my program would run indefinately, and issue odbc_connect()/odbc_close() when appropriate.
:) Siggy - Windows - OS- Apache- ODBC-Connction to MS-Access DB on a:- Network Share After many hours searching here´s how it works:- Map the Network Drive where the mdb is located- Setup System DSN in Control Panel with mapped Drive- Open Registry at: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC_INI- Edit the for example "M:\" to "\server\..."- Close Regedit- The Apache-Service must run with a Domain (network)-User!!There are lots of posts saying use systems not files, but none (that I have seen) which explain why.Essentially: File DSNs are specific to the current user, therefore the Internet Guest User Account doesn't have rights to them. Regards Osiris :) We've tried hard to connect from php to our IBM DB2 RS/6000 Server.I started looking al around and looks like the ODBC driver has some severe problems:1.It cannot access a Access database via a mapped drive.