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]
