THIS is why I hate ASP and Access...

[telophase]

Problem: Test script using test copy of calendar database throws error that indicates problem is probably that database permissions are wrongly set.

Solution (after many hours of beating head against the wall): delete test database, replace with fresh copy of test database set to exact same permissions as original test database.

Gah.

Comments

[txvoodoo.livejournal.com]

*clings to linux and mysql*

Yes, I know, mysql has limitations. but you CAN make it do what you want without jumping through hoops.

I used to teach Access etc. I absolutely hated having to say to students "you know, I don't know exactly WHY it did that." Usually, the true answer would be "Because MS is a big fat piece of crap." *sigh*

[telophase.livejournal.com]

Yupyup. And of COURSE the library is run with a bunch of ASP scripts. :) And after learning ASP and SQL server...next step: learn Perl!

[jarodrussell.livejournal.com]

Mmm... Perl.

After you learn Perl, learn about the DBI (no link, it's easily Googlable). The DBI will completely replace all those nasty, ugly VBScript ODBC/ADO/DSN calls and make your programming simple and fun.

[telophase.livejournal.com]

Oh, good. *makes note*