924Board.org

Rick MacLaren · Guest

Yeah...I wanted to program in ASP, Access and VB so IIS with FP Server Extensions 2002 seemed the best choice. I still like ASP but there's a downside to every choice. I'm on an XP Pro platform.

Peter_in_AU · Joined: 29 Jul 2001 Posts: 2743 Location: Sydney, Australia

we all have our crosses to bear.

If it was easy anyone could do it

teo · Joined: 07 Sep 2001 Posts: 637 Location: Hungary, Europe

I've just put up Apache and PHP on my XP machine, accessing an oracle database and it's pretty good so far. I've used ASP a few years ago, but it looks to me PHP is more advanced.

But is there anything to do with it that my 40GB HDD is only 32GB now and the 550 Mhz PIII only runs at 366?

Teo
"On Error Resume Next"

Rick MacLaren · Guest

Yeah well I was faced with a client who wanted to be able to use Access and, more importantly, to be able to upgrade his system any time in the future by programming in additional functionality himself, or with cheap labour. Additionally, his wife wanted to be able to create HTML pages herself. Hence, the Office XP Pro solution.

So the problem with Oracle wasn't functionality, it was that the cost of Oracle programmers tends to be higher than the cost of Access programmers. I think too that if I were going to scale up to something akin to an Oracle say 9i enterprise, I'd have just gone with Sybase's products. I'm biased. But even that would've meant high labour upgrade costs.

Oh, one other detail that crept into this choice: Synchronization. The client wants handhelds with pen scanners to be able to scan products for inventory. Oracle synchronization sucks, deploying Lite on handhelds is impossible, the docs shitty, and a very limited API. So I chose to use Adaptive Server 8.2 on the Palm device with an UltraLite for MobileVB interface. That'll synchronize with any enterprise system, but unfortunately the Oracle Lite won't, according to their docs and my own testing, synchronize competently with anything but Oracle. So there were lots of tradeoffs along this decision path.

[ This Message was edited by: Rick MacLaren on 2002-09-23 00:25 ]

teo · Joined: 07 Sep 2001 Posts: 637 Location: Hungary, Europe

not to mention installing oracle on any platform .... is it just me or they have a few bugs in every install version?

Life would be much easier without clients, you could just concentrate on the job.

Rick MacLaren · Guest

"Life would be much easier without clients, you could just concentrate on the job." No kidding. I've only done about five or seven Oracle installations, one from the CD. The early ones with Oracle 6, 7 and 8.0 were fine. But my last install of 9i over top of an 8i installation blew up. Seems there were registry entries that didn't disappear with the 8i uninstall. So I had to spend a few hours in the registry with a broom.

I find it odd that I have to edit TNSNAMES for even the simplest installation. They make all this GUI support, but it's explained really badly, and the help is now on HTM pages in a browser, not print, so midway through your setup you've gotta go into TNSNAMES and screw with it, then flip back and forth between screens. It's fine as long as you're just 'localhost', but add complexity, and you're screwing with TNSNAMES.

[ This Message was edited by: Rick MacLaren on 2002-09-23 00:38 ]

Joes924 · Guest

Dhook I saw that pic.of your dog and you guys should find a way toput a pc in your 924 or 944 s I guess you can with a laptop alex roy does that..Idont think its in his 924 though.

Joes924 · Guest

Well I had a day off today didnt let my girlfriend know drove around town till noon then decided to go here..
http://shop.store.yahoo.com/partsobsolete/

I was a close to half way there not quite half when traffic was stopped for repaving this rerquired a big detour I said forget it for today I wanted to browse and check this place out really good as I had to be somewhere by 2:45 and had to clean up if I browsed I didnt make it today..