ADO with Access problem.

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.

Re: ADO with Access problem.

Aldred wrote:
> 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?

The Open statement is raising the error?

Try compacting and repairing the databae.

--
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"

Re: ADO with Access problem.

> Aldred wrote:
>> 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.


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"

--
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

Re: ADO with Access problem.

John Blessing wrote:
>> Aldred wrote:
>>> 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.
>
>
> 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.

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


--
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.

Re: ADO with Access problem.

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?

"Bob Barrows [MVP]" ¦b¶l¥ó
news:uaNTbAKlHHA.1388@TK2MSFTNGP05.phx.gbl ¤¤¼¶¼g...
> John Blessing wrote:
>>> Aldred wrote:
>>>> 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.
>>
>>
>> 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.
>
> 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
>
>
> --
> 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.
>
>

Re: ADO with Access problem.

"Aldred" wrote in message
news:03BE0772-9270-4372-93E7-86EFD1111348@microsoft.com...
> 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?


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.

--
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

Re: ADO with Access problem.

Aldred wrote:
> 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?
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=8f 0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en&Hash=xaluC W%2bBafY0rpSgcc5HcbvQVbN11BjnANGzJYes9GZ4WbNYIV4EK2BP5El6MsZ rtMz5xYyCkEbE0yr25u3qdw%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
--
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"