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]
