access to dbase

Abhishek Reddy posted this at 08:26 — 5th July 2001.

Joined: Jul 2001

hi,

i've been asp'ing for about 8 months now , and the only database i've used is msaccess. now, i'm about to start on a new project involving an intranet, and i've decided (along with others) to use dBase. i'd like to know from anyone who experienced it:
[=1]

how applicable is it?

how much different is it in terms of asp code?

is it better/worse?

is there anything especially difficult about it compared to access?

[*]is there anything a programmer who has never used it before should know?
[/=1]

thank you very much for any answers :)[/]

Mark Hensler posted this at 08:34 — 5th July 2001.

He has: 4,048 posts

Joined: Aug 2000

I'm not experience with dBase. I have done enough Access to know the horrors. If you can afford it, go for the motherload and use Microsoft SQL Server.

Mark Hensler
If there is no answer on Google, then there is no question.

Peter J. Boettcher posted this at 13:06 — 5th July 2001.

They have: 812 posts

Joined: Feb 2000

I'm afraid I can't really help you with that one either , the last time I used a dBase product was almost 10 years ago, and obviously wasn't ASP related.

I will second Mark's recommendation that instead of spending your time converting to dBase you should just go ahead and convert to Microsoft SQL Server. I don't think you're really going to see any performance gains by going to dBase since it's not a true RDBMS.

If you're currently using ADO in your ASP pages to connect and manipulate the Access database, then you shouldn't have to change the code to much since the ADO layer should handle most of the translation.

PJ | Are we there yet?
pjboettcher.com

Abhishek Reddy posted this at 01:15 — 9th July 2001.

He has: 3,348 posts

Joined: Jul 2001

hey guys,

thanks for the help and advice. unfortunately, i doubt i will get access to SQL server (forgive the pun). i'll have to start ADO'ing now.....haven't used that much, but i guess the experience is worth it.

thanks agian