Access vs MS-SQL

[sivvaa]

Hi all

Iam facing a bit of problem with a client

He runs a website on ASP using Ms-Access DB.

While using the application, he gets intermittent errors as below :

----------------------
Microsoft JET Database Engine error '80004005'

Unspecified error

/xxxx.asp, line 5


Microsoft JET Database Engine error '80004005'

Unspecified error

/admin/xxxx.asp, line 6

---------------------
Now VORTECH tech people suggested to shift to MS_SQL because Access is NOT that stable. I totally AGREE with that.

When Insisited , the client is refusing to shift because the same application runs fine on another test server.

Does anyone here has a solution for this...?

Thanks

Venk

[kattouf]

Try using a different connection string/driver, that usually fixes access error for me...

[sivvaa]

well,
iam using the JET OLE connection string suggested here..
anyother solid help...?

[Brangwyn]

Compact and Repair the database.

How many simultaneous visitors does his site get? If hes getting more than say 30-40 then it's time to move up from Access. Access quite simply doesn't scale up well. Tell him to future proof his website by moving up to a better DB (MS Access performs even worse on Server 2003 than it does on Server 2000 and at some stage I'm sure Vortech will move up to Server 2003)

[devorem]

Originally Posted by Brangwyn

... How many simultaneous visitors does his site get? If hes getting more than say 30-40 then it's time to move up from Access. Access quite simply doesn't scale up well. ...

You can explain to your client that this is why it is not a problem on the test system. The test server probably only has one user testing at a time.

[mresell]

Yeah even MS says access is not designed for that kind of usage.

[dpyers]

The 80004005 error is kinf of a generic error but it's most typically a permissions problem. IUSR_ has to have read/write/create permissions on the directory containing the access db and on the db itself .

aspfaq has a page that covers it, and other possible errors represented by that code - http://www.aspfaq.com/show.asp?id=2009

[mbarlowm]

I had that same prob on one of my sites here. Vortech told me to use MSSQL which I did and everythign has been working fine (of course, it's MSSQL). The thing is...That site has maybe one use a day... tops. It seemed like something happened that got it stuck in some mode. I tried every connection string and driver in the book. I compacted and repaired. Nothing worked.

[Brangwyn]

Access just isn't robust enough to be used in any kind of loaded hosting environment, it's really designed and suited to smaller workgroup use or as a single user backend for client apps.

[mresell]

Why are so many threads in the wrong place?

[pronx]

MSSQL is scalable.