SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Dec 2000
    Location
    Karachi, Pakistan
    Posts
    913
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I am learning PHP and mySQL as well. I am finding mySQL hard enough.
    Is there any way that I could use Ms Access Database instead of mySQL ?

    If Yes, what would be the syntax for connectiing to it..

    If NO, Why we can't use it ?


    Thanks,
    36Host.com - $36/year web hosting [affiliates earn 30%]
    * Affordable Small Business Web Hosting since 2003! *
    "500mb space, 10gb bandwith, 50 pop/ftp accounts, php,
    mysql, pre-installed php scripts, 24/7 support & more...."



  2. #2
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You should be able to connect to it if your Web server is on an NT/2000 machine. Is it?

    conString = "Driver={Microsoft Access Driver (*.mdb)}; " _
    "DBQ=D:\yourPath\yourAccessDB.mdb"
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  3. #3
    ********* wombat firepages's Avatar
    Join Date
    Jul 2000
    Location
    Perth Australia
    Posts
    1,717
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Works in 95/98 as well.

    if you can set up a DSN for your database (via ODBC in control panel) you can just connect so ...

    $connectionstring = odbc_connect("MyDSN", "user", "pass");

    and then use the PHP ODBC functions.


    If the answer had been no.... the why would have been - MSaccess is fine for desktop work but was simply never designed for the role as a web DB, it can not handle multiple connections very well and tends to corrupt quite easily when under pressure.

  4. #4
    SitePoint Guru
    Join Date
    Dec 2000
    Location
    Karachi, Pakistan
    Posts
    913
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks firepages,


    can you tell me what to use instead of access.

    and does access again corrpts under pressure when being used with asp ?



    thanks,
    36Host.com - $36/year web hosting [affiliates earn 30%]
    * Affordable Small Business Web Hosting since 2003! *
    "500mb space, 10gb bandwith, 50 pop/ftp accounts, php,
    mysql, pre-installed php scripts, 24/7 support & more...."



  5. #5
    ********* Callithumpian silver trophy freakysid's Avatar
    Join Date
    Jun 2000
    Location
    Sydney, Australia
    Posts
    3,798
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Omair,

    Are you using phpMyAdmin in association with your MySQL database? phpMyAdmin is available from www.phpwizard.net . It is handy for setting up database tables and managing a MySQL database. It is a set of php scripts that create a web-form GUI interface to a MySQL database.

    If you are finding it difficult to learn SQL then I suggest you perservere - because SQL is the native language of databases and is fairly consistent between different database systems. So once you do get a fundamental grasp of SQL you will know how to query any relational database. MySQL's implimentation of SQL is probably the most basic amongst popular databases and therefor a good learning point. Find some good tutorials online. My signature links to a thread that discusses good online sources of MySQL info.


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
  •