SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: SQL Development

Hybrid View

  1. #1
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just wondering what software package is available to produce a sql database?
    Is it sql server?? which would cost me HEAPS!!! or can I use somthing else.
    I know access has an export option but does that create a TRUE SQL database??

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    SQL Server is just one Database system based on the SQL standard. Others include Oracle, Sybase, DB2, Informix, PeopleSoft, Postgres SQL, Pervasive SQL.

    If your just getting started and have a Unix/Linux host or want to work on your local Windows Machine check out MySQL at http://www.mysql.com/. Its is GPL and pretty fast. I would say its a good learning system optimized for web development.
    Wayne Luke
    ------------


  3. #3
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    For information on getting started with MySQL (either on Linux/Unix or Windows), see my article on the subject.
    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Baby’s got back—a hard back, that is: The Ultimate CSS Reference

  4. #4
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok,

    I just downloaded mysql maker, was that the right one?

    anyway I keep getting a message saying "error 10: cannot connect to server"

    I tried localhost and 127.0.0.1 and still get the same message.

    What am I doing wrong.??

    Another question is, If I export my table from access as a ODBC database and use the sql driver, would that canvert the table into a sql database table?

    Thanx In advance

  5. #5
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You need to download the MYSQL database server from the Download page. After that run the executable and install the server.

    Ok a few terms for you to know.

    ODBC = Open DataBase Connectivity
    SQL = Structured Query Language
    DBMS = DataBase Management System (or Server)

    You can not export an Access table as an ODBC file, ODBC doesn't have "files" but it provides ways to connect to different datasources. Access uses a form of SQL to perform database operations. Go into any query and choose "SQL VIEW" off the menu. This form of SQL is called Jet SQL and is specific to Access. MySQL uses MySQL SQL and it has things that are specific to it.

    That being said some things work almost universally. These include commands such as SELECT, INSERT, UPDATE, DELETE and clauses such as WHERE, FROM and LIMIT. Other than that most DBMS try to stick to the SQL standard but often times add their own features and options. I recommend a book on SQL for beginners that covers the main three Database systems in use today (Oracle, Sybase and SQL Server). This will get you started and 90% of what you learn from the book can be applied to MySQL, Informix or any other system including Access.
    Wayne Luke
    ------------



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
  •