Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > MS Access + ASP + ADO + OpenSchema + error - Unspecified Error

Thread Tools

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

Posts: n/a
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 strConnString

set oTmpRs.ActiveConnection = objConn

Set oTmpRs = objConn.OpenSchema(4, Array(Empty, Empty, tmpStrTable,

Set oTmpRs.ActiveConnection = Nothing

set rsColumns = oTmpRs.Clone

set oTmpRs = nothing


end if

set objConn = nothing

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

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


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Object doesn't support this property or method: 'OpenSchema' via A jswidorski ASP General 10 08-04-2009 05:46 PM
MS Access + ASP + ADO + OpenSchema + error - Unspecified Error abcd ASP General 0 05-08-2006 03:30 PM
Accessing an ADO Recordset or Record from ADO.NET nita ASP .Net 1 11-20-2004 07:06 AM
EOF Returned For oConn.OpenSchema( adSchemaForeignKeys ) On SQL Server 2K Dan ASP General 2 10-08-2003 06:42 PM
Ado sort error-Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB. Navin ASP General 1 09-09-2003 07:16 AM