For future reference I am updating this post with my final solution. I could NOT get the linux environment to read a MS Access database even though many others appear to have got this working.
The end result was going back to the generator (proprietary software) of the MS Access data and exporting it in another format (in this case tsv), and importing into MySQL from there. Good luck to anyone who ever has to do something similar - grey hair and sleepless nights await! Cheers Dave T On Sep 21, 9:59 am, teedave <[email protected]> wrote: > Nice thought Bob. You're right, I was quoting it, but unquoting it > gives the same error as leaving it out (SQL error: [unixODBC][Driver > Manager]Data source name not found...) > Oh well, will have to keep looking. > Cheers > > On Sep 21, 12:00 am, Bob Brown <[email protected]> wrote: > > > > > > > > > Just a thought re your fourth parameter, it sounds like it's not being read > > properly (as per it complaining that a string was found where a long was > > expected). Presumably it's a built in constant that either you're specifying > > as a literal string (easy mistake) or PHP doesn't recognise it and is > > casting it to a string for you. > > > Check the spelling of the constant and/or drop the quotes from around it. > > > Cheers, > > > - Bob - > > > On 20/09/2011, at 10:10 PM, Dave Turton <[email protected]> wrote: > > > and if I use one of the 3 cursor types constants specified on > > php.netfunction page, I get the error - odbc_connect() expects > > parameter 4 to be > > long, string ... -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
