1) what exactly is SQL / MySQL ? I have seen tutorials using it with MS Access and stuff but have no idea what it is
2) If I access a MS Access Database using ASP do I HAVE to use SQL?
3) Where can I find a real in depth tutorial on using MS Access database with ASP, not a really advanced one, just for beginners that really explains all the commands (I am a bit slow you see!)
1. SQL is structured Query language. MySQL is one database system that uses SQL for data access and manipulatio. Others include Access, MS-SQL, Oracle, and Sybase.
2. YES. SQL is the language you need to use to utilize ACCESS data programmatically. This is the same whether your using ASP, C++, Java or Visual Basic.
3. For an indepth tutorial/guide on Access SQL commands or Jet-SQL as it is formally called, go to www.devguru.com and download their JET-SQL guide. For a beginner's look at connecting to a database through ASP check out www.asp101.com or www.4guysfromrolla.com.
Another good site for you to look at is the Microsoft site. There are two subsections in particular interest to your needs. http://msdn.microsoft.com and http://www.microsoft.com/data/
To truly learn try picking up either "ASP 2.0 for Beginners" or "ASP 3.0 for Beginners" from Wrox Press both of which are available at Amazon. Personally I would suggest you start with ASP 2.0 and then move to ASP 3.0 as the added benefits of the new version are over the head of most beginners.
Posting Permissions
Bookmarks