Wrox Programmer Forums
|
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 23rd, 2004, 01:56 PM
Authorized User
 
Join Date: Jul 2004
Posts: 79
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rajuru Send a message via Yahoo to rajuru
Default Access Database

Dear programmers,

I have a domain www.rubd.net and I hosted it in a unix server.
So far I know, unix does not support ODBC.

But I am familiar with Microsoft Access database. Now I want to use msaccess databases from PHP.

How can I do. Please help me.


__________________
Best Regard:
Md. Zakir Hossain (Raju)

www.rajuru.xenexbd.com - my blog with PHP scripts, PHP Book Review and many more
 
Old August 24th, 2004, 05:04 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 256
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes it does. ODBC was invented for UNIX by the X/Open and SQL Access group. Microsoft just invented the name "ODBC" because they like trying to patent other people's work.

I've come back and edited this, because, on reflection, you're not going to get access to an MS Access database, if you are running on a hosted Unix server (unless you also get access to a hosted Windows server, in which case you are more likely to find yourself with A) a big hosting bill and B) and SQL Server database).

Depending on the flexibility of your hosting agreement, your admins at the hosting provider may be willing to install UnixODBC, if you ask them. Many good ODBC compatible databases exist for the Unix environment, in particular Sybase, PostgreSQL and, of course, MySQL.

The following (my original reply) still generally stands, WRT running ODBC connections to gain access to ODBC compatible databases (which include Microsoft's database software).

Truely open-source ODBC drivers can be found here:
http://www.unixodbc.org/
There is an X-Windows driven GUI for administering the data access, but since you're on managed hosting, that probably isn't relevant to you.

If you just want the familiarity of ODBC, and can dispense with Access, this quick tutorial may help:
http://www.unixodbc.org/unixODBCsetup.html

A number of other alternatives are discussed here:
http://www.phpcenter.de/de-html-manu...tabases.access





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access database database format itHighway Access 0 February 24th, 2008 06:34 PM
Database Connection to Access Database reachsevar ASP.NET 2.0 Basics 1 November 28th, 2007 08:56 AM
Remote access to an Access Project Database bright_mulenga Access 0 February 9th, 2006 10:51 AM
Access issues with ASP and a MS Access Database rj_conceptsnrec.com Classic ASP Databases 2 May 19th, 2005 12:44 PM
using access database in C# chang C# 2 March 18th, 2004 06:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.