Hi.

I trying to connect a MDB 8.0 (access 97, MSDAC 2.6) and got the same 

problem. I tryed your solution:



<%

strConnect = _

    "Provider=Microsoft.Jet.OLEDB.4.0;" & _

    "Data Source=c:\Inetpub\wwwroot\SPP\SppDados.mdb"

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open strConnect

%>



Unhappynes, didn´t solve the problem...

Here the error:



Microsoft JET Database Engine (0x80004005)

Unspecified error

/SiglasSpp.asp, line 24



browser: 

Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0)



Any ideia ??

Thanks in advance.



--------------------------------------------------------

> OK,

> 

> Let's try something else.

> 

> Firstly, in the Access .mdb make sure that you are opening the database 

in

> "shared mode", not "exclusive mode" - You can set this under "Tools |

> Advanced | Default Open Mode"

> 

> Secondly, let's try to see of the ODBC drivers are at fault. Instead of

> using ODBC, let's use the native OLEBD Provider instead. Your connection

> string should look like this in your ASP page:

> 

> <%

> strConnect = _

>     "Provider=Microsoft.Jet.OLEDB.4.0;" & _

>     "Data Source=c:\databases\db1.mdb"

> 

> ' Obviously you change the path to be the path to your

> ' database that you have!!

> 

> Set objConn = Server.CreateObject("ADODB.Connection")

> objConn.Open strConnect

> %>

> 

> If you still get an error, can you please post it? (OLEDB raises 

different

> error messages to ODBC, so we might be able to get a better idea).

> 

> Lastly, if you're only a WinNT/2k/XP machine, ensure that the anonymous

> internet user account (IUSR_machinename) has sufficient privileges to the

> file and the folder that the file is in (to create and destroy the .ldb

> lockfile).

> 

> Cheers

> Ken

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> ----- Original Message -----

> From: "Peter Ferber" <peterfrb2@y...>

> To: "ASP Database Setup" <asp_database_setup@p...>

> Sent: Tuesday, November 13, 2001 6:21 AM

> Subject: [asp_database_setup] Re: Unable to get ASP script to accept an

> Access 2000 file

> 

> 

> : Sorry, I goofed.

> :

> : I had changed my ASP script which is why I thought I was making 

progress.

> : The problem with the '2000 version is still in effect.  But here's a 

bit

> : of sunshine in the gloom.  Under Tools/Database Utilities/Convert

> : Database/To Prior Access Database Version, I created a new file,

> : Sailors_Converted.  I pointed the DSN to this file; and, again, the ASP

> : script worked perfectly.

> :

> : The problem is now squarely with Access '2000, verified with repeated

> : empirical observation.  And, Ken, my question still stands.

> :

> : Over and out,

> : Peter

> 

>