Unspecified error (1 Viewer)

i have used the following code on my website:

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open strCon

Set rsConfiguration = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblConfiguration.* From tblConfiguration;"

rsConfiguration.Open strSQL,strCon (this is line 152 in the script)

the error i get on executing the script says:
Provider error '80004005'

Unspecified error

line 152


what's wrong here - someone told me tht the connection has not been established successfully but he didnt know what to do
please help

hassaan said:

i have used the following code on my website:

Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open strCon

Set rsConfiguration = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblConfiguration.* From tblConfiguration;"

rsConfiguration.Open strSQL,strCon (this is line 152 in the script)

the error i get on executing the script says:
Provider error '80004005'

Unspecified error

line 152


what's wrong here - someone told me tht the connection has not been established successfully but he didnt know what to do
please help

Click to expand...

Shouldn't that be adoCon?

good!
it worked wonders! thanks a lot

Here's a tough one...

We receive the mysterious "Unspecified error MS Access connection" on the Server debugging (Internal 500 Error on client browser) and we've tried all the traditional fixes. Here is our code that bombs when attempting to connect to the DB in line 3.

set oConn = server.createobject("adodb.connection")
oConn.Mode = 3
oConn.Open "dsn=mydsn;uid=;pwd=;"

1) We have this working on 2 other Windows 2003 servers and it works fine. Just not on this newly created server.

2) The IUSR_ accounts have proper Read/Write (even tried FULL) access to the folder, database file, and the TEMP directories.

3) The DSN tests fine. We've even tried going without the DSN via Server.Mappath without any effect.

4) We are using Plesk 8.1 as the Control Panel that sets up the site, but we can't see that it is causing any interference.

5) We're on Windows 2003 SP1 and using the Microsoft Jet OLEDB 4.0 (for all I can tell).



BUT IT STILL WON'T WORK!!! and I'm pulling my hair out. I've been creating and recreating the site for days now and have read just about every forum to no avail.


Help!?!? *anguish*