Hi, guys
I'm lost in all these types of databases.....I'm currently using Access 2000. I found out just now that mySQL and SQL is much better...Does that mean that it's time for me to learn one of them and when we need to use them instead Access 2000? When connecting to Access thru ASP we need the actual file .mdb located somewhere. But when I saw connection method fo mySQL:
<%
strConnection = "Driver={MySQL};server=mys
Set adoDataConn = Server.CreateObject("ADODB
adoDataConn.Open strConnection
.........
%>
I'm thinking is mySQL doesn't require any .mdb files? what is domain_com_data1???As I understood to create table like:
field1 field2
2 6
3 7
4 8
in mySQL , we have to write script something like CREATE tablename....and so on. Am I right? Sorry , if I'm asking too many questions, but I'm very confused on all this. If anyone could walk me thru basic explanation, I would be very appreciated.
Thanx in advance.
Kouras.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
MySQL and SQL Server also run true dbengine that can track transactions, provide rollbacks, data recovery and reapplication of transactions since last backup, and is alot more stable. Access, you restore a file. Only data you have is since your last backup, and that of what you've coded to retain by writing to a "secondary log or transaction log".
Simply Put, SQL, MySQL are corporate/Enterprise solutions. Access is for mom & pa application. Where losing transactions since last successful backup is acceptable, and query peformance will not exceede 5 queries per second.
Just more 2cents. Keep gettin them and you might get rich
MySQL and SQL are thier own applications. Like Access they are a database Application. Unlike Access they are much more robust. They DO NOT USE a .MDB File.
MySQL and MS SQL Server are thier own applications running a seperate process all the time on a system. MS Access is just a db file. Within the MySQL and MS SQL, there are methods to create new databases. These databases end up associating down to one or many sub files that make up the database. The most simplistic database in MS SQL would consist of 2 files. A MDF and LDF. The MDF is the data file (like an MDB) where the LDF is a transaction log. (Has no association in access). The transaction log consists of ANY change to the database since it's last backup. This gives you the ability to restore a database back to the point of failure without losing any data.
The SQL issued to these different applications is VERY SIMILAR. Subtle changes in available functions, are about it. The basic construct for retreving, updating, removing, or adding data is about the same. More complex functions such as creating tables and views, stored procedures, all of these have subtle differences in the options available, as well as syntax.
From a peformance stand point, once you get above 10,000 records in a table you will see a "WOW that's faster." Access simply does not have the horse power to process large volumes of data. In MySQL or SQL Server, your could be joining millions of records together and still end up getting your results in less than 3 seconds (In Access we would be talking MINUTES). Additionally if you have more than 5 people interacting with your database at one time, your might want to start looking at upgrading.
Again, it boils down to an Enterprise solution vs a Ma & Pa solution. Access works great with small amounts of data. When your business grows beyond a small amount, and performance for an optomized query is taking more than 3 seconds to execute, your probably really needing to look at an enterprise DB, especially if you have multiple users. MySQL, SQL server, DB2, Oracle; all of these are considered to be Corporate or enterprise solutions. The last 2 more so due to thier duration in the market and stability. MySQL is a nice free DB engine, but is missing some of the bells and whistles you get when you pay for one from ORACLE, MSFT(SQL SERVER), or IBM(DB2).
Granted there are other DB makers out there. Pervasive, and SyBase are a couple, but I've listed the major players.
Business Accounts
Answer for Membership
by: KenAdneyPosted on 2003-04-21 at 09:45:38ID: 8367548
Here's my .02...
MySQL has the following advantages:
a) cost (free)
b) platform independence (unix or IIS)
c) ability to handle large datasets (Access bogs down around 10,000 records)
d) distributed load (can be run on a separate server, distributing the load makes things faster)
Access has the following advantages:
a) you know it
b) it has easy queries and reports built into it
Everything else is the same. You're still issuing SQL commands either to access or add to the data (SELECT * FROM), or to create new tables (CREATE xxxx).
Personally, I use Access a lot because it's fast & easy & I don't have to install any components on the server. If I were starting over, I'd be using PHP/MySQL.