ASP and databases

[schueymcfee]

I'm writing some shopping cart scripts in ASP, using MS Access DBs. I've been told that Access can only handle 8 connections at a time. Is this true?

Personally I'd like to use PHP and MySQL but the boss wants it in ASP. Can I use ASP with My SQL?

PH is in ASP so what DB is Ted using?

[anonymous-user]

Can't remember the exact number, but yes, it's roughly true. But, this is concurrent db connections - so that's X different web pages running at the exact same time. This could actually be as much as 100X concurrent users as they'll not all request a new page at exactly the same time.

Yes, you can use ASP with MySQL by using the MyODBC ODBC driver through ADO.

And as far as I'm aware, PH runs on a MS SQL db.

[PetrolTed]

Access will cope with a pretty large number of concurrent users (actual concurrent write access is fairly limited even with a hundred or so users).

ASP can indeed be used with MYSQL. It's a great product and very simple to set up. It's actually easier to use than Access if you're familiar with SQL.

[LaurenceFrost]

Just make sure you use a disconnected style of database communication. This basically means do not use persistant connections.

E.G.

1) Open connection
2) Read data (SELECT * FROM MyTable WHERE...)
3) Close connection
4) Format data onto screen

You shouldn't run into problems.

[schueymcfee]

Being able to use ASP with MySQL is good to know for the future.

I think for the amount of hits we're getting at the moment Access sounds like it'll handle it fine.

Thanks guys for the info.