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]
