ADO with Access problem.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aldred - 11 May 2007 08:21 GMT

Hi,
I am searching for answers for days but I still couldn't figure out what's
wrong. I am hoping someone could help me out.

I have a connection string like this:
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Inetpub\wwwroot\db\db1.mdb;Persist Security Info=False"

However, I am getting an error message saying:
Microsoft JET Database Engine (0x80004005)
An unspecified error occured

Here are some info that you might want to see.
The OS is Windows XP Pro SP2
Access is from Office 2003.
I have set everyone full control in the database and the DB folder.
DB1 is not in use for sure.
DB1 is for sure in the correct place.

Can some one please suggest me a possible solution?

Thanks.

Reply to this Message

Bob Barrows [MVP] - 11 May 2007 10:12 GMT

> Hi,
> I am searching for answers for days but I still couldn't figure out
[quoted text clipped - 17 lines]
>
> Can some one please suggest me a possible solution?

The Open statement is raising the error?

Try compacting and repairing the databae.

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

John Blessing - 12 May 2007 11:29 GMT

>> Hi,
>> I am searching for answers for days but I still couldn't figure out
[quoted text clipped - 13 lines]
>> Access is from Office 2003.
>> I have set everyone full control in the database and the DB folder.

I am pretty sure that "everyone" doesn't include the anonymous user account.
I would explicity add this user (normally iusr_machinename) with full
control.

Also turn off friendly error messages - Tools, Internet Options, Advanced,
Browsing, uncheck "Show friendly HTTP error messages"

Signature

John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

Reply to this Message

Bob Barrows [MVP] - 12 May 2007 15:09 GMT

>>> Hi,
>>> I am searching for answers for days but I still couldn't figure out
[quoted text clipped - 17 lines]
> account. I would explicity add this user (normally iusr_machinename)
> with full control.

I'm pretty sure it does. But there's no harm adding it explictly.

> Also turn off friendly error messages - Tools, Internet Options,
> Advanced, Browsing, uncheck "Show friendly HTTP error messages"

He didn't get a "friendly" error message. he got this:

>>> However, I am getting an error message saying:
>>> Microsoft JET Database Engine (0x80004005)
>>> An unspecified error occured

Signature

Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Reply to this Message

Aldred - 14 May 2007 05:04 GMT

Thanks.

I tried the exact same thing on another Windows XP machine, it does work
perfect. That Windows XP machine has everything as Default.

The only difference is that the "another" of Windows XP machine is in
English while the production machine is in foreign language. And, the
Access 2003 isn't get activated yet. The boss wanted to see it works before
buying a copy. Will a not yet activated Access 2003 throw this problem?

>>>> Hi,
>>>> I am searching for answers for days but I still couldn't figure out
[quoted text clipped - 27 lines]
>>>> Microsoft JET Database Engine (0x80004005)
>>>> An unspecified error occured

Reply to this Message

John Blessing - 14 May 2007 09:15 GMT

> Thanks.
>
[quoted text clipped - 6 lines]
> before buying a copy. Will a not yet activated Access 2003 throw this
> problem?

Don't confuse MS Access the program with MS Access database. Just like
there is MS Word, which can read .doc files, but other programs can also
read .doc (e.g. Wordpad)

As long as you have the correct MS Jet OLEDB drivers on your system, you
don't need MS Access (the program) to use MS Access format databases.

Signature

Reply to this Message

Bob Barrows [MVP] - 14 May 2007 11:49 GMT

> Thanks.
>
[quoted text clipped - 6 lines]
> before buying a copy. Will a not yet activated Access 2003 throw
> this problem?

I'm with John on this one. Access is not required to enable the ability of
ADO to work with Jet databases. Access is more of a front-end tool that
provides the ability to administer various databases (historically, the
"main" backend used by Access was the Jet database, but recent versions have
provided the ability to work with more backend databases) as well as
creating desktop applications that utilize those backend databases.

So, bearing in my mind that I have no experience with internationalization,
I would be more inclined to consider the language differences between the
two machines, particularly the character sets in use. Was the database
created on the machine where your code is producing the error? To remove
Access from the consideration of the problem, try using ADOX on the problem
machine to create a database and attempt to connect to it:

<%
dim newDB, sConn
newDB = "c:\inetpub\wwwroot\databases\new.mdb"
sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newDB

Set cat = CreateObject("ADOX.Catalog")
cat.Create newDB
Set conn = CreateObject("ADODB.Connection")
conn.Open sConn

%>

If this fails, try using MDAC Component Tester
(http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53
-14332ef092c9&displaylang=en&Hash=xaluCW%2bBafY0rpSgcc5HcbvQVbN11BjnANGzJYes9GZ4
WbNYIV4EK2BP5El6MsZrtMz5xYyCkEbE0yr25u3qdw%3d%3d)
to verify that the installation of MDAC on the problem machine is valid.

You may want to bring some Access experts into this discussion

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

Webmaster Forum / ASP / Database Access / May 2007

ADO with Access problem.