by Gidan » Tue Apr 11, 2006 11:37 pm
I would guess they are using MSSQL; they seem to be very MS based in their development.
ADO stands for ActiveX Data Objects, its more or less a bridge between your programming language (ASP in this case) and you data storage (usually a database though it doesn't have to be). In most cases, its an easier way to get data from your data source without requiring that you understand how to work wit your data source. For example, it allows you to retrieve data from a SQL database without actually knowing SQL.
When it comes to actual coding, I prefer PHP but that’s just me. Personally, I can’t stand java, never liked it from day 1. Part of your decision would be based on what OS your web server will be running. ASP can run on a Linux server, but it runs better on a windows server. If you plan to run a Windows server, ASP is a strong language to work in. Basic HTML is a must, though it’s really easy. XML is also a big plus. PHP and Flash work well also. I am not a huge fan of flash because most people go way overboard with it, if used in moderation; it can defiantly make a great addition to a website. PHP though it has been limited for a time has taken a huge step in PHP5.
You are certainly going to want to work with a database. While I have a lot of experience with this, I think Lyion is probably in a better position to give you more details. My experience lies primarily in MySQL and PostgreSQL. Both IMO are powerful enough for web use, though when it comes to large corporate databases something like oracle is probably better. In your situation I would think MSSQL, MySQL or PostgreSQL would be your best bet. In any case, general SQL knowledge will help you a lot.
I would suggest trying to have at least a basic understanding of ASP, XML, PHP and Flash. At any given time you may not be using them all, but it can’t hurt to see your options. You may find that you have a great idea that just works better in 1 then in another. Another that you may want to consider is Ruby (rubyonrails.org).
Personal preference and style make it really difficult to say you should go 1 way or another. In the end, it really comes down to what your most comfortable working with. PHP being very similar to C++ is where I have always felt comfortable so it was the direction I went, you may find ASP just works for you, if that’s the case, your sites will look and perform far better for using it.
For to win one hundred victories in one hundred battles is not the acme of skill. To subdue the enemy without fighting is the acme of skill.