|
|
|
date: Fri, 5 May 2006 15:05:51 -0700,
group: microsoft.public.access.odbcclientsvr
back
MS Access + ASP + ADO + OpenSchema + error - Unspecified Error
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))
if err.number <> 0 then
k =10
end if
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
date: Fri, 5 May 2006 15:05:51 -0700
author: abcd
Re: MS Access + ASP + ADO + OpenSchema + error - Unspecified Error
To quote Jan Hyde
"You really should try one of the dotnet groups, while you
might get a stray answer in this VB6 group, you'd get a much
better response in a dotnet one."
Argusy
abcd wrote:
> 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))
>
> if err.number <> 0 then
>
> k =10
>
> end if
>
> 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
>
>
>
>
>
>
>
>
date: Sat, 06 May 2006 11:12:42 +0930
author: argusy
Re: MS Access + ASP + ADO + OpenSchema + error - Unspecified Error
Why? The poster said "ASP", not "ASP.Net"
I'd think microsoft.public.inetserver.asp.db or
microsoft.public.inetserver.asp.general would be the most appropriate.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"argusy" wrote in message
news:445BFF12.6030509@slmember.on.net...
> To quote Jan Hyde
>
> "You really should try one of the dotnet groups, while you
> might get a stray answer in this VB6 group, you'd get a much
> better response in a dotnet one."
>
> Argusy
>
>
> abcd wrote:
>> 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))
>>
>> if err.number <> 0 then
>>
>> k =10
>>
>> end if
>>
>> 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
>>
>>
>>
>>
>>
>>
>>
>>
>
date: Sat, 6 May 2006 07:14:00 -0400
author: Douglas J. Steele
Re: MS Access + ASP + ADO + OpenSchema + error - Unspecified Error
It sounds like some of the threads are blocked.
Sometimes if you get heavy loading, you can have trouble
with an Access database BE, but basically, this here is the
real reason we don't recommend it: it is just difficult
to update and maintain.
As a quick fix, try bringing down your web server to
reset it.
I would imagine that there would be some other way to
force your ADP datasource to completely disconnect and
reset (correctly closing all cached connections), but
I don't know anything about web servers.
(david)
"abcd" wrote in message
news:usECUAJcGHA.2068@TK2MSFTNGP02.phx.gbl...
>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))
>
> if err.number <> 0 then
>
> k =10
>
> end if
>
> 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
>
>
>
>
>
>
>
>
date: Mon, 8 May 2006 18:54:53 +1000
author: david epsom dot com dot au david@epsomdotcomdotau
|
|
