ASP Database considerations

I'm new to ASP and databases, however, I'm experienced with HTML and VB. I've built a website for my friends which is similar to friendster.com or myspace.com. Creates profiles, bulletin, chat, calander, login, etc. I read a little about the databases and chose not to use ODBC with a DSN as I read it would be faster to use a connection string.

I am using code like...

Set DB = Server.CreateObject ("ADODB.Connection")
DB.Open ("Provider=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=" + server.mappath(fName))


Everything was going fine until I woke up one morning and none of my pages can access the database. I copied all files to my hard drive and it works fine. I copied all files to a friends host, works fine, but my hosting seems to not support it all of the sudden.

In looking for support I found my host does not offer support unless you are using ODBC. They really are pushing that. I can't change hosts as this one was donated to me a pre-paid a year in advance...

Here's my question...

What is the ideal database connectivity to use (access DB) with consideration on speed/performance and error handling? It's all very confusing... ODBC, OLE DB, DAO, ADO, etc.

Thank you for your time.

I think the provider is faster then the ODBC..

Perhaps your host has certain specifications regarding the location of the database. A previous host of mine had told me that I had to place my Access database in a certain folder, where they had set permissions to.

It could be that your host suddenly changed permissions and what not. Also, find out from them whether they support only DSNs now!

These Reply Not Here,
I'm Very Sorry :blush:

Thanks everyone.

I've ended up putting my entire site on a new server until I figure it out, however, it does look as if there have been permissions set on the folder I was previously using to store the database. I don't know why they changed it and they're slow at getting back to me. They are free though so who's complaining...

Again, thanks for your help.

It was probably like that for security reasons. :)