SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Enthusiast nguip's Avatar
    Join Date
    Apr 2001
    Location
    Malaysia
    Posts
    95
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to access MS Access file on UNIX server ?

    Hi all,

    I got this ecommerce programme running on CGI. It's using a MS Access file for the database.

    Now, I need to intergrate some features and add some script to the site.

    I don't know perl.. unfortunately. I only know php for the moment...

    Anyone know how can I access this MS Access file using PHP ? This MS Access file is not using any database server.. it's access by the CGI program via the script..

    Is there possible with PHP ? I heard of ppl done that by ASP though

    Any help appreciated.
    Ngu I.P.
    Web Developer

  2. #2
    SitePoint Enthusiast nguip's Avatar
    Join Date
    Apr 2001
    Location
    Malaysia
    Posts
    95
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sORRY..

    bUT I just want to make sure this post is in the 1st page...

    Anyone have any idea on this one ?
    Ngu I.P.
    Web Developer

  3. #3
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Out of my area, but wouldn't the current syntax being used with Perl be the same or very similar for PHP connection strings?
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  4. #4
    SitePoint Guru DenverDave's Avatar
    Join Date
    Feb 2001
    Location
    Denver, Colorado
    Posts
    630
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I hope that I'm wrong, but I don't think that you will succeed in connecting to an Access database on UNIX. This would require some sort of interface like an ODBC driver that would run under UNIX. -- Seems theoretically possible, but I have not seen one.

    On the other hand, I have had good luck dumping the access database table to a text file, create a MySQL table by hand and then import the data into MySQL. Seems like both could run under Windows a PHP program could do the same.

  5. #5
    midnight coder
    Join Date
    Dec 2000
    Location
    The flat edge of the world
    Posts
    838
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You would probably put the Access file on an NT machine and make it a ODBC source, then use a networked Unix machine with the PHP scripts to access it.

    Or you could run PHP on NT.

  6. #6
    SitePoint Guru DenverDave's Avatar
    Join Date
    Feb 2001
    Location
    Denver, Colorado
    Posts
    630
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Really? Can we access ODBC datasources from other Servers? Interesting possibilities.....

  7. #7
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I believe the concept of ODBC is to allow universal access.
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  8. #8
    SitePoint Enthusiast nguip's Avatar
    Join Date
    Apr 2001
    Location
    Malaysia
    Posts
    95
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    IC...

    So, I have to put the Access file in an NT server then..
    Ngu I.P.
    Web Developer


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •