RE: [PHP-DB] Access with PHP on Linux?
Steve, To clarify, you cannot run Access on Linux. You can install ODBC support for PHP on Linux, and use ODBC drivers to talk to an Access db on Windows. ODBC support for PHP under Linux requires linking PHP with an ODBC Driver Manager. iODBC (www.iodbc.org) is your best bet, and there are HOWTO's on that site for linking --with-iodbc. Also, you will need ODBC drivers; OpenLink provides a free download of our commercial drivers at www.openlinksw.com. Please let me know if you require further assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Steve Farmer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 10:32 PM > To: Andreas D. Landmark; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Access with PHP on Linux? > > > Hi Andreas, > > At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: > >At 13.11.2001 23:23, Chris Payne wrote: > >>Hi there everyone, > > [snip] > > >> > >>I want to keep it an access DB if possible as i've had problems > >>changing the DB to MySQL. > > > >Install ODBC, that would let you interface with degenerate > database formats > >as access et al. > > When you say install ODBC, I assume you mean on the Linux box. Could > you give me a pointer as to the best way to achieve this ? > > [snip > > > > > >-- > >Andreas D Landmark / noXtension > > Regards > Steve > -- > - > "Minds are like parachutes, they work best when open" > Support free speech; visit http://www.efa.org.au/ > > Heads Together Systems Pty Ltd http://www.hts.com.au > Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Access with PHP on Linux?
Hi Andreas, At 11:54 PM + 13/11/01, Andreas D. Landmark wrote: >At 13.11.2001 23:23, Chris Payne wrote: >>Hi there everyone, [snip] >> >>I want to keep it an access DB if possible as i've had problems >>changing the DB to MySQL. > >Install ODBC, that would let you interface with degenerate database formats >as access et al. When you say install ODBC, I assume you mean on the Linux box. Could you give me a pointer as to the best way to achieve this ? [snip > > >-- >Andreas D Landmark / noXtension Regards Steve -- - "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Access with PHP on Linux?
At 13.11.2001 23:23, Chris Payne wrote: >Hi there everyone, > >I have had abit of an emergency, I have a website for a client based on >ASP and ACCESS 2000, but the current server is giving us problems so I >want to move over to my own server. The problem is my server is a Linux >server - is ACCESS 2000 possible? > >My server has support for PHP, ASP, MySQL, etc .. and it says that PHP >is able to interface with ACCESS - but how to hell do you do that? I >haven't got a clue - could anyone please help me as it is dead easy using >a DSN-LESS connection on the current server, but I don't know where to >start here. > >My server runs the latest Red Hat Linux Apache system, with ASP (Don't >remember which version I only know it's not Chilishoft - sorry :-( Latest >PHP, MySQL, FP2000 Ext... CGI and so on. > >I want to keep it an access DB if possible as i've had problems changing >the DB to MySQL. Install ODBC, that would let you interface with degenerate database formats as access et al. Your best solution however would be to ditch Access and go a decent database solution, one that doesn't tend to break under load (and doesn't impose strange limitations on itself with regards to throughput). (on a totally different not, I'd ditch FP extensions aswell, as they've proved to be a bit of a nightmare on the security front in the past, don't know how they're doing at the moment, but anything that tries to imitate something undocumented is a no-no in my production environments). -- Andreas D Landmark / noXtension Real Time, adj.: Here and now, as opposed to fake time, which only occurs there and then. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Access with PHP on Linux?
Hi there everyone, I have had abit of an emergency, I have a website for a client based on ASP and ACCESS 2000, but the current server is giving us problems so I want to move over to my own server. The problem is my server is a Linux server - is ACCESS 2000 possible? My server has support for PHP, ASP, MySQL, etc .. and it says that PHP is able to interface with ACCESS - but how to hell do you do that? I haven't got a clue - could anyone please help me as it is dead easy using a DSN-LESS connection on the current server, but I don't know where to start here. My server runs the latest Red Hat Linux Apache system, with ASP (Don't remember which version I only know it's not Chilishoft - sorry :-( Latest PHP, MySQL, FP2000 Ext... CGI and so on. I want to keep it an access DB if possible as i've had problems changing the DB to MySQL. Thank you for your help it's very much appreciated. Regards Chris Payne www.planetoxygene.com
