MS Access + ASP + ADO + OpenSchema + error - Unspecified Error

MS Access + ASP + ADO + OpenSchema + error - Unspecified Error

Post by abcd » Wed, 10 May 2006 00:30:41


I am using MSAccess 2003 as my DB, ASP page my front end. My access file is
in the temp folder which ahs IUSR_Machine permissions. My asp page works
fine, connects to DB and retrieves what I want. Now, when I open my db file
in Microsoft Access in Exclusive mode my ASP page doest establish a
connection which is correct as exclusive open locks the files and prevents
further connections. Upto here no problem.


Now when I close that opened Microsoft Access instance, my web page resumes
working. If I refresh it, it works. The third time I refresh the page I get
"Unspecified Error". Again if I refresh it works and again if I refresh I
get "Unspecified error" when I debugged it fails at connection open.

Here is my code snippet..

if strConnString <> "" then
objConn.Mode = 3
objConn.ConnectionTimeout = 30
objConn.CursorLocation = 3 'adUseClient
objConn.open strConnString
set oTmpRs.ActiveConnection = objConn
Set oTmpRs = objConn.OpenSchema(4, Array(Empty, Empty,
tmpStrTable,Empty))
Set oTmpRs.ActiveConnection = Nothing
set rsColumns = oTmpRs.Clone
set oTmpRs = nothing
objConn.Close
end if

set objConn = nothing

Can anybody tell me what's wrong here..what could be the root cause of this
problem..

I tried almost all solutions I know and found in search engines..but not yet
solved this issue..

thanks
 
 
 

1. Unspecified error during ADO Connection (the error show sometimes)

2. Unspecified Error - connecting via OleDb to an Access Database (using ADO.NET)

Hi all,

I have a curious problem: In one place of my WinForms app, a large number of
.ExecuteScalar calls are executed (about 1000). On my PC this fails about
80% way through. I'm using Windows XP Pro SP1.

I've tried to isolate any environmental issues and have tested on:
* a VM running Japanese Windows XP SP1 - works fine
* several colleagues who have English Windows XP SP1 - didn't work for them
* a few colleagues who have English Windows XP SP2 - works fine

The version of MDAC on these different machines vary from 2.7 to 2.8, with
no apparent correlation to the failure/success of the .ExecuteScalar calls.

It appears as if this problem is related to the XP Service Pack (but the
fact that no problems found on Japanese Windows with SP1 contradict this
conclusion).

Has anybody come across this or have any ideas?

Thanks
Joubert

3. Unspecified Error on MyConnection.Open() to MS Access File

4. Unspecified error when trying to Fill oleDB Dataset from MS Access

5. Unspecified Error when trying to access my address book in MS Word

6. Unspecified Error when trying to access my address book in MS

7. unspecified error - when trying to connect to ms access 2007

8. Access 2000 with ADOTable error - Unspecified error

9. Is there an analog of the ADO 'OpenSchema' method in ADO.NET?

10. Internet Explorer Script Error Error 29 Unspecified Error

11. IE 6 RunTime error / Line: 335 / Error: Unspecified Error

12. ADO Connection - Fails - Unspecified Error

13. ADO unspecified error 259 -- NO known solution by Microsoft

14. ADO returns Unspecified error

15. ADO Connection - Fails - Unspecified Error