migrating to asp and SQL 2000 unwillingly...

happyme

I have promised, as a favour, to help someone sort out their ASP scripting with a SQL 2000 database. All my pevious experience has been php MySQL so I'm a little unsure where to start

Does anyone know of any useful websites or forums like this one for ASP and SQL 2000?

Cheers

Julia

jpmoriarty

try the web developer forum at http://forums.webdeveloper.com/ but i'll warn you - asp is a nasty bugger and very very unlike PHP (IMHO). And i'd stay as far away from it as possible!

tomhath

It's really not as different as you fear.

Instead of php code, you write in VBScript.

Instead of mysql_* functions, you use ADO.

Instead of built-in error handling, you wonder why nothing appears at the browser.

The nasty part of it is that the various components you have to use (ADO COM, scripting, error handling, etc.) seem like they were thrown together without any kind of overall design (probably because they were...).

Here's a reasonably gentle tutorial:

http://www.devguru.com/features/tutorials/ADOandASP/adoTutorial.html

hkucsis

ASP is not difficult to use at all if you know PHP.