Sounds like you're in for a bit of fun then. Here's some resources you might find useful:
http://devzone.zend.com/article/4065 (an article on using MDBTools extension for PHP) https://github.com/brianb/mdbtools (Read Access databases on *nix - uses unixODBC to do this) Good luck! Sean On Tue, Sep 20, 2011 at 10:47 PM, teedave <[email protected]> wrote: > Oh, I should've added that this needs to be hosted on a linux > server... > The rest of the site requires it! > > On Sep 20, 10:18 pm, Sean Harvey <[email protected]> wrote: > > I think you have to add a new data source for the database, using the > "ODBC > > Data Sources" (also called "Data Sources (ODBC) on Windows 7). You'll > find > > this inside Administrative Tools on Windows. > > > > More info on that, here:http://www.configure-all.com/php_access.php > > > > Hope that helps! > > Sean > > > > On Tue, Sep 20, 2011 at 10:10 PM, Dave Turton <[email protected]> wrote: > > > Hi all, > > > I have to connect to and extract information from an existing MS Access > > > database - as a local file - previously done with asp. > > > I have tried several methods that google suggested, and settled on > odbc. > > > (Couldn't get adodb to work either). > > > > > The odbc_connect function calls for an optional parameter $cursor_type, > > > which if I leave out I get an error - SQL error: [unixODBC][Driver > > > Manager]Data source name not found.... and if I use one of the 3 cursor > > > types constants specified on php.net function page, I get the error - > > > odbc_connect() expects parameter 4 to be long, string given. > > > > > Has anyone ever had any success connecting to MS Access? Is there a > better > > > way? > > > > > I'm open to special hosting and/or setups, but unfortunately I cannot > at > > > this time get around using this Access database as the data source. > > > > > Thanks > > > Dave T > > > > > -- > > > NZ PHP Users Group:http://groups.google.com/group/nzphpug > > > To post, send email to [email protected] > > > To unsubscribe, send email to > > > [email protected] > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] > -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
